Groups | Blog | Home
all groups > sql server programming > february 2007 >

sql server programming : trying to use sql server authentication


Bob
2/24/2007 9:17:03 PM


.......but I'm getting this message...

Login failed for user 'sa'. The user is not associated with a trusted
SQL Server connection. (Microsoft SQL Server, Error: 18452)

Can anyone help?
Hari Prasad
2/24/2007 11:34:19 PM
Hello,

By default SQL Server accepts only logins through Windows authentication,
and you must explicitly permit SQL authentication by setting the Mixed mode
(Windows and SQL Authentication).
You can change this from SQL Server Management Studio. Right-click the
server itself , select Properies and then find the Security page and change
it to
"SQL Server and Windows Autghentication mode".

Thanks
Hari

[quoted text, click to view]

AddThis Social Bookmark Button