Create the Database Login Information - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content

The system creates three standard logins and users with the INOW database. The application uses the INUSER account as the primary account. This procedures shows you how to adjust the passwords accordingly based on your security requirements.

Note: If you change the password for inuser, you must also update the encrypted password in the inow.ini file on the Perceptive Content Server workstation.

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

USE INOW 
GO CREATE LOGIN inuser WITH PASSWORD = 'imagenow' DEFAULT_DATABASE = INOW, 
CHECK_POLICY = OFF 
GO 

EXEC sp_grantdbaccess 'inuser', 'inuser' 
GO 

EXEC sp_addrolemember 'db_owner', 'inuser' 
GO 

CREATE LOGIN reports WITH PASSWORD = 'imagenow', DEFAULT_DATABASE = INOW, 
CHECK_POLICY = OFF 
GO 

EXEC sp_grantdbaccess 'reports', 'reports' 
GO 

EXEC sp_addrolemember 'db_datareader', 'reports' 
GO 

CREATE LOGIN inemuser WITH PASSWORD='Externalmsg1', DEFAULT_DATABASE = INOW, 
CHECK_POLICY = OFF 
GO 

CREATE USER inemuser FOR LOGIN inemuser 
GO 

ALTER USER inemuser WITH DEFAULT_SCHEMA=inuser 
GO 

USE MASTER 
GO 

GRANT VIEW SERVER STATE TO inuser 
GO

On the toolbar, click Execute.