4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

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.
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 permissions to Full Control for Administrat-
ors/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 Administrators/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
NOTE:
If you are installing a retail version of SQL Server, be sure to enter the product key provided with
your software. The product key is required for all retail versions of SQL Server. If you do not specify
a product key, the installer will add a sample product key (“PID=123456789ABCD”) to the
template.ini file. However, MSDN versions of SQL Server already have the product keys
embedded in the installation files.
SQL Server 2008 references
The following Microsoft documentation provides more information about SQL Server 2008.
• SQL Server 2008 Books Online:
http://msdn.microsoft.com/en-us/library/ms130214.aspx
• How to install SQL Server:
http://msdn.microsoft.com/en-us/library/ms143219.aspx
• Features supported by Editions of SQL Server 2008:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
• SQL Filestream:
http://msdn.microsoft.com/en-us/library/bb933993.aspx
• Microsoft .NET Framework 3.5:
Install SQL Server instances16