I'm having a new issue with Recovery Solution 6 SP1 on NS 6 SP2. I have a primary NS server running W2K3 without SP1. SQL is running on a seperate server with same OS without SP1. I have RS on this server managing my main office. I have a secondary office with an RS installed on one server and SQL on the other. These servers are running W2K3 with SP1 (not my idea). When I try to run reports again the secondary office Cluster I get errors that: 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I have checked the credentials on all my servers and they are the same. SQL is set to mixed mode on bother servers. I'm at a loss. Any ideas? For Example: Sql error in query. Error: System.Data.SqlClient.SqlError: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- EXEC dbo.sp_AeXCRReportClients @in_ClusterGuid = 'FCB5B7AF-4978-47B1-AD95-0371410F19DD', @in_User = '%'
What this sounds like to me is the account you used/specified in the setup of RS to communicate with the DB is not setup properly and does not have proper rights to the DB.
Figured it out Turns out the linked server lost it's credentials. All I had to do was manually plug in the userid and password. So in SQL Enterprise Manager browse to Security, Linked Servers, Right Click on the Server in question and select properties. Click on Security tab, and change the radial to select 'Be made using this security context. In this instance I needed to use 'aexrsdatabaseuser' and the default password; which is password. I don't know how this broke but this fixed it.
