Установка и обновление > Installation and Configuration Guide (Руководство по установке и настройке)(на английском языке) > Database Installation > Installing SQL Server > Setting up SQL Server on a Target Server
Setting up SQL Server on a Target Server
Use the following procedure to set up an SQL Server on a target server, when cloning Windchill.
1. Install target SQL Server database instance ensuring that it is configured to support contained DB.
2. Backup the Windchill source SQL Server database and restore it on the target database instance.
3. On the restored database and target SQL Server instance, execute the sp_change_users_login stored procedure as database admin user sa to map existing Windchill database users to a SQL Server login.
For more information see http://technet.microsoft.com/en-us/library/ms174378(v=sql.110).aspx
4. Execute following statement as database admin user sa to convert the database user that is mapped to a SQL Server login, to a contained database user with password :
EXEC sp_migrate_user_to_contained @username=N'<Database_user_name>',@rename=N'keep_name', @disablelogin=N'disable_login'
For more information see: https://msdn.microsoft.com/en-us/library/ff929275.aspx
5. Verify that you can login to the target SQL Server database instance and browse Windchill objects as a Windchill database user.
Было ли это полезно?