MS SQL 2000 to MS SQL 2005 import duplicate SID mayhem
The problem: importing a db from a 2000 src resulted in duplicate SIDs.
Utimately the fix:
The problem: importing a db from a 2000 src resulted in duplicate SIDs.
Utimately the fix:
- 1. Create a user login.
- 2. Run `ALTER USER
WITH Name = [ ], DEFAULT_SCHEMA = , LOGIN = [ ];` and sub out the parts
Fixed, imported...other issues still pending...
0 Comments:
Post a Comment
<< Home