unable to use existing user accounts

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)

unable to use existing user accounts

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-03-23 : 16:37:27

Hi friends
i have sql 2000 db which i attached to our sql server 2005.the problem all sql logins i've for this db are there but i cant login using any of those logins.
i tried to delete them as i wanted recreate them but get following error. any idea how to reactivate those logins.Thanks for your help

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for User 'Damia'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15138&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Cheers

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-23 : 20:31:09

script out the login from your old database and re-create them in the new database

or

the error tells you that the login you're deleting owns some objects,
transfer ownership to dbo first (sp_changedbowner) then drop the login

HTH

--------------------
keeping it simple...

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-03-23 : 20:50:51

Thanks for jen.
looks like i need to delete "schemas" under security for this user then it let me delete the user.
one more thing is passwords case sensitive .
its all fine now. Thanks

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources