Unable to change the Account Type Error in the SolarWinds Web Console

When trying to add a domain account an error occurs:

Invalid account type specified.
Unable to change the Account Type

This issue occurs due to a duplicate account exists in the SolarWinds database under the Accounts table.  The most common reason is:

• The domain account that was trying to be added as an Individual Account is already a member of a Domain group that is being used as a login to SolarWinds Web Console.

To workaround this issue, use one of the following resolutions:

Resolution 1:

1. RDP to the SolarWinds Server.
2. Open Database Manager from the SolarWinds Platform folder of the Start Menu.
3. Click Add Orion Server, and expand the SQL server and SolarWinds database in bold.
4. Right-click on the database and select New query...
5. Paste the query below in the new query tab

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   SELECT * FROM [dbo].[Accounts]
   WHERE AccountID = 'TypeHere'

6. Click Execute query 
7. Delete the row for the user
   • How to delete a row from the database using Database Manager in the Orion platform
8. Add the Domain account as an Individual Account

Resolution 2:

1. RDP to the SolarWinds Server.
2. Open Database Manager from the SolarWinds Platform folder of the Start Menu.
3. Click Add Orion Server, and expand the SQL server and SolarWinds database in bold.
4. Click the (+) sign to expand and see the tables.
5. Double click on the Accounts table and click Execute query.
6. Look for the account that you're trying to add and review the GroupInfo column to confirm if it's the right Group the Account is supposed to be in.
7. Delete the row that contains the account:
   • How to delete a row from the database using Database Manager in the Orion platform
8. Add the Domain account as an Individual Account.