|
Step 1. In PrinterAdmin 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 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 2008
C:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\
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
Common Issues:
1. SQL Server
does not exist or access denied or connection failed
a. This may happen
if you use the remote SQL server. On the SQL server, the "Allow remote
connections to this server" needs to be selected, and TCP/IP protocols needs to
be enabled
b. 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 object
If you install PrinterAdmin 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 database successfully. What else can I
try?
1) Download the
empty database file from
http://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 Enterprise 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 PrinterAdmin 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 PrinterAdmin 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\PrinterAdmin Print Job Manager\config\unic0 to unic, then send a print job to test.
|
