O&K Software - The five questions posted most recently: O&K Software http://www.prnwatch.com/faq <![CDATA[How to store printed documents images on the hard drive instead SQL database.]]> To reduce database space usage you can use server hard drive to store printed documents images.

Requirements:

You should use MS SQL Server 2008 any edition, include freeware Express - http://go.microsoft.com/fwlink/?linkid=130396

If you are using MS SQL Server 2005 Express you should upgrade it to MS SQL Server 2008.

How to: Upgrade to SQL Server 2008 (Setup)

Please Note: O&K Print Watch Setup creates the  named instance SQL Server 2005 - PRNWATCH. You must upgrade this instance SQL Server 2005.

Install:


USE PRNWATCH
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE
GO
ALTER DATABASE PRNWATCH ADD FILEGROUP PrnWatchFileStreamGroup CONTAINS FILESTREAM
GO
ALTER DATABASE PRNWATCH ADD FILE ( NAME = 'PrnWatchFileStream', FILENAME = 'C:\Data\PrnWatchFileStreamGroup' ) TO FILEGROUP PrnWatchFileStreamGroup
GO
ALTER TABLE PRNDATA ADD FileStreamID uniqueidentifier ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWSEQUENTIALID()
GO
ALTER TABLE PRNDATA ADD NewJobData varbinary(max) filestream
GO
UPDATE PRNDATA SET NewJobData=JobData
GO
ALTER TABLE PRNDATA DROP COLUMN JobData
GO
EXEC sp_rename 'PRNDATA.NewJobData','JobData','COLUMN'
GO
PRNWATCH - O&K Print Watch database name on your SQL Server.
C:\Data\PrnWatchFileStreamGroup - the file path to store printed documents images.

  •   Run O&K Print Watch Service.
]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=3&id=65&artlang=en Thu, 24 Sep 2009 14:50:00 GMT <![CDATA[Как хранить образы напечатанных документов на диске, вместо базы данных.]]> Для уменьшения используемого места в базе данных SQL возможно хранение образов напечатанных документов на диске сервера.

Требования:

Использование MS SQL Server 2008, любой редакции, включая бесплатный Express - http://go.microsoft.com/fwlink/?linkid=130396

Если у вас используется MS SQL Server 2005 Express, его необходимо обновить до MS SQL Server 2008.

How to: Upgrade to SQL Server 2008 (Setup)

ВАЖНО: Программа установки O&K Print Watch создает именованный экземпляр SQL Server 2005 - PRNWATCH. Вы должны обновить именно этот экземпляр SQL Server 2005.

Порядок установки:


USE PRNWATCH
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE
GO
ALTER DATABASE PRNWATCH ADD FILEGROUP PrnWatchFileStreamGroup CONTAINS FILESTREAM
GO
ALTER DATABASE PRNWATCH ADD FILE ( NAME = 'PrnWatchFileStream', FILENAME = 'C:\Data\PrnWatchFileStreamGroup' ) TO FILEGROUP PrnWatchFileStreamGroup
GO
ALTER TABLE PRNDATA ADD FileStreamID uniqueidentifier ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWSEQUENTIALID()
GO
ALTER TABLE PRNDATA ADD NewJobData varbinary(max) filestream
GO
UPDATE PRNDATA SET NewJobData=JobData
GO
ALTER TABLE PRNDATA DROP COLUMN JobData
GO
EXEC sp_rename 'PRNDATA.NewJobData','JobData','COLUMN'
GO
PRNWATCH - имя базы данных O&K Print Watch на вашем SQL Server.
C:\Data\PrnWatchFileStreamGroup - путь по которому будут храниться образы распечатанных документов.

  •   Запустите O&K Print Watch Service.
]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=7&id=64&artlang=ru Thu, 24 Sep 2009 14:38:00 GMT <![CDATA[Cannot connect to remote O&K Print Watch server - Access is denied.]]> You need set the access rights to DCOM server O&K Print Watch Service for users who should connect remotely to server using Control Program.

  1. On your print-server where O&K Print Watch Service is running, run Start->Run->dcomcnfg.
  2. Open Console Root->Component Service->Computer->Your server->Properties->COM Security.
  3. Edit Access Permissions и Launch and Activation Permissions. You should change the both settings "Edit Limits..." and "Edit Default...".
  4. Open Root->Component Service->Computer->Your server->DCOM Config->PW4Srv->Properties->Security.
  5. Edit "Launch and Activation Permissions", "Access Permissions", "Configuration Permissions".
  6. Restart O&K Print Watch Service.

Is you are using O&K Print Watch in workgroup instead domain, you should set the users authentification - In my workgroup O&K Print Watch shows remote users as Guest.

]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=4&id=51&artlang=en Fri, 05 Sep 2008 09:33:00 GMT <![CDATA[In my workgroup O&K Print Watch shows remote users as Guest.]]> If you are using O&K Print Watch in a simple workgroup, you should do it as follow:

  1. On computer where O&K Print Watch Service is running, create the local user with the same name and password as remote user. 
  2. Run Control Panel->Administrative Tools->Local Security Police.
  3. Open Security Settings->Local Policies->Security Options.
  4. Set the value "Network access: Sharing and security model for local accounts" to "Classic - local users authenticate as themselves".
]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=4&id=50&artlang=en Fri, 05 Sep 2008 09:31:00 GMT <![CDATA[Authentication Client server connection error - "Access denied".]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=8&id=49&artlang=ru. ]]> http://www.prnwatch.com/faq/index.php?action=artikel&cat=32&id=60&artlang=en Mon, 03 Dec 2007 15:50:00 GMT