Map the logins to the users - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Moving INOW Database from SQL Server to another SQL Server Machine

Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 24.1
License

To map logins to the users in the database, complete the following steps.

  1. In SQL Server Management Studio, on the toolbar, click New Query.
  2. Copy and paste the following command set in the Query tab.

USE INOW 
GO 

EXEC sp_change_users_login 'update_one', inuser, inuser; 

EXEC sp_change_users_login 'update_one', inemuser, inemuser; 

EXEC sp_change_users_login 'update_one', reports, reports;
  1. On the toolbar, click Execute.