How to switch From SQL Server Authentication to Windows/Integrated Authentication

Document ID : KB000047843
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction

If you decide to switch from SQL Server authentication for the data_engine to Windows/Integrated authentication, there are certain changes to the product which need to be made for it to work.




Procedure

On NMS Server:

- Change Nimsoft Robot Watcher service's Log on to the Windows/domain user
- Restart Nimsoft Robot Watcher service
- Open data_engine probe and add "Integrated Security=SSPI" to Parameters, so it will look like following:

Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI

- Restart data_engine probe
- Verify from logs and Status section of the probe that data_engine is connected to database and working correctly

On UMP Server:

- Change Nimsoft Robot Watcher service's Log on to the Windows/domain user
- Restart Nimsoft Robot Watcher service
- Verify dap, dashboard_engine and wasp probes are working


For Unified Reporter update:

- Backup wasp.cfg
- Open wasp.cfg in text editor
- Current configuration for webapps/jasperserver-pro section would look similar to following when SQL Server ?authentication was in use:
<jdbc>
? ? ? ? ? ? <1>
? ? ? ? ? ? ? ? name = jdbc/jasperserver
? ? ? ? ? ? ? ? jdbc_username = sa
? ? ? ? ? ? ? ? dbcp_max_idle = 30
? ? ? ? ? ? ? ? dbcp_max_wait = 10000
? ? ? ? ? ? ? ? jdbc_driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
? ? ? ? ? ? ? ? jdbc_password = Gmgab2BmNoB4fAWa8Xa/AQ==
? ? ? ? ? ? ? ? dbcp_max_active = 100
? ? ? ? ? ? ? ? hibernate_dialect = com.jaspersoft.ji.hibernate.dialect.SQLServerJICustomDialect
? ? ? ? ? ? ? ? jdbc_url = jdbc:sqlserver://;serverName=mehfa01-vm64609;databaseName=jasperserver;SelectMethod=cursor;applicationName=UnifiedReporter;
? ? ? ? ? ? </1>
<jdbc>

- Update the above section so it looks like following:
?<jdbc>
? ? ? ? ? ? <1>
? ? ? ? ? ? ? ? name = jdbc/jasperserver
? ? ? ? ? ? ? ? jdbc_username =?
? ? ? ? ? ? ? ? dbcp_max_idle = 30
? ? ? ? ? ? ? ? dbcp_max_wait = 10000
? ? ? ? ? ? ? ? jdbc_driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
? ? ? ? ? ? ? ? jdbc_password =?
? ? ? ? ? ? ? ? dbcp_max_active = 100
? ? ? ? ? ? ? ? hibernate_dialect = com.jaspersoft.ji.hibernate.dialect.SQLServerJICustomDialect
? ? ? ? ? ? ? ? jdbc_url = jdbc:sqlserver://;serverName=mehfa01-vm64602;databaseName=unifiedreporter;SelectMethod=cursor;applicationName=UnifiedReporter;integratedSecurity=true;
? ? ? ? ? ? </1>
? ? ? ? </jdbc>

Note: change serverName, databaseName per your installation.


keywords: login failed for user Windows authentication security Reason Could not find a login matching the name provided.