
Maximo 7.6 and MSSQL Windows AuthenticationRecently, 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 http 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.
5) Check your configuration works
a) {Max This should return the verstoin installed successfully b) {Max 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.
|