Is there a way to change from Windows Authentication mode to Mixed
Mode on SQL Server 2000 without having to reinstall it?
Thanks,
Ed B.
buch75@.comcast.net
Yes. EM, right-click your server, properties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ed B." <buch75@.comcast.net> wrote in message
news:51aac685.0410070933.18bb5234@.posting.google.c om...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net
|||Of course, go to Enterprise Manager, then go to the SQL Server Properties
then go to Security and change the option over there.
After aplying that you must restart the SQL Server.
--
Roberto Rodrigues
Consultor Tcnico
Dep. Tcnico
Sofistica - Solues Informticas, Lda.
WWW.SOFISTICAPORTUGAL.COM
"Ed B." <buch75@.comcast.net> escreveu na mensagem
news:51aac685.0410070933.18bb5234@.posting.google.c om...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net
No comments:
Post a Comment