cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

SolarWindsOrionDatabaseUser - Password

Jump to solution

What is the default password for SolarWindsOrionDatabaseUser under Orion Configuration Wizard?

1 Solution


well, when I pressed the "Use original database login and password" button it filled out SQL server name as local and provided login and password for the SQL server. It also allowed me to click next from that 1st screen, however, when I tried to provide the existing SQL login in 3rd screen, I couldn't type the password for "SolarWindsOrionDatabaseUser". My understanding is there should be a default one as I could go thru the 1st screen as shows above.

I detached earlier, and would like to backup my default DB using the above login to restore if possible for my Lab.



If you just want the current password Orion is using, it's stored in SWNetPerfMon.db in the Orion subfolder of your install, e.g.

C:\Program Files (x86)\Solarwinds\Orion\SWNetPerfMon.db
(remove the (x86) for 32bit OS)

It's a plain-text file, just open it with Wordpad.

Andy.



View solution in original post

12 Replies
Level 8

Try the following:

Username: SolarWindsOrionDatabaseUser

Password: S0l@rFl@r3

Seen this as the default on a few installs that Solarwinds support have been involved with at some stage when there have been issues with SQL.

Level 7

Password is encrypted in that file

Level 12

Hi ekdge,

I believe there is no default password here, are you also managing the SQL server you are using for Orion?you should seek some help from your DBAs or create a new login to use. 🙂

0 Kudos

Sorry wrong button my eyes are tired...I meant to suggest sirpaw's answer as correct not verify it.  

He is correct though the database user is setup by the installer and there is no default it is defined by the user while configuring.

0 Kudos

well, when I pressed the "Use original database login and password" button it filled out SQL server name as local and provided login and password for the SQL server. It also allowed me to click next from that 1st screen, however, when I tried to provide the existing SQL login in 3rd screen, I couldn't type the password for "SolarWindsOrionDatabaseUser". My understanding is there should be a default one as I could go thru the 1st screen as shows above.

I detached earlier, and would like to backup my default DB using the above login to restore if possible for my Lab.

0 Kudos


well, when I pressed the "Use original database login and password" button it filled out SQL server name as local and provided login and password for the SQL server. It also allowed me to click next from that 1st screen, however, when I tried to provide the existing SQL login in 3rd screen, I couldn't type the password for "SolarWindsOrionDatabaseUser". My understanding is there should be a default one as I could go thru the 1st screen as shows above.

I detached earlier, and would like to backup my default DB using the above login to restore if possible for my Lab.



If you just want the current password Orion is using, it's stored in SWNetPerfMon.db in the Orion subfolder of your install, e.g.

C:\Program Files (x86)\Solarwinds\Orion\SWNetPerfMon.db
(remove the (x86) for 32bit OS)

It's a plain-text file, just open it with Wordpad.

Andy.



View solution in original post

thanks a million andy

0 Kudos

Thank you Andy. You answered the password lookup part. 

0 Kudos

If you just want the current password Orion is using, it's stored in SWNetPerfMon.db in the Orion subfolder of your install, e.g.

Wow great tip Andy....I can't tell you how many times when I was doing consulting I ran into this where we were reconfiguring and the client didn't know their password.  I didn't know there was the ability to look it up.

0 Kudos

When you are going through the configuration manager after an initial setup it will attempt to use the previous information.  It is by no means a default it is just auto-populating with the prior settings.

As Sirpaw stated if you do not have the password you will need someone with SQL knowledge to create you a new account to use.

0 Kudos

If the SQL server is installed locally, you will be able to log into it using an Administrator acocunt on the server (the Admins group is added by default with sa privege level). If the SQL server was installed as part of your Orion eval, or you know for certain there's no other databases on there, then you should be OK to change the SA account and password, and then use that account to run the configuration wizard - this will let you create a new account for Orion to read/write to the database with, instead of the default user.

 

Once you have install Microsoft SQL server management studio Express, please use these instructions to reset the password for your SA account:

 

 - Log into your Orion server using a local administrator account (not a domain account).

 - Open SQL server management studio express, and connect using Windows Authentication. You should automatically have access rights to the database when logged on with a local admin account.

 - Expand the Security folder, then expand the Logins folder.

 - Locate the SA account under here.

 - Right click the account and open Properties.

 - Change the password and confirm password text boxes and click OK. 

 

 

Now, run the configuration wizard again. In the first prompt, enter the new sa account and password. This will provide the configuration wizard with sufficient privileges to create a new account. When prompted about whether to create a new account or to use and existing one, choose to create a new account, and enter in the details. 

 

(edited to correct my painful spelling there..)

Thank you cdoyle. SA login worked for me. I was able to restore that way.

0 Kudos