Hi everyone,

Need your advice on below issue please. In one of my windows VM, I have maximo 761 installed with Oracle database. And I want to use mssql database instead of Oracle. So I have installed MS SQL server database (express edition) and followed ibm document for configuring mssql db manually. And updated maximo.properties to point to sql database. But when executing encryptproperties.bat getting below driver (com.inet.tds.Tdsdriver) not found error. Has anyone faced this earlier or any advise please...?

Error message:

Starting Encryption of Maximo.properties. Wed Apr 05 22:32:06 CST 2023 --- Starting ---- BMXAA6806I - Reading the properties file maximo.properties. java.lang.ClassNotFoundException: com.inet.tds.TdsDriver at java.lang.Class.forNameImpl(Native Method) at java.lang.Class.forName(Class.java:295) at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1426) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) java.lang.Exception: BMXAA6813E - The database driver was not established: com net.tds.TdsDriver at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1436) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) BMXAA6813E - The database driver was not established: com.inet.tds.TdsDriver W Apr 05 22:32:06 CST 2023 BMXAA6819I - EncryptProperties completed with errors. Wed Apr 05 22:32:06 CST 23

This error is resolved and could connect to mssql DB by using the below driver instead of  "mxe.db.driver=com.inet.tds.TdsDriver"
com.microsoft.sqlserver.jdbc.SQLServerDriver.

However when maxinst command is run (maxinst -tPRIMARY -sPRIMARY -imaxdb76), it's failing to read maxdb76.SQS file saying access denied error although user has full permission.
Any suggestions please?

Error Message:

C:\maximo\maximo\tools\maximo>maxinst -tPRIMARY -sPRIMARY -imaxdb76
!
!!! WARNING !!!
!
! Maxinst will drop and rebuild all the tables in your database.
!
! If you are not sure you should be running Maxinst, hit Ctrl/C now!!!!
!
! Otherwise,
Press ENTER to continue . . .

Log file: Cleandb20230406124501.log
Connecting to: jdbc:sqlserver://192.168.189.128:1433;databaseName=maxdb76
Cleandatabase complete: Successful
Thu Apr 06 12:45:03 CST 2023 --- Starting ----
BMXAA6806I - Reading the properties file maximo.properties.
java.io.FileNotFoundException: en\maxdb76.sqs (Access is denied.)
        at java.io.FileInputStream.open(FileInputStream.java:212)
        at java.io.FileInputStream.<init>(FileInputStream.java:152)
        at java.io.FileInputStream.<init>(FileInputStream.java:104)
        at psdi.configure.Maxinst.endSetupInstance(Maxinst.java:2463)
        at psdi.configure.CommonShell.endSetup(CommonShell.java:1722)
        at psdi.configure.CommonShell.setup(CommonShell.java:1232)
        at psdi.configure.Maxinst.main(Maxinst.java:2551)
java.lang.Exception: Input file en\maxdb76.sqs could not be read.
        at psdi.configure.Maxinst.endSetupInstance(Maxinst.java:2478)
        at psdi.configure.CommonShell.endSetup(CommonShell.java:1722)
        at psdi.configure.CommonShell.setup(CommonShell.java:1232)
        at psdi.configure.Maxinst.main(Maxinst.java:2551)
Input file en\maxdb76.sqs could not be read. Thu Apr 06 12:45:05 CST 2023
BMXAA6819I - Maxinst completed with errors. Thu Apr 06 12:45:05 CST 2023

Hi everyone,

Need your advice on below issue please. In one of my windows VM, I have maximo 761 installed with Oracle database. And I want to use mssql database instead of Oracle. So I have installed MS SQL server database (express edition) and followed ibm document for configuring mssql db manually. And updated maximo.properties to point to sql database. But when executing encryptproperties.bat getting below driver (com.inet.tds.Tdsdriver) not found error. Has anyone faced this earlier or any advise please...?

Error message:

Starting Encryption of Maximo.properties. Wed Apr 05 22:32:06 CST 2023 --- Starting ---- BMXAA6806I - Reading the properties file maximo.properties. java.lang.ClassNotFoundException: com.inet.tds.TdsDriver at java.lang.Class.forNameImpl(Native Method) at java.lang.Class.forName(Class.java:295) at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1426) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) java.lang.Exception: BMXAA6813E - The database driver was not established: com net.tds.TdsDriver at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1436) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) BMXAA6813E - The database driver was not established: com.inet.tds.TdsDriver W Apr 05 22:32:06 CST 2023 BMXAA6819I - EncryptProperties completed with errors. Wed Apr 05 22:32:06 CST 23