Authentication

How do I change authentication for an MSDE database. I
want to use sql server authentication.Check out MSKB 321698:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321698
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Arne" <Arnenospam@.garvander.com> wrote in message
news:00db01c35e9b$3ac09fb0$a101280a@.phx.gbl...
> How do I change authentication for an MSDE database. I
> want to use sql server authentication.|||That link doesn't seem to have the registry entry to edit.
It's
For default instance
HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/LoginMode
= 1 integrated security, 2 mixed.
>--Original Message--
>Check out MSKB 321698:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;321698
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>--
>SQL FAQ links (courtesy Neil Pike):
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>--
>"Arne" <Arnenospam@.garvander.com> wrote in message
>news:00db01c35e9b$3ac09fb0$a101280a@.phx.gbl...
>> How do I change authentication for an MSDE database. I
>> want to use sql server authentication.
>
>.
>|||Thanks for pointing that out, Nigel. MSKB 319930 documents the registry
entry.
https://mvp.support.microsoft.com/default.aspx?scid=kb;en-us;319930
--
Dan Guzman
SQL Server MVP
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:015f01c35ed2$2a935e70$a601280a@.phx.gbl...
> That link doesn't seem to have the registry entry to edit.
> It's
> For default instance
> HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/LoginMode
> = 1 integrated security, 2 mixed.
>
> >--Original Message--
> >Check out MSKB 321698:
> >
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;321698
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >--
> >SQL FAQ links (courtesy Neil Pike):
> >
> >http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> >http://www.sqlserverfaq.com
> >http://www.mssqlserver.com/faq
> >--
> >
> >"Arne" <Arnenospam@.garvander.com> wrote in message
> >news:00db01c35e9b$3ac09fb0$a101280a@.phx.gbl...
> >> How do I change authentication for an MSDE database. I
> >> want to use sql server authentication.
> >
> >
> >.
> >