Title
Deploy Microsoft SQL Server 2000 plugin for OEM Grid Control 10g

Date
2007-05-10

Summary
These instructions describe how to deploy the OEM Grid Control plugin for Microsoft SQL Server 2000.

Details
1. Perform the following on the server running Microsoft SQL Server 2000.

Install Windows Management Instrumentation:
     a. The WMI for SQL Server 2000 is located in <cd_drive>/x86/other/wmi (obtainable from wmi.zip)
     b. Run setup.exe

Confirm that the Windows Management Instrumentation service is running:
     a. Go to Control Panel --> Administrative Tools --> Services
     b. Confirm that Windows Management Instrumentation is running

Confirm that you can log in to SQL Server as a systems account:
     a. Run the program Query Analyzer
     b. Choose SQL Server authentication
     c. For example, log in as user sa

Confirm that TCP/IP is enabled on SQL Server:
     a. Run SQL Server Enterprise Manager
     b. Right-click on (local) (Windows NT) or equivalent
     c. Click on the tab General
     d. Click on Network Configuration
     e. Confirm that TCP/IP is an enabled protocol

Deploy the JDBC driver to the Agent:
     a. Create a directory on the Agent server: <AGENT_HOME>/sysman/jdbcdriver
     b. Copy the following files to that directory:
            msbase.jar
            mssqlserver.jar
            msutil.jar
        (Can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en)
     c. Edit <AGENT_HOME>/sysman/config/config.lst and add to the bottom:
            C:\oracle\agent10g\sysman\jdbcdriver\msbase.jar
            C:\oracle\agent10g\sysman\jdbcdriver\mssqlserver.jar
            C:\oracle\agent10g\sysman\jdbcdriver\msutil.jar
     d. Restart the Agent

2. Log on to the OEM Grid Console and perform the following.

Ensure that Preferred Credentials are set for both the Agent and the Host:
     a. Go to Preferences --> Preferred Credentials
     b. Click on Set Credentials beside Agent, and set and save credentials
     c. Click on Set Credentials beside Host, and set and save credentials

Deploy the SQL Server plugin to OEM:
     a. Go to Setup --> Management Plug-ins --> Import --> Browse
     b. Locate microsoft_sqlserver_database.jar on your local computer
     c. Click on List Archive
     d. Check the plug-in and click on OK
     e. Click on the Deploy button beside the plug-in
     f. Click Add Agents and choose the Agent
     g. Click Next --> Finish

Add the SQL Server target:
     a. Go to Setup --> Agents
     b. Click on the applicable Agent
     c. Add a Microsoft SQL Server target
     d. Use the following values (default SQL Server port is usually 1433): 
         Name:                 <any unique name>
         JDBC URL:             jdbc:microsoft:sqlserver://<hostname>:<port>
         JDBC Driver:          com.microsoft.jdbc.sqlserver.SQLServerDriver
         Database Username:    sa             (if using 'sa' account)
         Password of DB User:  <sa_password>

Troubleshooting:

  • To find out the SQL Server port on SQL Server 2000:
         - Run regedit
         - Port is located in one of the following:
                HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\
                SuperSocketNetLib\Tcp
                HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\
                <Instance Name>MSSQLServer\SuperSocketNetLib\Tcp

  • If setting Preferred Credentials fails:
         a. If OEM GC is not accepting the password, then on the server running SQL Server, try checking the following:
         b. Go to Control Panel --> Administrative Tools --> Local Security Settings
         c. Expand Local Policies
         d. Click on User Rights Assignment
         e. Make sure the operating system user is located in the following:
                - Log on as a batch job <-- required
                - Act as part of the operating system
                - Replace a process level token

  • If unable to log in to SQL Server as a systems account
         a. If not or if you are getting a Not associated with a trusted SQL Server, then try the following:
         b. Run SQL Server Enterprise Manager
         c. Right-click on (local) (Windows NT) or equivalent
         d. Click on the tab Security
         e. Choose SQL Server and Windows authentication and System account for startup

    • Applicable Versions
    Oracle Enterprise Manager 10g Grid Control (10.2.0.3)
    Microsoft SQL Server 2000

    References
    Oracle Enterprise Manager System Monitoring Plug-in Installation Guide for Microsoft Internet Information Services (b28047.pdf)
    Ahmed Aboulnaga
    .com .com