SQL Server Performance

Must Repeat Server Name in Connection String

Discussion in 'SQL Server Clustering' started by scoia, May 7, 2004.

  1. scoia New Member

    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
  2. bradmcgehee New Member

    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
  3. satya Moderator

  4. scoia New Member

    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

Share This Page