HP Web Jetadmin Software Manuale Utente Scaricare il pdf

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 H 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.

1 2 3 4 5 6 7 8

Sommario

Pagina 1 - SQL CONNECTIONS

MICROSOFT® SQL CONNECTIONS and HP Web Jetadmin CONTENTS Introduction ...

Pagina 2 - ACCESSING SQL VIEWS

2 Figure 1 – Error using Excel to source SQL data INTRODUCTION HP Web Jetadmin and Microsoft SQL provide a variety of ways to gather and work with de

Pagina 3

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 re

Pagina 4

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 a

Pagina 5 - SERVICE

5 ENABLING AND STARTING THE SQL SERVER BROWSER SERVICE Using the Windows Services utility found under Start, Control Panel, Administrative Tools, Serv

Pagina 6 - USING AN ODBC CONNECTION

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 F

Pagina 7

7 Figure 8 – Creating a New SQL Data Source Once in the ODBC Data Source Administrator, click Add. Figure 7 shows the resulting driver selection. Sel

Pagina 8 - SUMMARY

8 Figure 10 – More Data Source Settings If the wizard progresses to the next screen (shown in Figure 10), the utility was able to establish contact w