Online Demo -- MS Access/SQL Server       print manager video

 

Print Job Manager uses MS Access by default. You can also use SQL Server (including the free edition of SQL Server).  If you don't have a SQL server in your environment, you can download the free edition of SQL Server from Microsoft website (searching keyword "SQL Server Express" in Google). If you install Print Job Manager on multiple servers, each server can use it's own local database or connect to a central SQL database.

 

Step 1. In Print Job Manager Preferences --> Print Jobs, select "SQL Server", then click 'Configure' button.

Step 2. Enter the SQL server information, then click 'Create DB' button.  Click 'Connect' if it doesn't show "Connection OK".

SQL DB Name  This is the name of the database that stores data of printers, print jobs, users, client codes...

SQL Server Name  This is the name of the remote or local SQL server. If you install the free edition of SQL server (e.g., SQL Server 2005 Express Edition), the SQL Server Name is serverName\sqlexpress or .\sqlexpress. If you install the standard edition of SQL server (e.g., SQL Server 2005 Standard Edition), the SQL Server Name is  serverName or .\

SQL DB Directory  This is required when creating the database. Please check the location of database files (*.mdf) on your local or remote SQL server. The default locations of the database on different version of SQL Server are listed below. It should start with the disk driver (e.g C:\, D:\, E:\...)

    SQL 2016              

    C:\Program Files\Microsoft SQL Server\MSSQL13.<instance_name>\MSSQL\Data\

    C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\Data\

    SQL 2014              

    C:\Program Files\Microsoft SQL Server\MSSQL12.<instance_name>\MSSQL\Data\

     C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\

    SQL 2012              

    C:\Program Files\Microsoft SQL Server\MSSQL11.<instance_name>\MSSQL\Data\

     C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Data\

SQL 2008              

C:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Data\

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data\

SQL 2005              

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

SQL 2000              

C:\Program Files\Microsoft SQL Server\MSSQL\Data\

You can get the DB directory by right-click your SQL server name in Object Explorer, select Properties --> General --> Root Directory and append "\Data" to the root directory.

or

SELECT name, physical_name AS current_file_location
FROM
sys.master_files

Step 3. Click Print Job Manager menu Print Jobs -> Import (Access -> SQL Server) to import the print job data from MS Access to SQL database.

Common Issues:

1. SQL Server does not exist/access denied/connection failed/SQL Network Interfaces error: 26 - Error Locating Server/Instance Specified

1) Make sure your server name is correct.

2) Make sure your instance name (For example, SQLEXPRESS) is correct, and there is such an instance on your target machine. 3) Make sure the server machine is reachable, e.g., DNS can be resolved correctly, you are able to ping the server. If not, try server IP.

4) Make sure SQL Browser service is running on the server.

5) If the firewall is enabled on the server, you need to put sqlservr.exe (For example, C:\Program Files\Microsoft SQL Server\MSSQL.10\ MSSQL\Binn\sqlservr.exe) and sqlbrowser.exe (For example, C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe or C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe) and/or UDP port 1434 into exception.

6) For the remote SQL server, the "Allow remote connections to this server" need to be selected, and TCP/IP protocols need to be enabled.

7) Place port number right next to SQL server name for example Test\sqlexpress,1433

2. Directory lookup for the file failed, or timeout expired

Please check the location of database files (*.mdf) on your local or remote SQL server. It should start with the disk driver (e.g C:\, D:\, E:\...)

3. 429 ActiveX component can't create the object

If you install Print Job Manager on 64-bit Windows OS, please see the question 4.

The sqldmo.dll may not be registered correctly. Click Start --> Run --> regsvr32 sqldmo.dll.

4. I have tried everything, but I still can't create a database successfully. What else can I try?

1) Download the empty database file from https://www.printeradmin.com/download/PrintSaver.zip. This database file includes all the tables and fields information.

2) Extract PrintSaver.zip that includes two files: PrintSaver.mdf and PrintSaver_log.LDF.

3) Copy PrintSaver.mdf and PrintSaver_log.LDF to the default SQL Data directory on the Server that hosting SQL Server. Please see above definition about SQL DB Directory.

4) Open Manager (or SQL Server Management Studio).

5) Right-click on Databases, choose All Tasks, Attach Database

6) Type in the path to PrintSaver.mdf file

7) Click on OK.

8) In Print Job Manager --> Preferences --> Print Jobs --> SQL Server --> Configure, click Connect.

5. The document name includes the question mark. How do I fix it?

1. On the computer that has Print Job Manager installed, go to control panel -> regional settings, set your language (it may require to restart the computer), then send a print job to test.

2. If step 1 doesn't work, rename C:\Program Files\PrinterAdmin\Print Job Manager\config\unic0 to unic, then send a print job to test.

 

Download Print Management Software