Mixed Authentication mode - SQL Server Forums

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

Other SQL Server Topics (2005)

Mixed Authentication mode

Author

Topic

yosef
Starting Member

1 Post

Posted - 2007-06-07 : 08:25:54

Hello

I would like to set 'SQL Server and Windows Authentication mode' of Sql Server 2005 so when user connects to Server he must supply username and password. Here are steps I make :

1. Open Microsoft SQL ServerManagement Studio Express
2. In Object Explorer right click on first (Server) node
3. Select 'Properties'
4. Select Page 'Security'
5. set 'Server authentication' to 'SQL Server and Windows Authentication mode'
6. press OK
7. in popup window fill password ******** and press OK
8. get error message ''operation is not valid due to the current state of the object. (Microsoft.SqlServer.Express.SqlManagerUI)

How correctly to set above Server mode ?

Why I get the error message and how to solve it ?

Thank you

Yosef Fishov

nr
SQLTeam MVY

12543 Posts

Posted - 2007-06-07 : 10:45:51

Are you using a strong sa pssword?

The authentication mode is set by a registry key
something like this for the default instance
hkey_local_machine\software\microsoft\microsoft sql server\mssql.1\mssqlserverloginmode = 1 for windows, 2 for mixed.

If you chenge that and restart the instance it should allow mixed security. Remember to set a strong sa password afterwards.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-08 : 01:04:30

Did you connect to sql with sysadmin rights?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources