SA Login failure

[Jim Peter]

Hello , this is my first posting in this group.
I am running SQL server 2000 on my windows 2000 server box. I use it
for my Siebel database.
When ever I launch Query Analyzer and chose SQL Server Authentication
I get the error message below:

[Microsoft][ODBC SQL Server driver][SQL Server]
Login failure "SA" Not associated with a trusted SQL server
connection.

The funny thing is that if I use Windows Authentication the login
works.
I checked Enterprise Manager and the SA account is present.

Any help appreciated .

SQL newbie

Thanks.

[Erland Sommarskog]

Jim Peter (jp******@hotmail.com) writes:

Hello , this is my first posting in this group.
I am running SQL server 2000 on my windows 2000 server box. I use it
for my Siebel database.
When ever I launch Query Analyzer and chose SQL Server Authentication
I get the error message below:

[Microsoft][ODBC SQL Server driver][SQL Server]
Login failure "SA" Not associated with a trusted SQL server
connection.

Apparently the server is not configured for SQL authentication.

This is something you can configure in Enterprice Manager. Right-click
server, select Properties and then the Security tab.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[John Bandettini]

SA account may be present, but it sounds like you do not know the
password. Is there someone who would know? If you are logging in as
local or domain admin trusted account you should be able to change it,
but be sure no one else is using it.

Regards

John

[Jim Peter]

Thanks a million guys!!
Enabling SQL authentication in Enterprise Manager fixed my SA account login problem.

Ciao.

Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@127.0.0.1>...

Jim Peter (jp******@hotmail.com) writes:

Hello , this is my first posting in this group.
I am running SQL server 2000 on my windows 2000 server box. I use it
for my Siebel database.
When ever I launch Query Analyzer and chose SQL Server Authentication
I get the error message below:

[Microsoft][ODBC SQL Server driver][SQL Server]
Login failure "SA" Not associated with a trusted SQL server
connection.

Apparently the server is not configured for SQL authentication.

This is something you can configure in Enterprice Manager. Right-click
server, select Properties and then the Security tab.