The "Storage options" page allows you set up SQL server as storage for Print Logger data. By default Print Logger stores it's data using embedded data storage engine (Microsoft SQL server 2005 Express).
SQL server version - displays full SQL server version information.
Use Wizard - starting SQL Wizard, it allows you to configure the Print Logger and SQL server to work together. SQL Wizard is a user friendly step-by-step configuration program. If you're setting up the first Print Logger installation with this SQL server, please use the wizard. Second and others installation can be configured without wizard.
SQL server name - SQL server host name, IP address or NetBios computer name. You can select server from the "SQL servers found" list. If list is empty, try to click "Refresh" button.
Database name - the name of the database for Print Logger data. If you're using SQL Wizard, the database will created for you automatically an your existing data will be imported into SQL database. If you're configured not first installation with this SQL server, the database name should be equal to existing Print Logger database.
Database configuration tables prefix - prefix for tables with configuration data. Configuration data is private for each print server. For each print server Print Logger creates and maintain the private set of configuration data tables.
Read/write user name - SQL server user login/account with full access to Print Logger database. Used for adding and removing database records, configuration information. By default "pldbuser".
Read/write user password - the password for read/write user account.
Administrator user name - username for user with administrative privileges on external SQL server, required when you're want to change pldbuser's password on external SQL server. Not required for embedded data storage engine. Required only once per operation, not stored.
Administrator user password - password for user with administrative privileges on external SQL server, required when you're want to change pldbuser's password on external SQL server. Not required for embedded data storage engine. Required only once per operation, not stored.
Update user's password - press to change the user's password. The Print Logger will be restarted.
Also you can change password for administrative user (sa). This action available for embedded data storage engine only.
Update admin's password - press to change the administrator's password. The Print Logger will be restarted.
When you're using external SQL server, this page looks like:
Read/write user name - SQL server user login/account with full access to Print Logger database. Used for adding and removing database records, configuration information. By default "pldbuser".
Read/write user password - the password for read/write user account.
Administrator user name - username for user with administrative privileges on external SQL server, required when you're want to change pldbuser's password on external SQL server. Not required for embedded data storage engine. Required only once per operation, not stored.
Administrator user password - password for user with administrative privileges on external SQL server, required when you're want to change pldbuser's password on external SQL server. Not required for embedded data storage engine. Required only once per operation, not stored.
Update user's password - press to change the user's password. The Print Logger will be restarted.
NOTE: Please do not change Print Logger related user names and passwords directly on SQL server. You should change user names and passwords only from SQL Wizard of from Administrative Console.
NOTE: There is no way to restore your lost password. You can reset your settings for embedded SQL engine running SQLWizard.exe -R. This will reset user names and passwords to default values.
Default logins and passwords for embedded SQL storage engine (Microsoft SQL Server 2005 Express) are created during the installation process:
Read/write user
name :
"pldbuser"
Read/write user
password : "pldbuserSqlPL5SApwd"
Administrator
user name : "sa"
Administrator
user password : "saExpressSqlPL5pwd"
You should change all default passwords to your own to avoid unauthorized access to your data!
NOTE: For hard loaded print servers (more then 15...20 printers and with print jobs flow higher then 60 print jobs per second per print queue) we strongly don't recommend you using embedded SQL storage engine (Microsoft SQL Server 2005 Express). Please, use the external SQL server, installed on other computer in your network. As a last resort you can use the Microsoft SQL Server 2005 Express, but is mandatory installed on other computer.