Upgrading quesion

Question

HI,

Our company is planing to upgrade NPM from 9.1 to 10.1.3, and I want to confirm if NPM10.1.3  is compatiable with SQL Server 2008 R2,  please inform me if you have any advice.

Best regards,

Steven

stevenliu · Answer

Thanks for your reply.

pacetti · Answer

From "Requirements for the Orion Database Server (SQL Server)" in the SolarWinds Orion NPM Administrator Guide:

SQL Server 2005 Express, Standard, or EnterpriseSQL Server 2008 Express, Standard, or EnterpriseSQL Server 2008 R2 Express, Standard, or EnterpriseNotes:              •	SolarWinds strongly recommends maintaining SolarWinds servers as physically separate from your SQL server.

•	SQL Server Compact 3.5 SP2 is only supported for Orion evaluations.

•	Due  to latency effects, SolarWinds does not recommend installing your SQL  Server and your Orion server or additional polling engine in different  locations across a WAN. For more information, see SolarWinds Knowledge  Base article, “Can  I install my Orion server or Additional Polling Engine and my Orion  database (SQL Server) in different locations across a WAN?”

•	Either mixed-mode or SQL authentication must be supported.

•	If you are managing your Orion database, SolarWinds recommends you install the SQL Server Management Studio component.

•	If  your NPM product installs SQL Server System CLR Types, a manual restart  of the SQL Server service for your Orion database is required.

•	Use the following database select statement to check your SQL Server version, service pack or release level, and edition:

select SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
HTH,

nrms · Answer

I am running 10.1.2 with MS SQM Server 2008 R2, so I imagine 10.1.3 would also be compatible.