Portal Home > Knowledgebase > cPanel > List logins with SSID
Run this on MSSQL2008 to generate a list of logins.
EXEC sp_help_revlogin
Delete any logins that are not needed.
Copy script to MSSQL2008-2
Fail a database to MSSQL2008-2
Delete existing login and remove link to database
Run appropriate CREATE LOGIN script to recreate the login.
Ensure default database and Mappings are correct (owner)
Add to Favourites 
Print this Article
