TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
BUTTONS:
OK
Also for the other account I created,
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
Property MustChangePassword is not available for Login '[myLogin]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
BUTTONS:
OK
I am running SQL Server Developer Edition SP2 in Windows Vista Ultimate.
Why is this happening to me?
I added my Vista account to the administrators using the Provisioning tool, and restarted the computer but this did not help.
I allowed SQL to have Mixed Mode (2)
What do I have to do to get SQL working?
Let's eliminate the rights and permissions question first. Log out of everything except the operating system. Then right-click the SQL Server Management Studio and select "Run as Administrator". See if the problem persists.
Second, are you running the Management Studio against the same version of SQL Server? In other words, are you trying to manage a SQL Server 2000 instance from 2K5?
|||Given that this is a tool question, I'm moving this thread to the tools forum.
Thanks
Laurentiu
I have solved the problem, because After updating the SQL server 2005 to SP2, it makes the sql only Windows Authentication. I had to change that to Mixed authentication.
Once I did that, I changed the sa password with ALTER USER sa WITH PASSWORD='mypassword' UNLOCK.
Then things worked out.
But I think MS should tell people about this, so that we dont spend a day figuring out what the problem is.sql
No comments:
Post a Comment