Copy Database Wizard w/MSDE

I am trying to use the copy database wizard in Enterprise
manager to copy a database from one MSDE installation to
another. It always returns the error:
"Your SQL Server Service is running under the local
system account. You need to to change your SQL Server
Service account to have the rights to copy files over the
Network."
When I try to change the service to run under a different
account I get another error, "The handle is invalid."
I got to thinking that perhaps MSDE doesn't allow you to
run under anything but local system. Can anyone
confirm? Or does anyone know what's wrong here?
hi bill,
"bill" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:2d14001c46a06$8a1cd570$a401280a@.phx.gbl...
> When I try to change the service to run under a different
> account I get another error, "The handle is invalid."
> I got to thinking that perhaps MSDE doesn't allow you to
> run under anything but local system. Can anyone
> confirm? Or does anyone know what's wrong here?
MSDE SQL Server service and SQLSERVERAgent service can run on diferent
account than LocalSystem with no problem [of mines =;-) ]
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||a little addition to "invalid" message...
please have a look at http://tinyurl.com/696hq if can help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Copy Database (SQL Management Object method)

I tried to copy a db instance from one SQL 2005 installation to another. The transfer/copy wizard in management studio showed nothing - a blank - in the "Destination database files" section. That struck me as bad, but the wizard would not let me add any files. Then when I tried to execute the transfer/copy, I got this error message:

Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
InnerException-->The PRIMARY filegroup must have at least one file.

I suppose I would not have had that error message, if the wizard allowed me to add a filegroup. What is causing this?

Are you copying or moving? Do you have to use SMO? If not, just make a backup of the database and restore it to the other server. If you are moving the database, detach the files and reattach them on the other server. Hope this helps.
Tim|||Run SP_HELPFILEGROUP on source server to see what are the contents displayed, as explained you can either take help of backup/restore of detach/attach method.

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
>
>

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

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
>
>