October 31, 2007 at 1:07 pm
ok
October 31, 2007 at 3:28 pm
http://support.microsoft.com/kb/Q240872
Here is the relevant part:
Download the MapSids.exe file, and then extract the Sp_sidmap.sql and Readme.txt files.
3.Log on to the server that is running SQL Server as a system administrator, and then run the Sp_sidmap.sql file in the user database. Running the Sp_sidmap.sql file creates the two stored procedures, sp_sidmap and sp_prefix_sysusersname.
4.Make sure that the database is not accessed by any other user than the one who is running the stored procedures.
5.Make sure that Query Analyzer displays results in text format and not in grid format. To do this, either press the CTRL^T keys, or click Query, and then click Results in Text. This is very important so that you can view the results and the informational messages in one window and save the output to a text file. You might need this file later to resolve some of the mappings.
6.Because you cannot verify whether the parameters are passed correctly, make sure to pass them correctly to the sp_sidmap stored procedure:
EXEC sp_SidMap @old_domain = old_domain_name,
@new_domain = new_domain_name,
@old_server = old_server_name,
@new_server = new_server_name
Replace the values for the old and new domain names and server names appropriately.
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply