View Complete Post
I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody
suggest any solutions.
TITLE: Microsoft SQL Server 2005 Setup
Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
Source File Name: sqlca\nlregca.cpp
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