Monday, March 19, 2012

Login failed

login failed for user 'sa'. Reason: Not associated with a trusted SQL Server ConnectionWhat's your point? :)|||well would you be more precise in explaining how you got that and what issue you want to resolve ???|||well would you be more precise in explaining how you got that and what issue you want to resolve ???

I Got error when tried to login in Query Analyzer.|||Are you connecting using windows authentication or SQL server authentication (enter username & password)? We can assume but it's best if you provide us with all the facts :)|||Hi
Change your authentication properties to MIXED MODE.

Generally you get this type of message when you instal SQL server with windows mode authentication

Hope this will help and solve your problem.

No comments:

Post a Comment