Thursday, February 16, 2012

Can't Connect to SQL Server

someone told me to delete BUILTIN\Adminiistrator becuase
it was a security risk and now i cant access the
Enterprise manager.
can anyone help?
Hi,
It seems you have registered in Enterprise manager using the Windows
Authentication. Chage the authentication to "Windows and SQL server",
by editing the the below registry key
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL Server\MSSQLServer],
Change the login mode to "0"
After that delete the current registration and create a new registration
using SQL server authentication using 'SA' user and password. After that
give previlages to your OS level user "sysadmin" role and reregister using
ur User using OS authentication.
Thanks
Hari
MCDBA
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:14d0201c41912$68bcdcd0$a601280a@.phx.gbl...
> someone told me to delete BUILTIN\Adminiistrator becuase
> it was a security risk and now i cant access the
> Enterprise manager.
> can anyone help?

No comments:

Post a Comment