How to build connect string to the second instance of SQL Server \ database

Discussion in 'ASP .Net' started by Krishna, Nov 21, 2003.

  1. Krishna

    Krishna Guest

    Hi

    Could some one tell me how to build connect string to the
    second instance of SQL Server \ database on the same
    machine using ASP.NET environment

    Is it

    "Data Source='server name\SQL server instance name',
    Initial Catalog='datanase name' Integrated
    Security='sspi" ?

    or some thing else

    Thanks
    Krishna
    Krishna, Nov 21, 2003
    #1
    1. Advertising

  2. Krishna,

    You've got it.

    SqlServerName\InstanceName

    --
    Sincerely,

    S. Justin Gengo, MCP
    Web Developer / Programmer

    Free code library at:
    www.aboutfortunate.com

    "Out of chaos comes order."
    Nietzche


    "Krishna" <> wrote in message
    news:0ae301c3b03f$e36bd8f0$...
    > Hi
    >
    > Could some one tell me how to build connect string to the
    > second instance of SQL Server \ database on the same
    > machine using ASP.NET environment
    >
    > Is it
    >
    > "Data Source='server name\SQL server instance name',
    > Initial Catalog='datanase name' Integrated
    > Security='sspi" ?
    >
    > or some thing else
    >
    > Thanks
    > Krishna
    S. Justin Gengo, Nov 21, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page