Use Windows Authentication for the authentication between DocuShare server and the SQL Server database.
In the following example, the "DB_NAME" is the database name. Replace the name with your database name. The "AUTH_USER" is the user account, commonly "./Administrator".
Instruction
(1)
Install SQL Server and choose "Mixed Mode (SQL Server authentication and Windows authentication)" as database server "Authentication Mode".
In the "Specify SQL Server administrators" field, add the "AUTH_USER" who would start DocuShare service.
(2)
Complete the installation of SQL Server.
(3) Install DocuShare using mixed mode (with windows service)
Choose "Install the DocuShare Windows Service" radio button.
The "Tablespace Name: " on the configuration page would be the "DB_NAME".
(4)
Configure Security Logins and Ownership
Connect to the database using Microsoft SQL Server management studio. In the left pane, expand on the "Security" - "Logins" folder and go to properties of the "AUTH_USER".
Ensure that the "AUTH_USER" has rights to the created database. Click on "User Mapping", locate the database schema of the DocuShare server, and grant full access of that schema to the user.
(5)
Configure DocuShare for OS authentication
(5.1)
Edit "$DSHOME/config/JDBCPropertyBean.properties", locate the key "url", and append "integratedSecurity=true" to the end of the string.
Example:
From
url=jdbc\:sqlserver\://localhost;databaseName\=DB_NAME;
To
url=jdbc\:sqlserver\://localhost;databaseName\=DB_NAME;integratedSecurity=true
(5.2)
Edit "$DSHOME/drala/dwe/conf/dw.xml", locate the key "<dw>/<database>/<url>", and append the "integratedSecurity=true" to the end of the string.
Example:
From
jdbc:sqlserver://localhost;databaseName=DB_NAME;
To
jdbc:sqlserver://localhost;databaseName=DB_NAME;integratedSecurity=true
(5.3)
Download enu.zip from http://docushare.usa.xerox.com/dsweb/Get/Document-229172/enu.zip and extract it. Locate and copy "sqljdbc_auth.dll" from "auth\x64" folder. Copy the file to "$DSHOME/bin" folder.
The DLL is from the Microsoft JDBC Driver for SQL Server release.
(6)
In the DocuShare server machine, create a user with exact same username and password as the user created in SQL server machine (the AUTH_USER). Windows Authentication will not work if the username and password configured in the database as windows authentication user does not match with the DocuShare start user.
(7)
Locate the DocuShare service entry in the OS Services panel.
Stop the DocuShare service.
(8)
Right click and select "Properties", select the "Log On" tab, select "This account" and provide the AUTH_USER account credentials.
(9)
Change DB to OS authentication mode
Login to the DB server via Microsoft SQL server management studio.
Right click on the connection and select "Properties", click "Security".
In the "Server Authentication" section, select "SQL Server and Windows Authentication mode".
Apply the changes, and restart the SQL server for the settings to take effect. Right click on the connection and select restart.
(10)
Download sqljdbc_9.4.1.0_enu.zip file from https://go.microsoft.com/fwlink/?linkid=2183120
[1] Extract the file to a temporary folder, locate "mssql-jdbc_auth-9.4.1.x64.dll" from "\auth\x64" folder
[2] Copy the file “mssql-jdbc_auth-9.4.1.x64.dll” to "$DSHOME/bin" folder
[3] Copy the file “mssql-jdbc_auth-9.4.1.x64.dll” to "$DSHOME/jdk/bin" folder
[4] Copy the file “mssql-jdbc_auth-9.4.1.x64.dll” to "$DSHOME/jdk/lib" folder
(11)
Start the DocuShare service.
Reference 1482
https://docushare.usa.xerox.com/dsweb/View/Collection-46905
Keywords sqlserver jdbc auth dll