Web JetAdmin 10.4 SQL Server not started

[Mike915]

I'm installing Web JetAdmin 10.4 SR3 on a Windows 10 64-Bit Workstation.  Everything installed correctly from what I can see but when I lauch the application it says Microsoft SQL Server: Stopped.  I manually started the SQL Server instance and relaunched the app but get the same message.

[WinnyM]

Hello,

WJA SQL Stopped is a common issue when WJA is not able to connect to the SQL DataBase (Local or Remote).

If HP Web Jetadmin indicates that Microsoft SQL Server is Stopped after the HP Web Jetadmin service
is restarted, there are issues connecting to the SQL server.
If this occurs right after the initial installation of HP Web Jetadmin, there might be policies or
permissions that restrict SQL Server Express from being installed completely. Many times in this
scenario, HP Web Jetadmin could not create all of the necessary files in its directories. In this case, try
running the command-line installer mentioned previously to bypass the SQL Express database
installation. This should ensure that all the HP Web Jetadmin files are present.

This message is also quite common if HP Web Jetadmin was installed from the command line to
bypass the SQL Express installation. This message subsequently disappears after the configuration file
is edited to point to the remote SQL instance and database and the HP Web Jetadmin service is
restarted.
If this issue occurs only after attempting to point to a remote SQL Server, the
DatabaseSettings.config.xml file is probably being read, but something is preventing HP Web
Jetadmin from connecting to the remote database. For clues on why the connection is failing, check
the trace logs in one of the following directories:
C:\Windows\ServiceProfiles\NetworkService\AppData\Local\HP Inc\HPWebJetadmin\
WjaService\tracing 6
C:\Windows\ServiceProfiles\NetworkService\AppData\Local\HP Inc\HPWebJetadmin\
WjaService\tracing 6
The files named HPWJAService-xxx.itl (where xxx represents a series of numbers) might contain
helpful troubleshooting information.

For additional information you can also refer to the technical white paper: USING MICROSOFT SQL SERVER with HP Web Jetadmin

http://h10032.www1.hp.com/ctg/Manual/c01763040

[WinnyM]

I hope this information helps.

Good Luck!

Say thanks by clicking the Kudos Thumbs Up in the post.

If my post resolved your problem, please mark it as an Accepted Solution