Fixing broken users after Database Restore

Ever restored a Database which was created on a different server then not been able to use the same logon you had previously set up?

This command fixes the problem with the account.

-- Replace username with the account to fix
sp_change_users_login 'Auto_Fix','username'

Author	: Paul Hayman
Published	: 14 June 2006

Paul is the COO of kwiboo ltd consultant and has more than a decade of IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services. Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.

Add Comment | Tag This

Tagged as : sql

Comments

Simone said:

I've been using this command since 5 years... and I always forget the syntax

June 26, 2007 - 4:15 AM

phayman said:

Me too.. that's why I documented it somewhere I could find it quickly ;-)

June 26, 2007 - 9:30 AM

jrobiii said:

Heheh! Same here. Google is your friend!

February 03, 2010 - 1:22 PM

Sara said:

Fantastic!!! Very Very usefull!

July 11, 2010 - 6:30 PM

Mathias said:

thanks man, you just saved my day.

Been sitting here for 9 hours restoring databases, this was the last piece missing. I was banging my head cause I thought my backups are no good.

Thanks for the good work!!

March 14, 2011 - 1:44 AM

Log In
User Name:
Password:
Remember me next time.

Register Forgot your password?

View Tag's by : # articles | # views

More Publications

Select Column Information using SQL Server
Dave Howard - 18/09/2006

Backup ALL your SQL Server 2005 databases using ONE script
Paul Hayman - 20/11/2007

Full Text Search in SQL 2005
Ric Hayman MCPD - 03/08/2006

GRANT Permissions on all of your Stored Procedures using a query
Paul Marshall - 16/06/2006

T-SQL script automatically adds auditing to a table
Dave Howard - 18/09/2006