Export (0) Print
Expand All

How to Back Up and Restore SQL Server Logins

This topic describes how to back up and restore SQL Server logins associated with BizTalk Server.

BizTalk Server SQL Server Security Logins

The SQL Server security logins listed below are associated with BizTalk Server. You may have additional logins associated with the BizTalk Server applications you have created. You need to back up the logins and restore them when moving the BizTalk Server databases to a new server or new instance of SQL Server.

  • BizTalk Application Users

  • BizTalk Isolated Host Users

  • BizTalk Server Administrators

  • BizTalk Server Operators

  • SSO Administrators

You must be a member of the Administrators security role on the SQL Server where you will back up and restore the logins.

Backing Up and Restoring Logins

You can back up and restore logins using a script as described in the following procedures.

To back up a login using a script (SQL Server 2005 or SQL Server 2008)
  1. Start SQL Server Management Studio.

  2. Expand the Security folder, and then expand the list of Logins.

  3. Right-click the login you want to create a backup script for, and then select Script Login as.

  4. Click CREATE To, and then click one of New Query Editor Window, File, or Clipboard to select a destination for the script. Typically, the destination is a file with a .sql extension.

  5. Repeat this procedure from Step 3 for each login you want to script. Refer to the list of BizTalk Server related logins to determine which logins you will need to script.

To restore a login from a script (SQL Server 2005 or SQL Server 2008)
  1. Start SQL Server Management Studio.

  2. Click File, click Open, and then click File.

  3. Locate and open the file containing the scripted login.

  4. Execute the script to create the login.

Community Additions

© 2014 Microsoft