I followed a lesson video (Getting Started with AAI for Automic Automation) in Broadcom Software Academy to set up AAI on windows. However, after I executed both the createDevices & createJawsDB scripts in the database management studio, the configtool database connection test shows "Database found but AAI tables do not exist". I followed an article that has the following issue's resolution. To copy the ojdbc8 jar file from Oracle Install Client into the AAI\jboss\standalone\deployments folder. However, the same connection issue persists.
We could see network error in the configtool logs
The server name in configtool was AUTOMIC
In the MSSQLstudio it was AUTOMIC\SQLEXPRESS
Edited database in configtool to use AUTOMIC\SQLEXPRESS but still, it did not connect.
The SQL server manager -> Network configuration -> protocols
The TCPIP was disabled. Only Shared memory was enabled.
This is the reason why we were not able to connect as the port 1433 specified in configtool was not available
Customer will install an enterprise version of the database and do the install. If he comes across any issue then he will open a case and agreed that this case can be closed.