We've had Web JetAdmin running on a server with Windows Server 2016 for a while using the included SQL Express. The server was basically underutilized with only Web JetAdmin on it, so it was decided to install some other things on the server. Those other things required a full version of SQL rather than SQL Express. So - our SQL admin exported the Web JetAdmin database, removed SQL Express, installed SQL 2017, and imported the Web JetAdmin database into SQL 2017. SQL 2017 is running on the same server as Web JetAdmin, just as SQL Express was.
Web JetAdmin no longer works since this was done. Web JetAdmin indicates that Microsoft SQL Server is stopped when we try to start Web JetAdmin. SQL Server is not stopped. I've logged in to SQL Server Management Studio and verified that the HPWJA database is in there. I've verified that all necessary services are running. I need to get this running ASAP, and the other option I've been given by my manager if I can't get it fixed is to remove and reinstall Web JetAdmin - basically starting all over again. I really don't want to do that, because it's a TON of work to start over again because I'll have well over 100 subnets I'll have to add in and scan. There's GOT to be some way to get it to recognize this existing database that got moved over to SQL 2017 - I just haven't been able to figure it out.
Can anyone please help me with this?