MSDE Authentication

[Anthony P. Mancini]

Does anyone know how to make the MSDE do
SQL authentication ? It appears to authenticate
using Windows at all times.

Thanks,

Anthony

[Ken Cox [Microsoft MVP]]

Hi Anthony,

I think you can set the password as you install an instance of MSDE. See
step 2 here:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

There are also some MSDE Managers around that you might want to investigate:

http://www.gotdotnet.com/Community/U...5-df189406c0ac

"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Does anyone know how to make the MSDE do
SQL authentication ? It appears to authenticate
using Windows at all times.

Thanks,

Anthony

[Anthony P. Mancini]

Ken,

Thanks for the reply. Is this post in the wrong newsgroup ? I figured
since I was working with .NET logging into the backend that this was the
place to post the question. The MSDE is already installed which is why
I'm having the authentication issue in the first place. The 'SecurityMode'
parameter looks like a command line setting to be used before the setup
is started. Can I use this as a startup parameter for the service ?

Also, with respect to your suggestion of third party MSDE managers;
hopefully you're not implying it isn't possible to change the authentication
mode of a Microsoft desktop software package using Windows. (?)

Anthony

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:ue******** ******@tk2msftn gp13.phx.gbl...

Hi Anthony,

I think you can set the password as you install an instance of MSDE. See
step 2 here:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

There are also some MSDE Managers around that you might want to investigate:
http://www.gotdotnet.com/Community/U...5-df189406c0ac
"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Does anyone know how to make the MSDE do
SQL authentication ? It appears to authenticate
using Windows at all times.

Thanks,

Anthony

[Ken Cox [Microsoft MVP]]

Hi Anthony,

Yes, you'd probably get better answers in a SQL Server group.

That said, you need to do some tweaks to change modes and establish a
password. See the section titled Enable Mixed Mode Authentication After
Installation in this article:

HOW TO: Connect to Microsoft Desktop Engine

http://support.microsoft.com/?kbid=319930

Out of the box, most MSDE configuration has to be done with the command line
osql tool:

http://msdn.microsoft.com/library/de..._osql_1wxl.asp

There's also tutorial here on changing the MSDE login mode:

http://gnonug.xocomp.net/Support/FAQ/595.aspx

FIX: If You Change Windows Security to Windows/SQL Security the SA Password
is Blank

http://support.microsoft.com/default...b;EN-US;274773

"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:OH******** ******@TK2MSFTN GP12.phx.gbl...

Ken,

Thanks for the reply. Is this post in the wrong newsgroup ? I figured
since I was working with .NET logging into the backend that this was the
place to post the question. The MSDE is already installed which is why
I'm having the authentication issue in the first place. The
'SecurityMode'
parameter looks like a command line setting to be used before the setup
is started. Can I use this as a startup parameter for the service ?

Also, with respect to your suggestion of third party MSDE managers;
hopefully you're not implying it isn't possible to change the
authentication
mode of a Microsoft desktop software package using Windows. (?)

Anthony

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:ue******** ******@tk2msftn gp13.phx.gbl...

Hi Anthony,

I think you can set the password as you install an instance of MSDE. See
step 2 here:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

There are also some MSDE Managers around that you might want to

investigate:

http://www.gotdotnet.com/Community/U...5-df189406c0ac

"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

>
> Does anyone know how to make the MSDE do
> SQL authentication ? It appears to authenticate
> using Windows at all times.
>
> Thanks,
>
> Anthony
>
>

[Anthony P. Mancini]

Ken,

Thanks for the response. The KB article you referenced had a registry
setting that could be modified to change MSDE's authentication mode.
Anyway, I'm using Enterprise Manager as the MSDE client tool which
was my reasoning for thinking this was a no brainer. It looks like some
of the admin level functions in EM don't necessarily function the same
way in MSDE, the database object stuff seems to work fine.

Thanks

Anthony

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:OW******** ********@TK2MSF TNGP12.phx.gbl. ..

Hi Anthony,

Yes, you'd probably get better answers in a SQL Server group.

That said, you need to do some tweaks to change modes and establish a
password. See the section titled Enable Mixed Mode Authentication After
Installation in this article:

HOW TO: Connect to Microsoft Desktop Engine

http://support.microsoft.com/?kbid=319930

Out of the box, most MSDE configuration has to be done with the command line osql tool:

http://msdn.microsoft.com/library/de..._osql_1wxl.asp
There's also tutorial here on changing the MSDE login mode:

http://gnonug.xocomp.net/Support/FAQ/595.aspx

FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank

http://support.microsoft.com/default...b;EN-US;274773

"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:OH******** ******@TK2MSFTN GP12.phx.gbl...

Ken,

Thanks for the reply. Is this post in the wrong newsgroup ? I figured
since I was working with .NET logging into the backend that this was the
place to post the question. The MSDE is already installed which is why
I'm having the authentication issue in the first place. The
'SecurityMode'
parameter looks like a command line setting to be used before the setup
is started. Can I use this as a startup parameter for the service ?

Also, with respect to your suggestion of third party MSDE managers;
hopefully you're not implying it isn't possible to change the
authentication
mode of a Microsoft desktop software package using Windows. (?)

Anthony

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:ue******** ******@tk2msftn gp13.phx.gbl...

Hi Anthony,

I think you can set the password as you install an instance of MSDE. See step 2 here:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

There are also some MSDE Managers around that you might want to

investigate:

http://www.gotdotnet.com/Community/U...5-df189406c0ac

"Anthony P. Mancini" <ap*@e-mancini.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
>
> Does anyone know how to make the MSDE do
> SQL authentication ? It appears to authenticate
> using Windows at all times.
>
> Thanks,
>
> Anthony
>
>