HP Web Jetadmin Software User Manual download pdf

UPGRADE MICROSOFT

SQL SERVER

EXPRESS FOR HP WEB JETADMIN

CONTENTS

Overview ................................................................................................................................ 2

Versions of SQL Server Express that HP Web Jetadmin uses (after a default installation) ................... 2

Determine which version of SQL Server Express is installed ........................................................... 2

Method 1—Add/Remove Programs ........................................................................................ 2

Method 2—Error logs ............................................................................................................ 2

Method 3—SQL Server Management Studio ............................................................................ 3

Other methods ...................................................................................................................... 3

Why HP recommends upgrading to SQL Server 2012 SP2 Express ................................................ 3

Upgrade from SQL Server 2008 Express to SQL Server 2012 SP2 Express ..................................... 3

Back up the data and HP Web Jetadmin settings ...................................................................... 4

Method A (Upgrade) ............................................................................................................. 4

Method B (Migration) ............................................................................................................ 5

Method C (Migration) ............................................................................................................ 6

1 2 3 4 5 6 7 8

UPGRADE MICROSOFT® SQL SERVER EXPRESS FOR HP WEB JETADMIN CONTENTS Overview ...

2 OVERVIEW By default HP Web Jetadmin uses Microsoft® SQL Server 2008 Express or SQL Server 2012 SP2 Express. This white paper explains when SQL Serv

3 Method 3—SQL Server Management Studio If SQL Server Management Studio is installed, the product version for SQL Server Express is displayed after c

4 Back up the data and HP Web Jetadmin settings 1. Stop the HP Web Jetadmin service. 2. Open a command prompt with administrative rights, and go to

5 8. To increase the size of the database, open a command prompt with administrative rights, and go to the following directory: C:\Program Files\HP

6 b. On the Select User or Group screen, enter network service, click Check Names, and then click OK. c. On the Server Configuration screen, cli

Page 7

7 d. On the Select Features screen, select Database Engine Services and SQL Client Connectivity SDK (if not used by other instances), and then click

Page 8

HP Web Jetadmin Software User Manual