SQL Server Performance Forum – Threads Archive

user sa

hi
when i try to enter the user sa
using SQL server Authoration
i cant … and this is the error message : TITLE: Connect to Server
—————————— Cannot connect to TOOLSBOXSQLEXPRESS. ——————————
ADDITIONAL INFORMATION: Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) For help, click:http://go.microsoft.com/fwlink?ProdName=Mi…52&LinkId=20476 ——————————
BUTTONS: OK
——————————

Have you set sql authentication in sql server? Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Switch to Mixed Mode Authentication or Windows Authentication only. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Looks like you are using sql authentication while the mixed mode authentication is off during installation. You can turn on mixed mode authentication or use intergrated authentication. —————————————-
http://dineshasanka.blogspot.com/

Looks like someone googled and found that entry in the MSDN forums. [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>

Please post the quesion in relevant forums only.
Referhttp://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx for further explanation. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>