all groups > sql server programming > december 2006 >
You're in the

sql server programming

group:

Error while changing authentication from Windows to Mixed mode


Error while changing authentication from Windows to Mixed mode SqlBeginner
12/25/2006 11:43:00 PM
sql server programming:
I right clicked on the server and entered Properties tab. There I entered
into Security tab and choose the radio button "SQL Server and Windows
Authentication mode". On clicking OK button it asked for "sa" password. After
entering the password it throws this error.

"Operation is not valid due to the current state of the object.
(SqlManagerUI).

Can anyone help me solve this.

Regards
Re: Error while changing authentication from Windows to Mixed mode Uri Dimant
12/26/2006 12:00:00 AM
Hi
Are you sure that you killed all connections for Windows Authentication
mode only?


[quoted text, click to view]

Re: Error while changing authentication from Windows to Mixed mode Erland Sommarskog
12/26/2006 12:00:00 AM
SqlBeginner (SqlBeginner@discussions.microsoft.com) writes:
[quoted text, click to view]

Which tool does this happen in? Which version of SQL Server do you try
do this for?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
Re: Error while changing authentication from Windows to Mixed mode Uri Dimant
12/26/2006 12:00:00 AM
Hi
[quoted text, click to view]

I checked this option and it does not relate to the problem. Can you tell
us what did you do to get the error?


[quoted text, click to view]

AddThis Social Bookmark Button