Failure to Login

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!!!!
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\Lo ginMode
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!!!!
|||Thanks for the reply. I had already checked the Registry
following the instructions of the readme and 319930, and
had previously set it at 2. At a command prompt, if I
type 'osql -U sa', I am prompted for a password (which I
had previously set up), enter it, and it appears that I am
logged in. However, when I try to test this using
a 'test.udl' file as described in 319930, it fails, even
though I enter the same password.
My server name is FRED'S COMPUTER (with a space between
the S and the C). When I try to enter your suggested
command, it reads as follows: osql -U sa -S FRED'S
COMPUTER. This command fails as improper syntax.
Evidently, it doesn't like my server name. Any other
thoughts?
>--Original Message--
>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\L oginMode
>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\ MSSqlServ
er
> 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[vbcol=seagreen]
>news:7c3801c43173$af8c8b00$a601280a@.phx.gbl...
SQL[vbcol=seagreen]
it[vbcol=seagreen]
I[vbcol=seagreen]
used[vbcol=seagreen]
Connection
>
>.
>