HP Web Jetadmin Software Uživatelský manuál

Procházejte online nebo si stáhněte Uživatelský manuál pro Software HP Web Jetadmin Software. Using Microsoft SQL Server with HP Web Jetadmin Uživatelská příručka

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 30
  • Tabulka s obsahem
  • ŘEŠENÍ PROBLÉMŮ
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 0
USING MICROSOFT
®
SQL SERVER
with HP Web Jetadmin
CONTENTS
Overview ............................................................................................................................. 2
Introduction ........................................................................................................................... 2
First time installation of HP Web Jetadmin ................................................................................. 2
Migrate the HP Web Jetadmin data ......................................................................................... 3
Use a local SQL Server database ............................................................................................. 3
Install SQL Server ............................................................................................................... 3
Create a named SQL instance .............................................................................................. 4
Create a new database ....................................................................................................... 5
Configure HP Web Jetadmin to use the new database ............................................................. 5
Restart the HP Web Jetadmin Service .................................................................................... 7
Use a remote SQL Server database .......................................................................................... 7
Create a named or default instance ...................................................................................... 7
SQL Authentication .......................................................................................................... 8
Windows Authentication .................................................................................................. 8
Configure HP Web Jetadmin to use the new database ............................................................. 9
SQL Authentication .......................................................................................................... 9
Configuration file for remote SQL Server using a default instance and SQL Authentication ....... 10
Configuration file for remote SQL Server using a named instance and SQL Authentication ....... 11
Windows Authentication ................................................................................................ 13
Restart the HP Web Jetadmin service ................................................................................... 16
Migrate the HP Web Jetadmin database ................................................................................. 16
Method 1 ........................................................................................................................ 17
Method 2 ........................................................................................................................ 17
Database rights ................................................................................................................... 18
Troubleshooting ................................................................................................................... 19
Original database appears on startup ................................................................................. 19
Microsoft SQL Server is stopped ......................................................................................... 20
Change the port used for the remote connection ...................................................................... 24
SQL Server configuration changes ...................................................................................... 24
HP Web Jetadmin configuration changes ............................................................................. 25
Firewall settings ................................................................................................................ 25
Database failoverSQL mirroring .......................................................................................... 25
Performance settings ............................................................................................................ 27
Configure the HP Web Jetadmin backup for a remote database ................................................. 27
Summary ............................................................................................................................ 28
Appendix AInstall the license for the Database Connectivity Module for HP Web Jetadmin
10.3 SR3 and earlier ........................................................................................................... 29
License process ................................................................................................................ 29
Zobrazit stránku 0
1 2 3 4 5 6 ... 29 30

Shrnutí obsahu

Strany 1 - SQL SERVER

USING MICROSOFT® SQL SERVER with HP Web Jetadmin CONTENTS Overview ...

Strany 2 - INTRODUCTION

10 Configuration file for remote SQL Server using a default instance and SQL Authentication NOTE: As the value for the DefaultInstance is empty i

Strany 3 - Install SQL Server

11 Configuration file for remote SQL Server using a named instance and SQL Authentication For SQL Authen

Strany 4 - Create a named SQL instance

12 Connection to remote SQL Server with a default instance and SQL Authentication If you can ONLY connect to the remote database with SQL Managemen

Strany 5 - Configure HP Web Jetadmin to

13 Windows Authentication Because the HP Web Jetadmin service runs under a domain user account instead of Network Service for Windows Authentication,

Strany 6

14 Now that the necessary HP Web Jetadmin files reside under the correct Domain User Account instead of Network Service, edit the following file on W

Strany 7

15 These same files apply when using either a domain machine account or a domain user account. The account that the HPWJA Service runs under dictates

Strany 8

16 Restart the HP Web Jetadmin service Stop and restart the HP Web Jetadmin Service (HPWJA Service) under Administrative Tools, Services. Launch H

Strany 9

17 Method 1 One technique to migrate the existing HP Web Jetadmin database from the old instance to the new instance involves manually copying the da

Strany 10

18 Click OK in the Restore dialog, and watch the results. The restore runs for some time, depending on the amount of data in the backup file, but s

Strany 11

19 Therefore, the following minimal rights must be assigned:  db_datareader - Granted: SELECT  db_datawriter - Granted: DELETE, INSERT,

Strany 12

2 OVERVIEW HP Web Jetadmin 10.x automatically installs and uses a database that runs under Microsoft SQL Express. However, it might be more convenien

Strany 13

20  The file might be missing characters, such as the opening character, and HP Web Jetadmin does not recognize it as being a valid file.  The fi

Strany 14

21 C:\Windows\ServiceProfiles\NetworkService\AppData\Local\HP Inc\HPWebJetadmin\ WjaService\tracing 6 C:\Windows\ServiceProfiles\NetworkService\AppDa

Strany 15

22 The following example shows a case where a TCP/IP connection could not be made to the remote SQL Server: The following example shows a successf

Strany 16

23 The following example shows a successful connection to a local SQL Server. The following are common troubleshooting steps: 1. For remote SQL S

Strany 17 - Method 2

24 CHANGE THE PORT USED FOR THE REMOTE CONNECTION It is possible to configure HP Web Jetadmin to use a different port to connect to the remote SQL in

Strany 18 - DATABASE RIGHTS

25 7. In the warning dialog, confirm the service restart. 8. Restart the SQL Server (HPWJA) service. HP Web Jetadmin configuration changes 1. Crea

Strany 19 - TROUBLESHOOTING

26 Although HP Web Jetadmin supports database mirroring, the behavior of the HP Web Jetadmin service and connected clients might vary when a failove

Strany 20

27 PERFORMANCE SETTINGS The following properties can also be set in the DatabaseSettings.config.xml file:  DatabaseConnectionFactory.MinimumPoolSiz

Strany 21

28 file looks for the .dat file in this temporary directory and it is impossible to share out this temporary directory because it does not always exi

Strany 22

29 APPENDIX A—INSTALL THE LICENSE FOR THE DATABASE CONNECTIVITY MODULE FOR HP WEB JETADMIN 10.3 SR3 AND EARLIER A license for the Database Connectivi

Strany 23

3 MIGRATE THE HP WEB JETADMIN DATA If you want to point an existing installation of HP Web Jetadmin to use a remote SQL instance, consider whether th

Strany 24

7. Restart the HP Web Jetadmin service (HPWJA Service). The features of the Database Connectivity Module are now activated. © Copyright 2017 HP Dev

Strany 25 - Firewall settings

4 does not exist, SQL creates it. If the instance already exists, it must be in a serviceable state or SQL posts an error. The SQL Express installer

Strany 26

5 The SQL installer asks if Windows Authentication Mode or SQL Server Authentication Mode is to be used. Create a new database After the installer i

Strany 27 - REMOTE DATABASE

6 CAUTION It is imperative that you open the existing file and copy and paste the content as it is displayed here to maintain the user rights. The

Strany 28 - SUMMARY

7 Restart the HP Web Jetadmin Service Stop and restart the HP Web Jetadmin Service (HPWJA Service) under Administrative Tools, Services. If a passwor

Strany 29 - AND EARLIER

8 New Database, and then enter a database name. When using a remote SQL Server, you can use any database name that you want. However, it is quite com

Strany 30

9 the Database rights section) on the database. Remember, encrypted data, such as global credentials, are locked to the user/machine account and must

Komentáře k této Příručce

Žádné komentáře