Converting MSDE databse to mixed mode

I installed MSDE on windows server 2003 a few days ago but did not make the
installation mixed mode because the documentation insisted that Windows Auth
entication was better. Now I am stuck with a database that I cannot connect
to through anything. I ha
ve tried figuring out how to switch to mixed mode but documentation on MSDE
is nearly nonexistent. I also tried to figure out how to uninstall a databa
se but there is no mention of this anywhere.
Is there a way to switch to mixed mode, and if there is, what exactly am I s
upposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login information
.
I am using the database for DotNetNuke and have read that sql is a better ch
oice than access so i'd like to give this another shot. Also how does MSDE
compare to the standard SQL, am I better off running access? Thanks.Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
.
if the value is 1 then it is NT authentication , changing the value to 2
would get the server into mixed mode.
You need to stop and start the MSSQL server services after the registry
change.
See the detailed KB artticle which explains the diffrent methods to change
the authentication during installation and after.
http://support.microsoft.com/defaul...kb;en-us;285097
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> I installed MSDE on windows server 2003 a few days ago but did not make
the installation mixed mode because the documentation insisted that Windows
Authentication was better. Now I am stuck with a database that I cannot
connect to through anything. I have tried figuring out how to switch to
mixed mode but documentation on MSDE is nearly nonexistent. I also tried to
figure out how to uninstall a database but there is no mention of this
anywhere.
> Is there a way to switch to mixed mode, and if there is, what exactly am I
supposed to do with the sa password I gave, i still haven't figured out what
it is used for, and how would it be different from the sql login
information.
> I am using the database for DotNetNuke and have read that sql is a better
choice than access so i'd like to give this another shot. Also how does
MSDE compare to the standard SQL, am I better off running access? Thanks.|||how would i set the sql login id and password, and what would i use my sa pa
ssword i came up with for Windows Authentication?
"Hari Prasad" wrote:

> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMo
de
> ..
> if the value is 1 then it is NT authentication , changing the value to 2
> would get the server into mixed mode.
> You need to stop and start the MSSQL server services after the registry
> change.
> See the detailed KB artticle which explains the diffrent methods to change
> the authentication during installation and after.
> http://support.microsoft.com/defaul...kb;en-us;285097
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:D14C0B26-13BC-4479-970E-46DF471C23A6@.microsoft.com...
> the installation mixed mode because the documentation insisted that Window
s
> Authentication was better. Now I am stuck with a database that I cannot
> connect to through anything. I have tried figuring out how to switch to
> mixed mode but documentation on MSDE is nearly nonexistent. I also tried
to
> figure out how to uninstall a database but there is no mention of this
> anywhere.
> supposed to do with the sa password I gave, i still haven't figured out wh
at
> it is used for, and how would it be different from the sql login
> information.
> choice than access so i'd like to give this another shot. Also how does
> MSDE compare to the standard SQL, am I better off running access? Thanks.
>
>|||Hi,
Try the below from command prompt with password as blank.
osql -Usa -P -Sservername
If it is not allowng login with trusteed connection using:
OSQL -E -Sservername (enter)
1>sp_password null,'newpassword','sa'
2>go
After that try connecting using the new password for sa.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> how would i set the sql login id and password, and what would i use my sa
password i came up with for Windows Authentication?[vbcol=seagreen]
> "Hari Prasad" wrote:
>
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode[vbcol=seagreen]
2[vbcol=seagreen]
change[vbcol=seagreen]
make[vbcol=seagreen]
Windows[vbcol=seagreen]
tried to[vbcol=seagreen]
am I[vbcol=seagreen]
what[vbcol=seagreen]
better[vbcol=seagreen]
Thanks.[vbcol=seagreen]|||I can no longer start the sql database. I get two error messages when tryin
g:
First: "The service cannot be started, either because it is disabled or beca
use it has no enabled devices associated with it."
After clicking ok I get:
"An error 1058 - (The service cannot be started, either because it is disabl
ed or because it has no enabled devices associated with it.) occured while p
erforming this service operation on the MSSQLServer service."
The key I changed was:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode from
2 to 0.
"Hari Prasad" wrote:

> Hi,
> Try the below from command prompt with password as blank.
> osql -Usa -P -Sservername
> If it is not allowng login with trusteed connection using:
> OSQL -E -Sservername (enter)
> 1>sp_password null,'newpassword','sa'
> 2>go
> After that try connecting using the new password for sa.
>
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:EC472035-7FC2-4313-8E35-626B8110E6DB@.microsoft.com...
> password i came up with for Windows Authentication?
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
> 2
> change
> make
> Windows
> tried to
> am I
> what
> better
> Thanks.
>
>|||Hi,
The value 2 itself is Mixed mode. Can you change back the value to old and
restart the MSSQL server service.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> I can no longer start the sql database. I get two error messages when
trying:
> First: "The service cannot be started, either because it is disabled or
because it has no enabled devices associated with it."
> After clicking ok I get:
> "An error 1058 - (The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it.) occured
while performing this service operation on the MSSQLServer service."
> The key I changed was:
> HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLServer/MSSQLServer/LoginMode
from 2 to 0.[vbcol=seagreen]
> "Hari Prasad" wrote:
>
sa[vbcol=seagreen]
to[vbcol=seagreen]
registry[vbcol=seagreen]
cannot[vbcol=seagreen]
switch to[vbcol=seagreen]
this[vbcol=seagreen]
exactly[vbcol=seagreen]
out[vbcol=seagreen]
does[vbcol=seagreen]|||ok thank you, i got it to work and changed the sa password. Was this necess
ary if I had installed it with SAPWD="password." Should I create a new user
account for use with my dotnetnuke portal or should i just use the sa accou
nt? Also why do I keep rea
ding everywhere that Windows Authentication is better yet it doesn't explain
how to have anonymous users from the net use it, was Windows Authentication
designed only for intranet. Thanks again. on a side note what's the purpo
se of the null in the comma
nd you posted last? Is there a site that lists the osql commands in detail?
"Hari Prasad" wrote:

> Hi,
>
> The value 2 itself is Mixed mode. Can you change back the value to old and
> restart the MSSQL server service.
> Thanks
> Hari
> MCDBA
> "Kal525" <Kal525@.discussions.microsoft.com> wrote in message
> news:42BC7C0F-D364-43C8-A512-86A537132000@.microsoft.com...
> trying:
> because it has no enabled devices associated with it."
> disabled or because it has no enabled devices associated with it.) occured
> while performing this service operation on the MSSQLServer service."
> from 2 to 0.
> sa
> to
> registry
> cannot
> switch to
> this
> exactly
> out
> does
>
>