CODEWITHSUNDEEP
c#sql-server
AjayR
AjayR

Reputation: 4179

SQL Server remote connection problem

I installed SQL Server 2005, and crated one user.

I am able to connect from the same systen, but while connecting from other system on the LAN it showing the error like below

login failed for the user xxxx. The user is not associated with a trusted sql server connection.

I googled the issue but nothing is sorted out for me. Even some posts on StackOverflow, where it mention to use SQL Server and Windows Authentication also didn't help.

Upvotes: 0

Views: 351

Answers (2)

2GDev
2GDev

Reputation: 2466

Maybe there is an extra step you have to accomplish... Try to enable the TCP/IP trasport on the Configuration in SQL Server Surface Area Configuration.

This link can help you :

Configure MS SQL Server 2005

Upvotes: 1

DimonZa
DimonZa

Reputation: 954

Try to set SQL Server and Windows authentication mode in server property. Enterprise Manager -> Right click on the server -> Properties -> tab Security -> Authentication: SQL Server and Windows authentication instead Windows Authentication mode

Upvotes: 1

Related Questions