Hi,
I am a newbie and i am trying to change authenication mode under enterprise
manager the sql server properties -> security tab to "SQl Server and Windows
NT" but as soon as i click on ok and close the properties it changes bak, to
Windows NT.
I have installed sharepoint services and someday i would configure something
(i dont remember what) i changed authentication to Windows NT , now i want t
o
change it back to mixed mode (Sql server and Windows) but it does want to
obey.
what can i do?From memory, changing the authentication mode only takes affect the
next time you restart SQL Server. Have you stopped & restarted SQL
Server since changing the authentication mode?
*mike hodgson*
http://sqlnerd.blogspot.com
Cyrus wrote:
>Hi,
>I am a newbie and i am trying to change authenication mode under enterprise
>manager the sql server properties -> security tab to "SQl Server and Window
s
>NT" but as soon as i click on ok and close the properties it changes bak, t
o
>Windows NT.
>I have installed sharepoint services and someday i would configure somethin
g
>(i dont remember what) i changed authentication to Windows NT , now i want
to
>change it back to mixed mode (Sql server and Windows) but it does want to
>obey.
>what can i do?
>sql
Sunday, March 25, 2012
changing Authentication mode
Labels:
authenication,
authentication,
changing,
database,
enterprisemanager,
microsoft,
mode,
mysql,
newbie,
oracle,
properties,
security,
server,
sql,
tab
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment