Groups | Blog | Home
all groups > sql server (alternate) > july 2003 >

sql server (alternate) : SA Login failure


jpeter80 NO[at]SPAM hotmail.com
7/17/2003 9:10:33 PM
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

johnbandettini NO[at]SPAM yahoo.co.uk
7/18/2003 2:33:13 AM
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

Erland Sommarskog
7/18/2003 8:40:48 AM
Jim Peter (jpeter80@hotmail.com) writes:
[quoted text, click to view]

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, sommar@algonet.se

Books Online for SQL Server SP3 at
jpeter80 NO[at]SPAM hotmail.com
7/18/2003 7:56:44 PM
Thanks a million guys!!
Enabling SQL authentication in Enterprise Manager fixed my SA account login problem.

Ciao.



[quoted text, click to view]
AddThis Social Bookmark Button