Hi, any idea on this please? I could not open the report writer. Thank you.
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.
Still not working..opened a case with solarwinds and now raised with dev.
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
case number?
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
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.
