Map the logins to the users - Map the logins to the users - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 25.1 - Foundation 25.1 - Ready - Perceptive Content - external - Perceptive-Content/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine/Foundation-25.1/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine-Best-Practices/Moving-the-INOW-Database-from-SQL-Server-to-Another-SQL-Server-Machine/Prepare-to-Move-the-Database/Map-the-logins-to-the-users - 2025-07-21

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;

3. On the toolbar, click Execute.