October 20, 2005 at 5:09 pm
We have 2 failover servers and one client in our test environment. We have all the three configured in mixed mode authentication(windows + sql server authentication). But when we are failing over from 1st server to 2nd one, we are getting the following error message,
'Unable to connected to server xxxx: Server : Msg 18452, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'null'. Reason: Not associated with a trusted SQL server connection.'
I got some clue.
For instance we have ser1 and ser2 as clusters. I registered both in the client's EM. Now what I did was, I made ser1 to run and stopped sql service in ser2 (active/passive) through failover. Now in the client's EM I'm able to open ser1 and I cannot access ser2. Now what I did was, I failed over to ser2 ( so sql service in ser1 is stopped). But now I can still be able to access ser1 and also I can access ser2, even I'm able to open query analyzer in ser1 through EM.But when I try to open query analyzer directly, it is giving the same error message. ser1 is the virtual name given to both ser1 and ser2. So I think when connecting through EM, failover is occuring fine.I'm just wondering why is this happening only with dsn. Can anybody help me?
October 24, 2005 at 8:00 am
This was removed by the editor as SPAM
October 26, 2005 at 7:29 am
Hi Preethi,
Can you check whether the user is having proper permissions. Mostily this error will occur due to permission problems. If you have more than one domain verify whether the user is being trusted in the domain in which the sql server exists.
with smiles
santhosh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply