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 2008 Forums
 SQL Server Administration (2008)
 getting error when changing the sql server mode

Author  Topic 

anjali66
Starting Member

23 Posts

Posted - 2010-12-22 : 11:22:07
Hello Everuone,

I am trying to change the autheication mode of my sql server from windows to mixed mode. For that, i clicked on the root of the server and went to properties and then security tab and then from there, I changed to SQL server and windows autheication mode from windows autheication mode. When I do that, I get a below error.

Any help will be greatly appreciated.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for Server 'servername'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

RegCreateKeyEx() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 22002)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=22002&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-22 : 12:29:11
It seems you don't have permissions to make that change. Use an account with sysadmin.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

anjali66
Starting Member

23 Posts

Posted - 2010-12-22 : 23:47:02
hi,

I have admin rights to this sql server. I installed the sql server and client on my machine.

The server is also my local machine.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-23 : 15:02:54
What's your operating system? You likely aren't running in admin mode.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

konark
Yak Posting Veteran

60 Posts

Posted - 2010-12-27 : 01:55:11
Disconnect all the server connections. or

set database <db_name> set single_user

and then try login as sysadmin privilege and make the change authentication mode.
Confirm if it works.

Chandragupta Mourya

Takhyashila
Go to Top of Page

sen5241b
Starting Member

2 Posts

Posted - 2010-12-29 : 09:59:11
I had a similar issue with SQL 2005 becuase the sa password I entered did not meet the server-level (or domain level) password complexity rules. I had to edit the hardcoded password(s) in the on-disk setup scripts and change it to a more complex password.
Go to Top of Page
   

- Advertisement -