change sql authentication mode

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

change sql authentication mode

Author

Topic

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-07-21 : 02:29:20

Hi,

How to change the SQL Server Authentication mode of SQL Server from Registry level if sql server is not coming up.

Thanks in advance.

Bea
Starting Member

7 Posts

Posted - 2010-07-21 : 10:27:28

Hello

I had a look about to see if i could help with your question.

Someone had a similar problem and a guy called Tom Li gave this reply.

Let me know if if helps

If you cannot login to SQL Server by using SSMS

1.Run sqlcmd.exe with no parameter

2.Run the follow script

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

GO

3.Exit from sqlcmd

4.restart your SQL Server service

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources