Sunday, March 25, 2012

Changing Authentication Mode

How can I change the authentication mode of SQl Server from 'windows
authentication' to 'mixed mode'? The SQL Server was installed using
windows authentication but I want to change it to 'mixed mode'.
Thanks
Egbon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi Egbon
The easiest way is through Enterprise Manager. Right click on your server
and choose Properties.
On the Security Tab, in the section called Authentication, select "SQL
Server and Windows".
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:O$9FAVusDHA.1740@.TK2MSFTNGP12.phx.gbl...
> How can I change the authentication mode of SQl Server from 'windows
> authentication' to 'mixed mode'? The SQL Server was installed using
> windows authentication but I want to change it to 'mixed mode'.
> Thanks
> Egbon
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks a lot!
Egbon
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:em$W3gusDHA.2464@.TK2MSFTNGP12.phx.gbl...
> Hi Egbon
> The easiest way is through Enterprise Manager. Right click on your server
> and choose Properties.
> On the Security Tab, in the section called Authentication, select "SQL
> Server and Windows".
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Egbon V." <vnjowusi@.gosps.com> wrote in message
> news:O$9FAVusDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > How can I change the authentication mode of SQl Server from 'windows
> > authentication' to 'mixed mode'? The SQL Server was installed using
> > windows authentication but I want to change it to 'mixed mode'.
> >
> > Thanks
> >
> > Egbon
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>

No comments:

Post a Comment