Resolving Login Issues After Restoring the Destination System
Orphaned users
Depending on how the source system was configured during deployment, "orphaned" users may need to be resolved. An orphaned database user is a user who does not have a corresponding security login in SQL Server. Create corresponding logins for these users before bringing the system online using the SQL Server SQL Management Studio (in Security, Logins). You can create these logins at any point, but we recommend that you create them when BizTalk Server log shipping is configured.
The logins that are created should correspond to the Windows accounts and groups that were used when BizTalk Server was configured on the source system and to any logins that were manually created and used in any BizTalk Server-created role. If these logins correspond to local Windows accounts or groups, the accounts and groups must first be created before the login can be added. If the computer name for the BizTalk server is not changed, then resolve the users associated with the logins for the local accounts and groups.
When configuring BizTalk Server log shipping, you can KB 918992: Transfer the logins and the passwords between instances of SQL Server to create a script that adds the necessary logins to the destination server.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for