Votes - 0, Average rating: 0
(
)
)
|
Other manuals for this model:
manual abstract
USING MICROSOFT® SQL SERVER
with HP Web Jetadmin
CONTENTS
Overview ................................................................................................................................ 2
Introduction ............................................................................................................................. 2
First Time Installation of Web Jetadmin ....................................................................................... 2
Migrating Web Jetadmin Data ................................................................................................... 3
Using Local SQL Server Database .............................................................................................. 3
Installing SQL Server ............................................................................................................. 3
Creating a Named SQL Instance ............................................................................................ 4
Creating a New Database ..................................................................................................... 4
Configuring HP Web Jetadmin to Use the New Database .......................................................... 5
Restart Web Jetadmin Service ................................................................................................. 6
Using Remote SQL Server Database ........................................................................................... 7
Named or default instance ..................................................................................................... 7
SQL Authentication ............................................................................................................ 7
Windows Authentication ..................................................................................................... 7
Configuring HP Web Jetadmin to Use the New Database .......................................................... 8
SQL Authentication ............................................................................................................ 8
Windows Authentication ................................................................................................... 10
Restart Web Jetadmin Service ............................................................................................... 12
Migrating the HP Web Jetadmin Database ................................................................................ 12
Method 1 ........................................................................................................................... 13
Method 2 ........................................................................................................................... 13
Troubleshooting ...................................................................................................................... 14
Original Database Appears Upon Startup .............................................................................. 14
Microsoft SQL Server Claiming Stopped ................................................................................ 15
Changing the Port Used for Remote Connection ......................................................................... 18
SQL Server Configuration Changes ....................................................................................... 18
Web Jetadmin Configuration Changes .................................................................................. 19
Firewall Settings .................................................................................................................. 19
Database failover—SQL mirroring ............................................................................................ 19
Performance settings ............................................................................................................... 21
Backup of HP Web Jetadmin configured for a remote database ................................................... 21
Summary ............................................................................................................................... 22
Appendix A—Installing the database connectivity module license ................................................ 23
License process ................................................................................................................... 23
...