The Experience Manager adapter can be configured to use Server Domain Authentication for single sign on with Microsoft SQL databases. Windows servers require additional configuration for SSO functionality.
To configure Windows servers for Single Sign On with Operations Center MSSQL databases:
Stop the Operations Center server.
Copy one of the following files into the directory containing the java.exe used by the Operations Center server:
On a 32-bit JVM: OperationsCenter_install_path/mssql/win32/ntlmauth.dll
On a 64-bit JVM: OperationsCenter_install_path/mssql/win64/ntlmauth.dll
Start the Operations Center server.
Specify the domain, username and password when configuring the Experience Manager adapter with a Microsoft SQL database:
Leave the username and password properties blank to attempt to connect using the current Windows user account.
If running Operations Center as a service, the service must use the same domain user account as the database.
For information on adapter properties used to configure domain authentication with the Experience Manage adapter, continue to Creating a Experience Manager Adapter.