migrate login SQL 05 to 08

Last Post 15 Jun 2010 04:38 AM by gunneyk. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mddba
New Member
New Member

--
08 Jun 2010 10:10 AM

I'm trying to transfer logins from SQL 05 to a SQL 08 instance.  The SP outlined in http://support.microsoft.com/kb/918992,  sp_help_revlogin, transfers logins and password but doesn't add the logins to any server roles.  Am I missing something?  Is there a seperate SP that will create and then run the alter login that I just can't find?  Any help is appreciated.

Thanks.

rm
New Member
New Member

--
08 Jun 2010 10:31 AM
SSIS copy login task does that but it doesn't copy over pwd.
mddba
New Member
New Member

--
08 Jun 2010 11:25 AM
Does anyone have a solution that will migrate both passwords and the roles the logins are in?
rm
New Member
New Member

--
15 Jun 2010 04:22 AM
You can copy login with ssis, then get pwd with sp_help_revlogin and reset it with 'alter login'.
gunneyk
New Member
New Member

--
15 Jun 2010 04:38 AM
Not sure if this is still 100% valid or not but have a look here: http://www.sql-server-performance.c...ts_p1.aspx
You are not authorized to post a reply.

Acceptable Use Policy