SQL Server Performance Forum – Threads Archive

Must Repeat Server Name in Connection String

Our SQL Server 2000 was recently clustered. Ever since the server was clustered, we must repeat the server name in our connection strings and DSN’s as follows: Assume the server name is IntraSQL01. It must now be referred to as IntraSQL01IntraSQL01. However if I ping for IntraSQL01IntraSQL01 it will fail. I can ping for the name IntraSQL01 and get a response. The other odd thing is that we recently implemented a small Access application using an ADO connection to this server. The connection string repeated the server name, and we had no problem when running the application from our workstations. But when we ran the application from the user’s workstation, we couldn’t get a connection. We had to change the first reference of the server name to the server’s IP address (111.11.111.11IntraSQL01) in order to connect. This was a strictly trial and error approach and we still don’t know why this should have worked. I wasn’t involved in the clustering effort and really don’t know the exact technical architecture involved. I am interested in getting some answers from a purely developer standpoint. If anyone has any insight into this, I would sincerely appreciate any information on what would cause this and/or any resolution to this issue. Thank you. Sue

It sounds like you created a new instance of SQL Server for the cluster instead of using the default instance. You can learn more about how to use instances in the BOL. If you don’t want to do this, you uninstall SQL Server and then reinstall it as a default instance. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

True BOL is the starting point and the following KBAs:
http://www.microsoft.com/technet/tr…t/prodtechnol/sql/deploy/confeat/failclus.asp
http://support.microsoft.com/defaul…rver-performance.com/clustering_resources.asp -0valuable. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thank you Brad for your reply. That makes sense in that when we sometimes have to refer to the first reference to the server by IP address and then reference the SQL Server instance on the server. I’m going to do some reading in the BOL and also look at the KB articles that Satya recommended. Sue

]]>