SQL Server Authoration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Authoration

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?Prod…52&LinkId=20476 ——————————
that is was the error message when i try to login using SQL Server Authoration …..
when i try login with user sa or any user i creat it
i am using SQL Server 2005 Express
what i have to do ???
note i checkd the user SA and there is no red arrow beside him
thank you
What kind of authentication do you have set in SQL?.
May you have set Windows Authentication only and not Windows and SQL authentication. Luis Martin
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
i made it