HP Web Jetadmin Software Manual do Utilizador descarregar pdf (Página 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.................................................................. 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

Resumo do Conteúdo

Página 1 - SQL CONNECTIONS

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

Página 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

Página 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

Página 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

Página 5 - SERVICE

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

Página 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

Página 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

Página 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