4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)
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 2005 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.
• Use the cacls.exe utility to give the local Administrators group full control and
to give Everyone read-only permissions. In the following command, %1 is the
mounted folder.
cacls %1 /t /m /p Administrators:F Everyone:R
For example:
cacls c:\psfs\psd1p1 /t /m /p Administrators:F Everyone:R
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 23