HP Web Jetadmin Software Manuel d'utilisateur

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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