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 2000 Forums
 SQL Server Administration (2000)
 Permission Issue

Author  Topic 

pradeep617
Starting Member

3 Posts

Posted - 2006-12-14 : 08:58:22
I removed all the logins from SQL Server and added them. then i added the logins again and gave permission to access specific databases. after restarting sql server, now i am not able to add new login, users. now master table has 2 users(dbo and guest). i am logged in using administrator account. Pls help me. how to revoke the permissions of administrator and be able to add new logins and users.
   

- Advertisement -