| Author |
Message |
unclebiguns
Joined: 13 Apr 2010
Posts: 11
|
 Posted: Tue Apr 13, 2010 5:00 pm Post subject: Can't Change Back to Alert Repository Account for SQL Server |
 |
|
As part of my evaluation of SQL Response I was attempting to see if I could get it to work with an account that does not have SQL Server sysadmin privileges on the SQL Server. So I went into the server properties and changed the Account Credentials to log in to the SQL Server Instance to use SQL Server authentication with a SQL Server login that I had created with the rights I believe that it needed to gather the information SQL Response needs. I realize that the documentation states it needs SA privileges, but as this is an evaluation I thought it was worth at try. At any rate, it did not work so I changed back to Windows Authentication using the Repository Account. It is still not working. It appears that the change is not actually occurring. Any suggestions?
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008 |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Thu Apr 15, 2010 1:02 pm Post subject: |
|
|
Hi Jack,
When using Windows Authentication, SQL Response will connect using the service account of the Alert Repository. In order for Response to work properly, that Windows account would need to belong to the SYSADMIN role of the server.
What indication do you get that SQL Response isn't working in your latest configuration?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
unclebiguns
Joined: 13 Apr 2010
Posts: 11
|
| Posted: Thu Apr 15, 2010 3:53 pm Post subject: |
|
|
Indications are that when I click Test Credentials I still get the Incorrect User Name or Password error and I am regularly getting SQL Server Unreachable Alerts when I know the SQL Server IS reachable. I am also not receiving alerts when I know I should be receiving them. For example I specifically set up a job that will fail and I am not getting the job failed alert.
Lastly, I ran a profiler trace for 2 days and never saw any activity from SQLResponse on the SQL Server and I assume I should have seen something as it checks for problems. It is possible I was missing an evnet, but unlikely I think.
I know the account has sysadmin access because I originally set up SQLResponse using this account and it worked fine. The problem started when I tried experimenting with a SQL Server login to see if I could make SQL Response work with a non-SA login and then changed back.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Thu Apr 15, 2010 6:22 pm Post subject: |
|
|
Hi Jack,
Did you try simply restarting the Alert Repository service on the SQL Response server?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
unclebiguns
Joined: 13 Apr 2010
Posts: 11
|
| Posted: Thu Apr 15, 2010 6:32 pm Post subject: |
|
|
Yes, I restarted the alert repository service and I rebooted the PC (my workstation) that it is installed on.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Fri Apr 16, 2010 9:00 am Post subject: |
|
|
Hi Jack,
Please email the SQL Response Alert Repository log to support@red-gate.com, and quote "F0033519" in the subject line. You can get the log from the repository server in the %allusersprofile%\application data\red gate\logs\
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
unclebiguns
Joined: 13 Apr 2010
Posts: 11
|
| Posted: Fri Apr 16, 2010 2:43 pm Post subject: |
|
|
Brian,
I will still send the error logs, but knowing where to look helped me solve the problem. I had chosen in the beginning to encrypt the connection to the SQL Server and it worked at the beginning, but changing the credentials apparently caused this to fail as I know get a certificate chaining error. By not encrypting the connection I SQL Response now connects properly.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Fri Apr 16, 2010 2:52 pm Post subject: |
|
|
It's probably a certificate problem. I'll bet if you get the SQL Server's certificate and put it in the alert repository user's certificate store, that may get it working.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
