May 12, 2006 at 6:32 am
I am short of ideas now so I need help. The scenario is that I've got a 2 node cluster A/P running SQL 2KSP4 on Win2k3 that has an application that connects to SQL Server via ODBC connectivity. The application uses windows login to connect to SQL Server. The application works ok when SQL Server is running on node 1 but when you failover to node 2 the application comes up with an error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
When SQL Server is running on node 1 I'm able to connect to SQL Server from both nodes but when I move resources to node 2 I'm no longer able to connect to SQL Server from node 1, but I'm able to connect to SQL Server from node 2 when SQL Server is running from node 1 but not the other way round. Can someone help me out here because the first thought that came to mind was SP level but its SP4.
May 12, 2006 at 7:47 am
is the login a member of builtin/administrators?
if the service is failed over on node 1 where your user login is a member of local admins, but not a member of local admins on node 2 then you will lose login priveledges when the system fails over unless you are explicitly named in the list of logins in sql server
MVDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply