cancel
turn on suggested results
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Locked It has been a while since anyone has replied. Simply ask a new question if you would like to start the discussion again.
scots
New member
1 0 0 0
Message 1 of 1
70
Flag Post

Web JetAdmin not working after changing from SQL Express to SQL 2017

‎05-19-2020 12:19 PM

HP Recommended
Product: Web JetAdmin
Operating System: Microsoft Windows Server 2016

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?

Warning Be alert for scammers posting fake support phone numbers and/or email addresses on the community. If you think you have received a fake HP Support message, please report it to us by clicking on "Flag Post".

Didn't find what you were looking for? Ask the community

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation