Re: Migrating from 2 Instances to 1 Instance (SQL 2005)

From: "PSPDBA" <DissendiumDBA@xxxxxxxxx>
Date: 25 May 2006 11:58:04 -0700

I'll reiterate - check out the sp_change_users_login. Your "identical"
user ids really aren't. They are from two different instances,
therefore have two different SIDS. unless your DBA removed all the
users and completely recreated them, they won't have access. Just
recently ran in to this, and that stored procedure saved the day.

.

Follow-Ups:
- Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
  - From: Uri Dimant

References:
- Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
  - From: Tom Moreau
- Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
  - From: Tom Moreau

Prev by Date: Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
Next by Date: Re: who dropped my table in SQL Server?
Previous by thread: Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
Next by thread: Re: Migrating from 2 Instances to 1 Instance (SQL 2005)
Index(es):
- Date
- Thread