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.
|