Greetings!
With all the new Microsoft products coming out, we want to help ensure that your installations run smoothly. Also make sure to regularly monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks.
________________________________________________________________________ |
 SQL Server 2008 Installation: Sometimes installing a clustered instance of SQL Server 2008 on a Windows Server 2008 Cluster can be difficult to accomplish. Establishing proper permissions for the service accounts and knowing how to perform a slipstream installation can make your installation a success. Make sure that the Windows OS has installed properly (meaning that there were no errors during install) and that the cluster has access to all necessary resources and can fail over quickly. After verifying the Cluster, make sure to disable the User Account Control (UAC) and grant the following permissions to the SQL Server service accounts:
o Act as part of the operating system
o Adjust memory quotas for a process
o Allow log on locally
o Allow log on through Terminal Services
o Bypass traverse checking
o Impersonate a client after authentication
o Lock pages in memory
o Log on as a batch job
o Log on as a service
o Perform Volume Maintenance Tasks
o Manage auditing and security log
o Replace a process level token
__________________________________________________________________ |
