
Configure database security for Microsoft SQL Server
2012
If you use Microsoft SQL Server 2012 or SQL Server 2012 Express locally or remotely, you must
configure the database to allow access by the HP Imaging and Printing Security Center service.
The HP Imaging and Printing Security Center service runs as NT AUTHORITY/NETWORK
SERVICE. When the service accesses the HP Imaging and Printing Security Center database, it must
have the proper credentials to access the Microsoft SQL Server 2012 or SQL Server 2012 Express
database. Use the Microsoft SQL Server Management Studio to add the service name to the logins
for this database instance.
NOTE: Microsoft SQL Server Management Studio is a free tool available from Microsoft. You can
obtain the tool for Microsoft SQL Server 2012 or SQL Server Express 2012 from the Microsoft
download site.
1. Log on to the computer where the Microsoft SQL Server instance is installed.
2. To start the Microsoft SQL Server Management Studio, click Start, and then select All
Programs. Select Microsoft SQL Server, and then click SQL Server Management Studio.
3. Select the database instance where the HP Imaging and Printing Security Center database is
installed.
4. Expand the Security folder.
5. Right-click Logins and then select New Login.
6. Enter the account name of NT AUTHORITY\NETWORK SERVICE in the Login name field.
7. From the Select a page panel, click User Mapping.
8. From the Users mapped to this login table, select the check box for HPIPSC.
9. From the Database role membership for: HPIPSC panel, select the check box for db_owner.
10. Click OK to save your changes and then exit.
11. Restart the HP Imaging and Printing Security Center service to complete the permission change.
ENWW Configure database security for Microsoft SQL Server 2012 17
Commenti su questo manuale