eDocs Setup / Installation
Post date: Jan 28, 2013 3:53:30 PM
Some eDoc configurations use the SQL server FILESTREAM option. This option is required when there are remote users that need to add or have access to the stored documents.
Below are some links for system administrators that layout the best practices for implementing FILESTREAM on the server.
http://msdn.microsoft.com/en-us/library/dd206979(v=sql.105).aspx
http://blog.sqlauthority.com/2012/07/06/sql-server-ntfs-file-system-performance-for-sql-server/
Server Commands for the filesystem
FSUTIL BEHAVIOR SET DISABLE8DOT3 1
FSUTIL BEHAVIOR SET DISABLELASTACCESS 1
Also All Anti-Virus scanning needs to be disabled for the FILESTREAM Folders
Workstation Configuration
When using the FILESTREAM option for eDocs it is required that all workstations be upgraded to the latest SQL Server Drivers. SQL driver versions can be verified on the workstation by looking at the drivers tab on the Control Panel --> Administrator Tools --> Data Sources (ODBC) applet. Either SQL Server Native Client 10.0 or 11.0 have been tested and will work with eDocs. If the workstation does not have these driver updates they can be found under the Compensate application folder under dll_source\sql. When installing the drivers be sure to use the correct version (x86 or x64) for the operating system installed.
Failure to have the updated drivers installed will cause the application on the workstation to fail to connect to the SQL server.