5 Replies Latest reply on Dec 11, 2018 3:58 PM by hpstech

    Orion Report Writer : cannot connect to SWNetperfmon database

    l.mendoza

      Hi, any idea on this please?  I could not open the report writer. Thank you.

        • Re: Orion Report Writer : cannot connect to SWNetperfmon database

          Run the permissions checker from the orion directory and then re-run the configuration wizard. swnetperfmon is actually a configuration file in the orion directory. If that fails run a repair on the installation of npm.

            • Re: Orion Report Writer : cannot connect to SWNetperfmon database
              l.mendoza

              Still not working..opened a case with solarwinds and now raised with dev.

                • Re: Orion Report Writer : cannot connect to SWNetperfmon database
                  hpstech

                  Was this ever resolved?

                   

                  This article didn't apply to us since our SQL server is remote distributed and not a local instance SQL - Unable to open Report Writer: Cannot connect to database - SolarWinds Worldwide, LLC. Help and Support

                    • Re: Orion Report Writer : cannot connect to SWNetperfmon database
                      hpstech

                      Resolved -

                       

                      Trap Report Writer, Syslog Viewer, Trap Viewer or UnDP Poller error:

                       

                      Error=Invalid connection string attribute

                       

                      Overview

                      Unable to open the following services:

                      • Report Writer

                      • Syslog Viewer

                      • Trap Viewer

                      • Universal Device Poller

                      Error while opening main database: Cannot connect to SWNetPerfMon database

                      provider=SQLOLEDB.1;persist security info=False;use procedure for prepare=1;auto

                      translate=True;packet size=4096;workstation id=DN1V203VM117;use encryption for

                      data=FALSE;tag with column collation when possible=False;user

                      id=SolarWindsOrionDatabaseUser;Password='*********';data source=100.66.34.73;initial

                      catalog=SolarWindsOrion;max pool size=1000

                      Error=Invalid connection string attribute

                      Environment

                      • All Orion Platform versions

                      • All Windows versions

                       

                      Cause

                      TLS 1.0 is disabled on One of the Orion Servers or on the SQL server, this can be found in:

                      HKLM SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols . This is required.

                      Copyright © 2018 SolarWinds Worldwide, LLC. All rights reserved worldwide. No part of this document may be reproduced by any means nor

                      modified, decompiled, disassembled, published or distributed, in whole or in part, or translated to any electronic medium or other means

                      without the written consent of SolarWinds. All right, title, and interest in and to the software and documentation are and shall remain the

                      exclusive property of SolarWinds and its respective licensors.

                       

                       

                      Resolution

                      Change the Connection String Provider from SQL OLE Client to SQL Native Client.

                      1. Edit ..\SolarWinds\Orion\SWNetPerfMon.db (install Directory) in a text editor.

                      2. Download and install SQL Native Client 2012 x86 and x64. See https://www.microsoft.com/en-us/download/

                      details.aspx?id=50402

                      3. Change the ConnectionString=Provider value in the most recent Connection String. By default, this will

                      be SQLOLEDB.1 and should be changed to SQLNCLI11.

                      # Encrypted Connection String for SQL Server added by Orion Core Services

                      # 3/10/2017 2:24:25 PM

                      ConnectionString=provider=SQLOLEDB.1;persist security info=False;use procedure

                      for prepare=1;auto translate=True;packet size=4096;workstation id=SUP-AUSCKLI-

                      01;use encryption for data=FALSE;tag with column collation when

                      possible=False;User ID=cklinedinst;Encrypted.Password="AQAAANCMnd8BFdERjHoAwE/

                      Cl+sBAAAAQFWt4cXbgk6So+8t+SSLcwQAAAACAAAAAAAQZgAAAAEAACAAAAApfCKimgDBUOQ3r5cY2dgI83I6zYDBS98HIkza2WCdEQAAAAAOgAAAAAIAACAAAAACzGr2/

                      i7oNoQNmcR0cyF0i1s0dV1ZD/

                      nDwndSOfNrlxAAAADePZfqziI8wT8VawLNnGjMQAAAAFSHyivbz6mM5WnXdG+SLvH/

                      TxrteWF9rTSIobNoEHokgzc0E0wJ935Hj58D00cXcXvtl6UVQh/2SSFgFX4/Le4=";Data

                      Source=sup-aus-sql-01.swdev.local\TECH_SUPPORT;Initial Catalog=CKLI-121;Max Pool

                      Size=1000

                      4. Restart Orion Services.

                       

                      Alternative Option:

                      1) Go here and download and install IIS Crypo

                      https://www.nartac.com/Products/IISCrypto/Download

                      2) Check TLS 1.0 and then click APPLY

                      3) Warning: it will force you to reboot the server in order to take effect

                      4) After a system reboot go back and launch Report Writer, SysLogViewer, Trap Viewer etc.