Unix Technical Forum

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

This is a discussion on SQL Server: beginner: "Login failed for user 'sa'." within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, (Sorry for my English first...) Could you help me please with SQL Server problem? I suspect that my ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-29-2008, 07:35 PM
R.A.M.
 
Posts: n/a
Default SQL Server: beginner: "Login failed for user 'sa'."

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-29-2008, 07:35 PM
Jens
 
Posts: n/a
Default Re: SQL Server: beginner: "Login failed for user 'sa'."

If you want to use the "sa" account which uses SQL Server
authentication, you have to setup your server for mixed authentication,
unless you do this you are only allowed to use Windows (Integrated)
Authentication.

HTH, Jens Suessmeyer.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:21 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com