I'm using sql server with my asp.net project.
at starting there was no any problem,it was working well.
but now it gives an error
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
so whats the problem .


abhinavjain

__________________
abhinavjain

Hi there,

Change the authentication from WINDOWS ONLY mode to SQL SERVER AND WINDOWS mode. That should solve the problem.

Refer this link - Login Failed for User 'USERNAME', Not Associated with a trusted SQL Server Connection.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi vijay
I had changed the authentication,but still here is same problem.
and also unable to open the "enterprise manager".
I installed the service pack 4 & 3 for sql 7,is it any reasion for the problem.

abhinavjain

Not sure if that could be the reason.

_________________________
- Vijay G
Strive for Perfection

Hi,

Check ur SQL server authentication mode. Ur logging in with USer sa, so it seems u r using SQL Authentication. If so u must supply a valid password for that login. Check the Authentication mode and see the login info (Rclick the Server and then select Properties. Varify that u r using correct Service account also.

Be sure about the password u r using for sa.

B. Anant

Are you using a DSN to connect? Has the sa password changed? Which type of authentication are you using with the ASP.NET project?

Please do not use the sa password for anything. Not even testing. I do not understand why this is done.



Sal