SQLServer error

  • Thread starter Thread starter '[] WiRaN
  • Start date Start date
W

'[] WiRaN

i'm using SQLserver in other station, in conect event the error happens:

"Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection."

help me?
 
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection."
Click to expand...

This means that your SQL Server´s Authentication mode is set to Windows
only. You can do two things:

1. Set the authentication to mixed mode (Windows and SQL Server)
2. Instead of providing a user and password, use your domain user
credentials by adding "Integrated Security=True" to your
Connection string.

That should do it,
-JG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is MSDTC required to be installed in this scenario? 2
sqlServer - ODBC - WebServices 3
SqlServer ??C# 2
Webconfig settings & aspnet_regsql.exe 2
Login failed for user 'sa'. C#, SqlServer 2000 3
Loading SQLserver database with ASPNET user ID 2
schema compare problem 4
DateTime conversion to its sqlServer datetime float representation. 1

Back
Top