SQL Server: beginner: "Login failed for user 'sa'."

From: R.A.M. <r_ahimsa_m@xxxxxxxxxxxxxx>
Date: Sun, 05 Mar 2006 09:28:32 +0100

Hello,
(Sorry for my English first...)
Could you help me please with SQL Server problem? I suspect that my
problem has simple solution but I have little experience.

I have installed SQL Server 2005 and I am installing some application
using it - unfortunatelly setup fails because I cannot logon to SQL
Server in SQL Server Authentication, account sa, password sa.
Thus I checked SQL Server Management Studio Express: I have 'sa'
account, password 'sa' (because I had prepared it), unfortunatelly I
cannot logon in SQL Server Authentication (sa/sa) because of:

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

Could you help me plase...
Thank you very much.
/RAM
.

Follow-Ups:
- Re: SQL Server: beginner: "Login failed for user 'sa'."
  - From: Jens

Prev by Date: Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
Next by Date: Re: SQL Server: beginner: "Login failed for user 'sa'."
Previous by thread: Space Available Within A Filegroup
Next by thread: Re: SQL Server: beginner: "Login failed for user 'sa'."
Index(es):
- Date
- Thread

Relevant Pages

Re: Connexion to SSIS
... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
(microsoft.public.sqlserver.dts)
Re: Login Failed For User
... Asp.net app runs under aspnet local windows account. ... You are using windows authentication in connection string for sql server. ... You might use sql server authentication, ...
(microsoft.public.dotnet.framework.adonet)
Re: Connexion to SSIS
... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
(microsoft.public.sqlserver.dts)
SA password
... That's of course if your NT account has SA priveledges. ... you do not, and you did not delete the builtin admins, you ... >Right click on your SQL Server in the Enterprise Manager ... >and then change back to Use SQL Server authentication, ...
(microsoft.public.sqlserver.security)
Re: Autonumbers vs Identity Key
... it's not a SQL Server problem ... move to SQL Server Access Data Projects and stfu, ... I then had to make bF9 true before doing the recalc, ... Tony Toews, Microsoft Access MVP ...
(microsoft.public.access.conversion)