Maximo 7.6 and MSSQL Windows Authentication
lanxpham 270003YRBB Visits (11853)
Recently, I have been asked by customers if Maximo supports the use of MSSQL Windows Authentication (i.e. inte
There is not much documentation from the Maximo perspective on the use of this inte
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 inte
Yes! we sure can. Here is how...
1) Download and update your server to use the the
For my testing, I set up a windows user maximowin that has been setup with windows authentication login for MSSQL server.
a) Modify the maxi
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.
5) Check your configuration works
This should return the verstoin installed successfully
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.