HP Storage Essentials NAS Manager Software - Manual (Page 164)

Discovering Applications, Backup Servers and Hosts 132
• Host IP/DNS Name: 192.168.2.10
• Database Server: SQLTEST
• Port Number: 1433
• Database Type: SQLSERVER
6. In the Port Number field, type the port that SQL is using. If you do not provide a port number,
the management server assumes the SQL server is using port 1433 (default).
To determine the correct SQL Port Number that the SQL Server is using, follow these steps:
a. Open SQL Server Enterprise Manager.
b. Expand the user interface for SQL Server Enterprise Manager, and then select the specific
SQL server. Right-click and then select Properties from the drop-down menu.
c. Click the Network Configurations button. On the General Tab, select the TCP/IP entry
under the Enabled Protocols section. 'Then, click the Properties button.
d. The resulting window shows you the TCP/IP port your SQL server uses. Provide this port
number in the Port Number field on the management server.
7. Select SQLSERVER from the Database Type menu.
8. Click OK.
IMPORTANT: Perform Get Details/Discovery Data Collection for your inputs to take effect. See
” Step 3 - Discovering Applications ” on page 137.
Removing the APPIQ_USER Account for SQL Server
IMPORTANT: Before you remove the APPIQ_USER account for the SQL Server databases on a host,
make sure no processes are running APPIQ_USER for that SQL Server database. The management
server uses APPIQ_USER to obtain information about a SQL Server database. (Discovery from HP SE
only)One of the ways to make sure APPIQ_USER is not being used is to temporarily remove the host
running SQL Server (Discovery > Topology). After you removed the APPIQ_USER account for SQL
Server, discover and perform Get Details for the host if you want to continue monitoring it.
To remove the APPIQ_USER account for the SQL Server databases on a host:
1. To run the script on Microsoft Windows, go to the DBIQ\sqlserver\win directory on the
CIM Extensions CD-ROM.
IMPORTANT: You must complete the following steps.
2. Verify you have the password to the server administrator user account.
You are prompted for the password for this user account when you run the script.
3. Run the UninstallSQLServerAct.bat script on Microsoft Windows on the computer with
the SQL Server database.
4. Type the name of the SQL Server server.