January 6, 2010 at 10:58 pm
Hi,
I'm installing SQL Server 2005 x64 developer edition in newly build Cluster. We have node1 & node2
I have logged in Node1 and started installing SQL Server 2005. In the middle of the installation, I'm getting the below popup
All resources did not come online and therefore you need to manually set the cluster restart
I clicked OK and the installation is completed successfully. But the SQL Service is not coming online in Cluster Administrator on node1. But the SQL Service is able to come online if I move the SQL group to node2.
After analyzing the error log & event viewer, I have noticed the below error:
[sqsrvres] ODBC sqldriverconnect failed
I used to have working SQL Server instances on these nodes. But I tried to install SQL Server 2008 and that installation failed. Then I had uninstalled all the instances and started installing again but this time I'm getting this strange error.
Please advice me how to resolve this issue.
thanks
January 7, 2010 at 11:11 am
please see the errors from the event viewer:
1st error:
Event Type:Error
Event Source:MSSQL$INS1
Event Category:(3)
Event ID:19019
Date:1/7/2010
Time:9:52:14 AM
User:N/A
Computer:ABC
Description:
[sqsrvres] ODBC sqldriverconnect failed
2nd error:
Event Type:Error
Event Source:MSSQL$INS1
Event Category:(3)
Event ID:19019
Date:1/7/2010
Time:9:52:14 AM
User:N/A
Computer:ABC
Description:
[sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The above error occured continuously & then the below error
3rd error:
Event Type:Error
Event Source:MSSQL$INS1
Event Category:(3)
Event ID:19019
Date:1/7/2010
Time:9:52:14 AM
User:N/A
Computer:ABC
Description:
[sqsrvres] OnlineThread: Error connecting to SQL Server.
and then I can see the below information message and the error
Event Type:Information
Event Source:MSSQL$INS1
Event Category:(2)
Event ID:26038
Date:1/7/2010
Time:9:52:36 AM
User:N/A
Computer:ABCVS1
Description:
The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098. Administrator should deregister this SPN manually to avoid client authentication errors.
Event Type:Error
Event Source:MSSQL$INS1
Event Category:(3)
Event ID:19019
Date:1/7/2010
Time:9:52:36 AM
User:N/A
Computer:ABC
Description:
[sqsrvres] CheckServiceAlive: Service is dead
Event Type:Error
Event Source:MSSQL$INS1
Event Category:(3)
Event ID:19019
Date:1/7/2010
Time:9:52:36 AM
User:N/A
Computer:ABC
Description:
[sqsrvres] OnlineThread: service stopped while waiting for QP.
Please help me out!!!
January 11, 2010 at 7:00 am
I'm installing SQL Server 2005 x64 developer edition in newly build Cluster
You then say that previously you had other instances of SQL installed, you then tried a SQL 2008 install, then you uninstalled all your SQL instances. You are NOT using a newly built cluster, you are using a server that has been badly messed up.
There may be a problem with the SQL install that can be worked round to get your install complete, but my recommendation is to re-install Windows and start your install with a newly built Cluster. This would mean that any problems you get are due to your current install, and not to what may have happened in the past.
BTW, it is worthwhile to check that the AD computer entries for your nodes and cluster, and the DNS entries for your nodes and cluster, are removed before you start rebuilding. Also make sure that all shared disk resources and whatever quorum resource you use are cleared out before you start rebuilding.
If you do all of this and still have a problem, then please post again.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply