What are the challenges you face when working across database platforms? Take the survey
Options

Trial: Service hangs on clustered named instance

kellinokellino Posts: 6
edited September 24, 2007 5:37AM in SQL Backup Previous Versions
Hi. I had a frustrating experience trying to get the demo to run on the cluster. After quite a bit of digging, I finally discovered that the -i <instance> option was added to the cluster resource, but not to the service on the server. Once I added the -i <instance> the service would actually start.

Now I just can't connect to it.

We are using a non-standard TCP port. I didn't come across any documentation that explained how to deal with this. I also tried changing the connection protocol to Shared Memory and Named Pipes (making sure they were enabled on the SQL server) and that didn't help either.

How does one connect to a SQL server?

Thanks!

Comments

  • Options
    What a blond moment. It's always something simple.

    I used the browser to select the server to connect to. This used the name of the local server, rather than the virtual server on the cluster.

    I manually typed in the virtual server on the cluster, bypassing the browse, and it works fine now.
  • Options
    Very pleased you managed to sort it out. I think the fact you found a solution yourself shows a high level of intellegence worthy of being blonde.
    Helen Joyce
    SQL Backup Project Manager
    Red Gate Software
Sign In or Register to comment.