login options

Thanks, Amy.
I have tried this, but my path does not lead as written, and no paths lead to \login.
I don't have MSSQL.1
At that point in the path I have \80. this will lead to \Replication\DatabaseReconciler\MSSQLServer or
\Replication\MergeReplicationProvide\MSSQLServer
each of these paths contain only a file named "default"
no paths lead to \login
I would prefer to learn to do this in a way that does not involve reinstalling since I have already learned how to do that, and Registry Editor is new to me, so I want to learn about it.
I have been able to connect using NT Authentication now. The DB Manager was just set to SQL login. Still, it has done the login automatically without me adding myself as a user. Is this because the computer already has me set as the administrator with my
windows login? I have never been asked for a password. Is that because I am already logged into windows?
From what I have read, it seems that NT Authentication is preferred for security, and I can still add users by adding their windows user name. Is this correct? Is it more difficult or less precise than using mixed mode with SQL logins?
THanks tons to anyone who replies.
andrew.
-- Amy Yuan [MS] wrote: --
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.
|
|
|
Hi Andrew,
Try edit this key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\LoginMode to
2. I gave you the wrong path last time.
As for your authentication question, you are using Windows Authentication
mode (default). Once you are logged in, it will use your Windows credential
to connect to the database server. Windows auth works the same as SQL
auth. To use SQL auth, you need to have SQL auth enabled and then you can
login as sa (system administrator) or new user. You can add a new SQL auth
user by executing sp_addlogin. SQL auth users are not Windows users. They
can only connect to the databases that they have permission to and do
database operations.
Hope this helps.
Amy
| Thread-Topic: login options
| thread-index: AcQddiDBjvDdBleuQZGSNAVW1yfSkA==
| X-Tomcat-NG: microsoft.public.sqlserver.msde
| From: "=?Utf-8?B?YW5kcmV3bmljaG9scw==?="
<anonymous@.discussions.microsoft.com>
| References: <E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com>
<ew4j2rKHEHA.688@.tk2msftngp13.phx.gbl>
<318sKtOHEHA.3704@.cpmsftngxa06.phx.gbl>
| Subject: login options
| Date: Thu, 8 Apr 2004 07:31:06 -0700
| Lines: 92
| Message-ID: <B16333BA-1C45-4885-BB8C-C37F42DC86CD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13508
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Thanks, Amy.
I have tried this, but my path does not lead as written, and no paths lead
to \login.
I don't have MSSQL.1
At that point in the path I have \80. this will lead to
\Replication\DatabaseReconciler\MSSQLServer or
\Replication\MergeReplicationProvide\MSSQLServer
each of these paths contain only a file named "default"
no paths lead to \login
I would prefer to learn to do this in a way that does not involve
reinstalling since I have already learned how to do that, and Registry
Editor is new to me, so I want to learn about it.
I have been able to connect using NT Authentication now. The DB Manager was
just set to SQL login. Still, it has done the login automatically without
me adding myself as a user. Is this because the computer already has me set
as the administrator with my windows login? I have never been asked for a
password. Is that because I am already logged into windows?
From what I have read, it seems that NT Authentication is preferred for
security, and I can still add users by adding their windows user name. Is
this correct? Is it more difficult or less precise than using mixed mode
with SQL logins?
THanks tons to anyone who replies.
andrew.
-- Amy Yuan [MS] wrote: --
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.
|
|
|
|