Last week, I set up new SQL Server 2005 and service pack 2 installation in a Windows 2003 Server cluster environment. The services were configured to start using the domain service account, however, I’m not able to start the SQL Server service.
In Event Viewer, lots of error event is logged with the following description:
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = ffffffff; message = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
[sqsrvres] checkODBCConnectError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Login timeout expired
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = ffffffff; message = [Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
After spending few days to check SQL Server Configuration, Windows Registry, and also performs SQL re-installation. Still not able to resolve the problem.
Finally, found the solution here.
Open SQL Server Configuration Manager, click properties of SQL Server Browser, Advanced, make sure Active is set to Yes. If SQL Browser is running but is not active, the service would not serve correct pipe name and tcp port info for connection..
p/s: this post is for recording purpose only. need to pick-up better skill in configure and troubleshooting SQL 2005 server.