2 Replies Latest reply on Jul 13, 2009 7:00 AM by Yann

    Solarwinds NPM. please check on SQL server version

    adpm Jul 10, 2009 9:04 PM

      Hi all,

      Just wanna check if i can proceed with the update if i have this version of SQL

      Edition                                       Version                                      Service Pack                                                                                                                                                                                                                                                    

      Enterprise Edition                 8.00.2039                                  SP4

       

      (1 row(s) affected)

       

                                                                                                                                                                                                                                                                       

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

                      May  3 2005 23:18:38

                      Copyright (c) 1988-2003 Microsoft Corporation

                      Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

       

      Hope to have your inputs and if its possible to update my npm v9.0

      Thanks

      • 1415 Views
      • Tags:
        • Re: Solarwinds NPM. please check on SQL server version
          neilmborilla
          neilmborilla Jul 10, 2009 9:58 PM (in response to adpm)

          I think here is the minimum requirements for using SQL

          The following database servers are supported as the Orion Network Performance Monitor datastore:

          1. SQL Server 2005 SP1 Express, Standard, or Enterprise
          2. SQL Server 2008 Express, Standard, or Enterprise

          Your server must support either mixed-mode or SQL authentication.

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

          The following x86 components must also be installed (if the components are not found on the target computer, the setup program downloads and installs the components):

          1. SQL Server System Common Language Runtime (CLR) Types
          2. Microsoft SQL Server Native Client
          3. Microsoft SQL Server Management Objects

          Notes:

              1. For improved performance, Orion NPM uses secure SQL CLR stored procedures for selected, non-business data operations.
              2. If you are using SQL Server 2005 SP1 Express Edition on a Windows XP operating system, enable the following protocols: Shared memory, TCP/IP, and Named Pipes.

                3. Also, Please see Denny's post Support for SQL Server 2000 ending in with the next release (2009)