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 Authentication 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 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.
Hi,
Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
..
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/default...b;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 password i came up with for Windows Authentication?
"Hari Prasad" wrote:

> Hi,
> Go to registry key HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
> ..
> 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/default...b;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 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.
> 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.
> 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\MSSqlServer\Lo ginMode[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 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.
"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\MSSqlServer\Lo ginMode
> 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 necessary 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 account? 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 purpose 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
>
>