SQL Server Performance

SQL Server cant start after changing cluster name

Discussion in 'SQL Server Clustering' started by holyterror_1, Jan 19, 2004.

  1. holyterror_1 New Member


    I'm running SQL server on ms cluster, with the name dssql on two Compaq servers.
    Due to server upgrade, the database was moved to a couple of new Dell servers, clustered environment also. We had to keep the virtual name, so we renamed the Compaq cluster to dssql2 and dssql was given to the new Dell cluster. The name dssql has a different ip address on the Dell cluster.

    The Dell cluster works fine, but now the SQL server service on the Compaq cluster (SQL network name is dssql2, no change in ip address) couldn't start.

    Can anyone help?


  2. Luis Martin Moderator

    What is the error (event viewer).?

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. holyterror_1 New Member

    it says checkODBCConnectError: sqlstate = 01000, native error = 2; message = [microsoft][odbc sql server driver][named pipes]connection open(Connect())

    and another one error below that is odbc sqldriverconnect failed

  4. Luis Martin Moderator

Share This Page