Cannot assign Database Access. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cannot assign Database Access.

Using SQL Server 2000 on a Windows 2003 Server. Created a new database and a new login (SQL Server Authentication) through Enterprise Manager. Go to the Database Access tab of the new login, check the Permit checkbox of the new database and check the db_owner role. Click the OK button. It will ask for password and enter the correct password for the login but it will say incorrect. Does anyone has any idea why it will ask for password? [Update: It may be related tohttp://support.microsoft.com/default.aspx?scid=kb;en-us;826161. Need to confirm.]
Have you applied the security hotfix from Microsoft Security Bulletin MS03-031, if so follow as defined in the KBA. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>