I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.
I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.
I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.
Errorlog shows the following...
Error: 26054, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources
is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x5.
2010-05-05 15:23:41.98 Server Error: 17182, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.
2010-05-05 15:23:41.98 Server Error: 17182, Severity: 16
View Complete Post