Not Associated with a trusted SQL Server connection

[LMzizi]

Hi guys;
I m trying to connect to server but this is the message I get

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

pls guys help me I need to meet my due date next monday

[sashi]

Hi guys;
I m trying to connect to server but this is the message I get

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

pls guys help me I need to meet my due date next monday

Hi there,

We need more information to solve the issue in return. The error message seems to be clear isn't it? I feel that you are not providing the correct "sa" / administrator password of the SQL server.

Anyway, are you working in LAN? Are there more then one domain exist in your LAN? Please provide these details in order to get a fast & better respond. Good luck & Take care.

[LMzizi]

Hi there,

We need more information to solve the issue in return. The error message seems to be clear isn't it? I feel that you are not providing the correct "sa" / administrator password of the SQL server.

Anyway, are you working in LAN? Are there more then one domain exist in your LAN? Please provide these details in order to get a fast & better respond. Good luck & Take care.

yes I'm using LAN and we have more than one domain

[sashi]

yes I'm using LAN and we have more than one domain

Hi there,

I assume you are trying to connect to an SQL server of an untrusted domain, you need to ask your system administrator to enable domain trust relationship, hope it helps. Good luck & Take care.

[muzammilmansuri]

Hi guys;
I m trying to connect to server but this is the message I get

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

pls guys help me I need to meet my due date next monday

Login failed for user; Reason: Not associated with a trusted SQL Server connection

Login failed for user "USERNAME-HERE." Reason: Not associated with a trusted SQL Server connection.

This error most commonly occurs when using SQL authentication, rather than Windows Authentication. There are a few reasons to use SQL authentication rather than Windows:

Client is not runnig a domain
Network contains PC's running Windows98
To enable both authentication protocols:


Go to Enterprise Manager.
Right Click on Server Name
Select Properties
Go to Security Tab
Set authentication to SQL Server and Windows

Hope this solves your problem