4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

File streaming implications
Although the SQL Filestream can be enabled during an installation of SQL 2008,
the actual BLOB cannot be put on an HP PolyServe clustered filesystem (PSFS).
Account provisioning
In SQL Server 2005, the Windows Builtin\Administrator local group was automatically
given administrative permissions for the SQL instance. This is no longer the case with
SQL Server 2008. Instead, when you install an instance, you will need to specify the
users and/or groups that should have administrative permissions (sysadmin) for the
instance.
SQL instance cannot be virtualized if the directories of the SQL Instance are not
in the same path
SQL Instance directories such as Data, Log, Backup, and so on should be in the same
path. For example, if you are installing an instance TEST, the path for the above
directories should be:
C:\Program Files\Microsoft SQL Server\MSSQL10.TEST\MSSQL\Log
C:\Program Files\Microsoft SQL Server\MSSQL10.TEST\MSSQL\Backup
C:\Program Files\Microsoft SQL Server\MSSQL10.TEST\MSSQL\DATA
The SQL Instance cannot be virtualized if these directories have different paths.
Set permissions on existing PSFS filesystems
If you will be installing a SQL 2008 instance on a mountpoint for a PSFS filesystem
created under Matrix Server 3.2 or earlier, the installation may fail if the file
permissions are not set appropriately. You can use any of the following methods to
set the permissions if necessary.
• Mount the filesystem as a drive letter (for example, s:\). In Windows Explorer,
open the Properties for the volume and select the Security tab. Then set the per-
missions to Full Control for Administrators/users.
• Mount the filesystem as a mountpoint such as c:\psfs\psd15p1. In Windows
Explorer, open the Properties for the folder, go to the “Mounted Volume” properties
(this is not the same as the folder security), and set the permission for Administrat-
ors/users to Full Control.
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 19