Maximo 7.6 and MSSQL Windows Authentication

October 30, 2015 lanxpham

Recently, I have been asked by customers if Maximo supports the use of MSSQL Windows Authentication (i.e. integratedsecurity=true).

There is not much documentation from the Maximo perspective on the use of this integratedsecurity=true, so here is some information that I have discovered during my testing.

By default, Maximo uses a specified database user Maximo and password stored in the maximo.properties file. These credentials are then used to connect Maximo to the database (sql authentication).

Some organizations have a requirement to only have their SQL Server use Windows Authentication, hence the question, can we use integratedsecurity=true with Maximo?

Yes! we sure can. Here is how...

 

1) Download and update your server to use the the supported version of the SQL jdbc driver that supports windows authentication (preferably Microsoft JDBC Driver 4.0).

For my testing, I set up a windows user maximowin that has been setup with windows authentication login for MSSQL server.

image


2) Follow the installation instructions to update the SQL driver used in Maximo.
a) In the <maximo install dir>\applications\maximo\lib directory backup the current SqlServer driver, sqljdbc.jar.
b) Copy the new sqljdbc4.jar from your installations to <maximo install dir>\applications\maximo\lib and rename it to sqljdbc.jar.


3) After that, copy the sqljdbc_auth.dll from SQL driver installation folder to \smp\maximo\tools\maximo directory.

a) Modify the maximo.propreties with the mxe.db.url string to use integratedsecurity = true and re-encrypt the properties.

http://www-01.ibm.com/support/docview.wss?uid=swg21314942

image

b) Rebuild and redeploy the maximo.ear for the changes to take affect.

 

4) Modify the WebSphere dmgr and node services to Log On with the user that will be used to authenticate to you database. As the application will use this user to authenticate with the database.

a) Restart the maximo server.

image

 

5) Check your configuration works

 

a) {Maximo_home}\SMP\maximo\applications\maximo\version.bat

This should return the verstoin installed successfully

b) {Maximo_home}\SMP\maximo\tools\maximo\updatedb.bat

Even though you have nothing that needs to be updated, it checks your connection to the database with authenticated security is ok.

c) Ensure you can log into Maximo and do not encounter any db connection issues.


I hope you have found this information useful.

Previous Article
Move Work Order to Another Day in Scheduler
Move Work Order to Another Day in Scheduler

Did you know that in Scheduler 7.6.1 users can move work orders to another day in a bundle with offset or w...

Next Article
Configuring the HTTPOnly attribute in WebSphere 8.5.5
Configuring the HTTPOnly attribute in WebSphere 8.5.5

I guess some of you have already ran into some issues where you are cannot do Direct Print because you're g...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!