Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

when i am removing user from the server it's promoting an error Expand / Collapse
Author
Message
Posted Sunday, February 03, 2013 3:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:47 AM
Points: 9, Visits: 44
Hi........

Any one can provide the solution for the below error in detail.


Error Message in SQL SERVER 2005:

"Deleting Server logins does not delete the database users assciated with logins. To complete the process, delete the users in each database.It may be necessary to first transfer the ownership schemas to new users."
Post #1415002
Posted Sunday, February 03, 2013 7:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 41,517, Visits: 34,432
That's not an error.

That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database users yourself, potentially first transferring ownership of objects of schemas to other users.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1415016
Posted Sunday, February 03, 2013 11:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:47 AM
Points: 9, Visits: 44
Hi GilaMonster,

Thank you so much for your quick response,

If possible can you provide me the right solution for this in a detail way.
Post #1415037
Posted Sunday, February 03, 2013 12:09 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 41,517, Visits: 34,432
GilaMonster (2/3/2013)
That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database users yourself, potentially first transferring ownership of objects of schemas to other users.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1415043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse