Re: Failure to Login
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/04/04
- Next message: J Young: "Re: JDBC driver for MSDE 2000 Release A"
- Previous message: fgbrooks: "Failure to Login"
- In reply to: fgbrooks: "Failure to Login"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Failure to Login"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Failure to Login"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 10:09:15 +0530
Hi,
By default, the MSDE was install with OS Authentication . But windows 98
will not support OS authentication.
To use MSDE on Win 98, use have to use SQL Server authentification . To use
the SQL authetification on MSDE, see readme.txt
with the MSDE.
How to change the model after installation: (Need to modify registry)
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
Change the value to 0 or 2 for mixed-mode or 1 for integrated. (Integrated
is the default setup for the SQL Server 2000 Data Engine.)
Note The 0 and 2 values have the same functionality. They both set the
security to mixed-mode.
To set this key to mixed-mode (SQL Authentication and OS Authentication) ,
follow these steps:
1.. Stop SQL Server and all related services, such as SQLAgent, from the
Services control panel.
2.. Click Start, click Run, type regedt32, and then click OK.
3.. Find the HKEY_LOCAL_MACHINE window on the local computer.
4.. Navigate to the following registry key for the default instance:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer
5.. Navigate to the following registry key for a named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
6.. On the right-hand pane, find the value LoginMode and double-click it.
7.. In the DWORD Editor window, set the value to 0 or 2. Also, make sure
that the Hex radio button is selected.
8.. Click OK.
Restart SQL Server and SQL Server Agent services for this change to take
effect.
After these try conecting using the below command from command prompt.
OSQL -Usa -Sserver_name
Thanks
Hari
MCDBA
"fgbrooks" <anonymous@discussions.microsoft.com> wrote in message
news:7c3801c43173$af8c8b00$a601280a@phx.gbl...
> I have installed a brand new msde2000, in order to get SQL
> Service Manager. The SQL Service Mgr is installed, and it
> shows up in my tray with the little green arrow. I
> installed the msde following the instructions in the MS
> Knowledge base article 319930, How to Connect to MSDE. I
> installed it with the SECURITYMODE=SQL parameter. I used
> the osql command to give it a new password. So far so
> good. Now, following 319930, I tried a connectivity
> test. I get the following error message: Test Connection
> failed because of an error in initializing provider.
> Login failed for user 'user'.
>
> I am running Windows98SE on a home network.
>
> Any thoughts/help, please!!!!
- Next message: J Young: "Re: JDBC driver for MSDE 2000 Release A"
- Previous message: fgbrooks: "Failure to Login"
- In reply to: fgbrooks: "Failure to Login"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Failure to Login"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Failure to Login"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
