none
URI address to a SQL Server 2008 cluster RRS feed

  • Question

  • Hi

     

    I'm trying to connect to our SQL Server cluster with an existing solution using WCF LOB SQL adapter but I'm unsecure what the URI should be.

    The URI I'm using to my local SQL Server is mssql://.//ConfigDb? but in production we are using two stand-alone machines with SQL Server (SQL1 and SQL2).

    I've tried with mssql://SQL1%5cSQL2//ConfigDb? but it is illegal URI (%5C stands for backslash "\" URL encoded).

     

    Kind regards

    A.H.

    Wednesday, September 29, 2010 11:51 AM

Answers

  • The URI convention is mssql://sqlDefaultName/instanceName/DBName?

    The FQDN for sqlDefaultName should also work so this would be like sqlClusterName.domain.com etc. I have used this adapter in a clustered configuration before.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by Homer22 Thursday, September 30, 2010 7:24 AM
    Wednesday, September 29, 2010 5:37 PM
    Moderator

All replies

  • The URI convention is mssql://sqlDefaultName/instanceName/DBName?

    The FQDN for sqlDefaultName should also work so this would be like sqlClusterName.domain.com etc. I have used this adapter in a clustered configuration before.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by Homer22 Thursday, September 30, 2010 7:24 AM
    Wednesday, September 29, 2010 5:37 PM
    Moderator
  • Thx, Ben. I worked.

    I tried mssql://sqlDefaultName/instanceName//DBName? but of course I had a double slash in front of database name.

    Thursday, September 30, 2010 7:23 AM