I would like to change the authentication method for an MSDE instance. How
do I do it via OSQL ?
This I need when there is no EM installed. I would like to turn the default
authentication from Windows to Mixed mode.
I searched BOL but it talked about using EM.
Thanks in advance for your input.
MacYou can switch MSDE to mixed mode during installation and after that.
Here it is
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
Regards
---
All information provided above AS IS.
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> I would like to change the authentication method for an MSDE instance.
How
> do I do it via OSQL ?
> This I need when there is no EM installed. I would like to turn the
default
> authentication from Windows to Mixed mode.
> I searched BOL but it talked about using EM.
> Thanks in advance for your input.
> Mac
>|||Thanks for the quick response!! That worked.
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:%23o1rkv9nDHA.372@.TK2MSFTNGP11.phx.gbl...
> You can switch MSDE to mixed mode during installation and after that.
> Here it is
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
>
> Regards
> ---
> All information provided above AS IS.
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> > I would like to change the authentication method for an MSDE instance.
> How
> > do I do it via OSQL ?
> > This I need when there is no EM installed. I would like to turn the
> default
> > authentication from Windows to Mixed mode.
> > I searched BOL but it talked about using EM.
> >
> > Thanks in advance for your input.
> > Mac
> >
> >
>
No comments:
Post a Comment