1 of 1 people found this helpful
First things to check:
- You have a valid license, you can check this by running the license manager (it'll be in the SolarWinds start menu folder).
- Confirm that all your SolarWinds services are running, you can check this by running the Orion Service Manager (again it'll be in the SolarWinds start menu folder)
- IF both options above have been checked and are ok, run the configuration manager and repair the Orion website (bet you can't guess where the shortcut to this is...)
If you follow the above, it should sort your problem out.
Thanks for you help.
My license is okay, just the support time expired.
I checked in the Orion Service Manager, all services are running except the Solarwinds Syslog Service, I tryed to start it, but the service stay up for some seconds and then stop again.
After did that I tried run the Configuration Wizard and when I was running it, it gave a message error that my DB is full. I find out that SQL Server 2005 Express has a DB limitation (4GB), so I looked at some threads that the best choice is upgrade it to SQL Server 2008 (that has a limitation in 10Gb). I did it and then restart the server, but unfortunatelly the services not start to work.
Do you know what else I need to do for recover the service ?
1 of 1 people found this helpful
Now that you've installed SQL 2008 and moved the database, you'll need to run the configuration wizard and select the database option, then point the wizard to the new database server. Hopefully that will resolve the problem, since you've sorted out the database size limit.
Note that you may need to check that the database itself isn't set to a maximum size of 4GB, and that it's seeing the new size limit provided by SQL 2008.
After read your message I ran the Configuration Wizard again with the Default setttings (selected all services, Website, Database and Services), but I got below message error:
So, it shows a problem in the DB side still....
If I do the procedure that you talked (about the Configuration Manager) and point the the Database for a new server, I will not lost my currnet data ?
About the SQL limitation, how I can check the DB limitation now? There are a specif query to run ?
At this point I think you'd be better off speaking with support... but you may find that difficult if the maintenance on your license has expired! (always the way, you pay for maintenance and you never need it, but when you do.....)
For the SQL migration, the procedure would be:
- Open the Orion Service Manager and click 'Stop Everything'.
- Make a full backup of your Orion database - in your case, 'SolarWindsOrion' on your SQL Express 2005 server.
- In SQL Server 2008 (the DB engine you advised you had deployed earlier), import then backup of your database.
- Load up SQL Server Management Studio, and connect to your SQL Server 2008 instance using the Database Engine.
- Expand databases, right-click on your SolarWindsOrion database (which was imported in step 3 above) and select 'properties'
- Under files, check the autogrowth/maxsize detals for the various file groups. They should have an unlimited max size.
- On your primary SolarWInds poller, run the Configuration Wizard, select database and connect to the new SQL 2008 server and database.
- Run through the wizard and finish.
- Finally, open the Orion Service Manager and start click 'Start Everything'.
This should resolve the problem. If it doesn't, you may have to bit the bullet and renew your support and log a ticket. There may be an option to have one off paid for support, but I'm not aware of this option.
I ran and query and find out that the DB was not upgrade, something went wrong, it still using the 2005 that has the size limitation.
I solved the problem temporarily, I did the "Shrink" in the database and start the service again, after that I could access again.
I will try to upgrade the system again to SQL 2008 how you described.
Thank you so much for your help.
I have same problem,
and this page doesnt give a solution
anyone know how to fix this?
Wow bambarit this thread is pretty old as it's from 2015 and a lot has changed in NPM since then. I would suggest you should have started a new thread, but none the less it would be best to see the exact error message you are getting in your environment along with some additional information such as what NPM version your running along with the windows environments.
There are a few variations of this error message, but some general rules of thumb are:
Check the hosts file
Check the firewall connectivity to the DB
Check the SQL Credentials to ensure they are correct
Check the SWIS Service is running and doesn't need repairing
Check the Job Engine is running and doesn't need repairing.
Some of these common issues can be repaired using the Configuration Wizard, so that would be the first step, but yeah let's see a screenshot.
hi dgsmith80 I think config wizard doesnt resolving the problem,
I already check firewall, sq credential and there is no issue.
services & job engine also running well,
this happen after upgrade.. :meh