HP Web Jetadmin - Microsoft SQL Connections and HP Web Jetadmin

ManualsBrandsHP ManualsSoftwareHP Web Jetadmin Software

MICROSOFT

SQL CONNECTIONS

and HP Web Jetadmin

CONTENTS

Introduction ............................................................................................................................. 2

Accessing SQL Views ................................................................................................................ 2

Using SQL Server Configuration Manager ................................................................................... 3

Enabling and Starting the SQL Server Browser Service.................................................................. 5

Checking the Connection .......................................................................................................... 6

Using an ODBC Connection ...................................................................................................... 6

Summary ................................................................................................................................. 8

NOTICE: This document describes software and operations that Hewlett-Packard does not

support. The software and operations described in this document are related to

HP Web Jetadmin and its data and settings structures. This document is accurate to

the extent that it is written in an Active Directory environment with Microsoft

Windows 7 and HP Web Jetadmin. Please read and understand all the

documentation regarding the Microsoft Windows and Microsoft SQL Server functions

and features described in this document.

Summary of content (8 pages)

PAGE 1
MICROSOFT® SQL CONNECTIONS and HP Web Jetadmin CONTENTS Introduction .............................................................................................................................2 Accessing SQL Views................................................................................................................2 Using SQL Server Configuration Manager ...................................................................................3 Enabling and Starting the SQL Server Browser Service......
PAGE 2
INTRODUCTION HP Web Jetadmin and Microsoft SQL provide a variety of ways to gather and work with device details. Device details are bits of information about a printer or multifunction device, such as page counts and supply levels. The information that can be obtained from devices varies widely and can be used for many purposes and in many functions. Integrating this information into business processes can provide critical value in many types of services plays.
PAGE 3
USING SQL SERVER CONFIGURATION MANAGER You must use SQL Server Configuration Manager to configure the HP Web Jetadmin SQL instance to open up the remote connection needed to get the device data. This is a fairly simple operation; however, there can be more to allowing access to a system than simply adjusting settings through this utility.
PAGE 4
Next, you must enable the SQL Server Browser that allows remote access to SQL instances. Figure 3 shows the properties for this service, which are also accessible via SQL Server Configuration Manager. Figure 3 – SQL Server Browser Properties Note that default installations of SQL Server typically have the SQL Server Browser Service fully disabled by default as shown in Figure 3. In fact, to bring the SQL Browser Service online, you must activate it via Windows Service Manager.
PAGE 5
ENABLING AND STARTING THE SQL SERVER BROWSER SERVICE Using the Windows Services utility found under Start, Control Panel, Administrative Tools, Services, locate the SQL Browser service as shown in Figure 4. Figure 4 – SQL Server Browser Service Properties Using these properties, set the Startup type to Manual or Automatic, and then click Apply. Then click Start to start the Browser service. At this point, you have a SQL Server instance that should allow remote connection.
PAGE 6
CHECKING THE CONNECTION Now you are ready to test the connection using your remote Microsoft Excel. Simply use the Data Connection Wizard shown in Figure 5. If the connection succeeds, a new Data Connection Wizard dialogue appears as shown in Figure 5. If this dialogue appears, you have established a successful connection to the SQL database instance and can now proceed with Excel or a similar application.
PAGE 7
Once in the ODBC Data Source Administrator, click Add. Figure 7 shows the resulting driver selection. Select the appropriate driver, and click Finish. Next, a wizard appears that guides you through actually setting up the SQL ODBC connection. Add details as needed to the wizard (shown in Figure 8), and click Next. The format for the SQL host/instance is shown in Figure 8. Figure 7 – Selecting the ODBC driver The next step in the wizard (shown in Figure 9) is authenticating to the SQL Server instance.
PAGE 8
If the wizard progresses to the next screen (shown in Figure 10), the utility was able to establish contact with the database instance. This is a good sign! At this point, you can choose to set the data source connection to always go to the HPWJA database catalogue, which HP recommends if you are interested primarily in the HP Web Jetadmin device data. Otherwise, you must tell your tools or applications where the catalogue resides for each and every query.