Setting up Windows authentication for SQL Server

If you have installed BladeLogic Portal on Windows and you want communication with the portal database to use native Windows authentication, additional configuration is necessary.

1. Open the bmc-config.json file for editing.
   Typically, this file resides at <install_location>/portal/configuration/bmc-config.json.
2. In the file, search for "foundation_db_service". The foundation_db_service section typically appears as shown below:
   "foundation_db_service" : {
      "db.user" : "blportal_owner",
      "db.type" : "SQLServer",
      "db.password" : "+zWDaqMYqfQAvjpxpLq3yA==",
      "db.port" : "1433",
      "db.host" : "myserver.com",
      "metadata.name" : "foundation_db_service",
      "db.name" : "blportal",
      ...
   },   

3. Add the following property to the file:

   "db.url": "jdbc:sqlserver://myserver.com:1433;databaseName=blportal;integratedSecurity=true",
   The property shown above assumes the portal database is called "blportal."
   The foundation_db_service section now appears as shown below:
   "foundation_db_service" : {
      "db.user" : "blportal_owner",
      "db.type" : "SQLServer",
      "db.password" : "+zWDaqMYqfQAvjpxpLq3yA==",
      "db.port" : "1433",
      "db.host" : "my_server.com",
      "metadata.name" : "foundation_db_service",
      "db.name" : "blportal",
      "db.url": "jdbc:sqlserver://myserver.com:1433;databaseName=blportal;integratedSecurity=true",
      ...
   },

   Note

   Do not remove the db.user and db.password properties. Although the db.url property overrides them, the portal software still uses them for validation purposes.

4. Ensure that the Java process under which the portal's Tomcat server runs has access to Microsoft's sqljdbc_auth.dll library. This library is bundled with Microsoft's sqljdbc_enu package. 
   
   1. If necessary, download the sqljdbc_enu package from Microsoft and install it on the portal server.
   2. Copy the sqljdbc_auth.dll library from the directory where it was installed (for example, C:/Tools/Microsoft JDBC Driver 6.0 for SQL Sever/sqljdbc_auth.dll) to C:/Windows/System32.
5. Restart the portal service. From the Windows Control Panel on the portal server, select Administrative Tools > Services. Find and right-click the BladeLogic Portal service, and then select Restart.