Dealing with Orphaned Users in SQL Server

Orphaned users are usually created when transferring a database from one server to another and often a source of great frustration to those not schooled in the details of SQL Server. In this video Brian takes you through how to fix the users on the new server.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

John CUnningham on 1/28/2009

Just what I was needing thanks

John O'Sullivan on 4/16/2009

an excellent video

Dominik on 4/16/2009

Really excelent!! Thanks,

idris chambas on 4/16/2009

Great stuff.

Rubens on 4/16/2009

This is a fantastic video for individuals new to the SQL world and not sure of how to fix orphaned logins.

Stephen Oesterreicher on 4/16/2009

An excellent video.

Stephen Anslow on 4/16/2009

Didn't know about sp_help_revlogin - thanks for that... really useful video.

Ron Taylor on 4/16/2009

Excellent!

Erin on 4/16/2009

Len Brodnik suggested this video. He was right about it being very useful.

Carle Eric Giannelli on 4/19/2009

excellent and informative

cshah on 4/24/2009

K Brian, sp_change_users_login will be removed from the future version of SQL Use ALTER USER instead

Rajaraman Prabakaran on 5/10/2009

Excellent

Jamshid Nouri on 5/12/2009

excellent

punjwani on 6/9/2009

excellent and informative

karthik on 3/22/2010

Nice Video..

Philip Smith on 3/29/2010

Good job Brian. _Philip Smith CallingPost

Babita Das on 5/24/2010

this is really an useful topic. We got to know how the SID of login in the database level is being mapped with the server level login .

Colin Nixon on 6/7/2010

I always used the auto fix option, so all of this was good information

Ravi Raj on 6/29/2010

good one

Matt Dobson on 9/12/2011

good tips

Tahir A. Syed on 9/12/2011

Marvelous! Thanks...Tahir

Syed Hassan on 9/12/2011

Great video... I have run into these issues and this will save me a lot of time.

UB on 9/12/2011

Another great video. Thanks for doing this. _Uday

Sean on 9/12/2011

Never heard of SP_Help_login, have been doing it the hard way for years. Thanks for the new stored procedure and making my life better.

Carlos B. Vasquez on 9/12/2011

Very interesting topic to know, and have it handy for DBA and SQL Server developers. Great Job Brian. Thanks.

6FE98FCB54 on 9/13/2011

Outstanding

Paul Sprunger on 9/13/2011

Another great Jumstart video!!

Charlie Pasquine on 9/16/2011

Very helpful.

zafrul on 9/22/2011

Did not mention how to deal with a orphaned login 'DBO' EXEC SP_CHANGEDBOWNER 'DBO'

Sherry on 9/28/2011

Good information about the stored procedure you would need to create.

Frank on 11/26/2011

Excelllent

Rob Firth on 1/4/2012

Perhaps mention the new contained databases feature with SQL 2012

Maurice Ivory on 2/17/2012

Okay this was very good.