12 Replies Latest reply on Sep 8, 2017 10:54 AM by it.systex@the-espgroup.com

    SolarWindsOrionDatabaseUser - Password

    ekdge

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

        • Re: SolarWindsOrionDatabaseUser - Password
          sirpaw

          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. :)

            • Re: SolarWindsOrionDatabaseUser - Password
              mdriskell

              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.

                • Re: SolarWindsOrionDatabaseUser - Password
                  ekdge

                  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.

                    • Re: SolarWindsOrionDatabaseUser - Password
                      mdriskell

                      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.

                        • Re: SolarWindsOrionDatabaseUser - Password
                          cdoyle

                          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..)

                          1 of 1 people found this helpful
                        • Re: SolarWindsOrionDatabaseUser - Password
                          AndyCoates


                          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.



                    • Re: SolarWindsOrionDatabaseUser - Password
                      hrana@pnimedia.com

                      Password is encrypted in that file

                      1 of 1 people found this helpful
                      • Re: SolarWindsOrionDatabaseUser - Password
                        it.systex@the-espgroup.com

                        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.