August 24, 2009 at 3:02 pm
Hi,
I am in the process of migrating SQL 2000 to 2005 and succesfully restored the backup. Now i need to transfer the SQL server logins. The source server is a prod server which i don't have access so i cannot use Trasfer login task etc.,. The person who has the access scripted the logins and gave it to me but the script has the password field as null. Can anybody tell me a solution keeping in mind that i don't have access to source server to succesfully create the SQL server logins.
Thanks
ek
August 24, 2009 at 3:39 pm
Ask your contact to compile and run procedure sp_help_revlogin
Details here... http://support.microsoft.com/kb/918992
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply