Connecting

Hello All:
I have installed MSDE, using Windows Authentication. I can connect to it from a Query GUI tool I downloaded, which has an automatic option of NT Authentication. It does not ask me for a user, and has the password (too long to be my password) already writt
en in. I cannot connect using anything else, including Andrea Montanori's DbaMgr2k. I get a msg:
Login failed for user 'sa' Reason: not associated with a trusted SQL Server Connection.
I am running this on Win XP.
I know I can add users for specific databases, but I think I should be able to log in with 'sa' and the password. Am i getting my own password wrong?
Thanks.
andrew.
Hi Andrew,
This is because you have not enabled mixed mode authenticaton. As an
installation option, enter SECURITYMODE=SQL to enable this.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"andrewnichols" <anonymous@.discussions.microsoft.com> wrote in message
news:E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com...
> Hello All:
> I have installed MSDE, using Windows Authentication. I can connect to it
from a Query GUI tool I downloaded, which has an automatic option of NT
Authentication. It does not ask me for a user, and has the password (too
long to be my password) already written in. I cannot connect using anything
else, including Andrea Montanori's DbaMgr2k. I get a msg:
> Login failed for user 'sa' Reason: not associated with a trusted SQL
Server Connection.
> I am running this on Win XP.
> I know I can add users for specific databases, but I think I should be
able to log in with 'sa' and the password. Am i getting my own password
wrong?
> Thanks.
> andrew.
|||If you don't want to re-install MSDE, you can change the registry key to
enable mixed auth and reset the sa password.
1. use regedit to change HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server\MSSQL.1\MSSQLServer\LoginMode to 2 (mixed authentication) and 2.
execute following query: EXEC sp_password NULL, 'yourpassword', 'sa'
Amy
| From: "Greg Low \(MVP\)" <greglow@.lowell.com.au>
| References: <E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com>
| Subject: Re: Connecting
| Date: Thu, 8 Apr 2004 00:16:44 +1000
| Lines: 36
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ew4j2rKHEHA.688@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.msde
| NNTP-Posting-Host: 66.17.222.193
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13478
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Hi Andrew,
|
| This is because you have not enabled mixed mode authenticaton. As an
| installation option, enter SECURITYMODE=SQL to enable this.
|
| HTH,
|
| --
| Greg Low (MVP)
| MSDE Manager SQL Tools
| www.whitebearconsulting.com
|
| "andrewnichols" <anonymous@.discussions.microsoft.com> wrote in message
| news:E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com...
| > Hello All:
| >
| > I have installed MSDE, using Windows Authentication. I can connect to it
| from a Query GUI tool I downloaded, which has an automatic option of NT
| Authentication. It does not ask me for a user, and has the password (too
| long to be my password) already written in. I cannot connect using
anything
| else, including Andrea Montanori's DbaMgr2k. I get a msg:
| >
| > Login failed for user 'sa' Reason: not associated with a trusted SQL
| Server Connection.
| >
| > I am running this on Win XP.
| >
| > I know I can add users for specific databases, but I think I should be
| able to log in with 'sa' and the password. Am i getting my own password
| wrong?
| >
| > Thanks.
| >
| > andrew.
|
|
|