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. Advertisements

  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. Advertisements

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.
Similar Threads
  1. =?Utf-8?B?UmV6YQ==?=
    Replies:
    3
    Views:
    18,438
    Carlos Barini
    Jun 7, 2004
  2. jamezw
    Replies:
    2
    Views:
    3,870
    jamezw
    Jun 17, 2005
  3. =?Utf-8?B?Q2FpbGlu?=

    Unable to connect to the Sql server database

    =?Utf-8?B?Q2FpbGlu?=, Sep 9, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    2,912
    Patrick.O.Ige
    Sep 12, 2005
  4. marialokiya
    Replies:
    4
    Views:
    7,901
    marialokiya
    Oct 27, 2005
  5. Peter Afonin
    Replies:
    2
    Views:
    958
    Peter Afonin
    Oct 8, 2006
  6. Wesley Chen
    Replies:
    0
    Views:
    368
    Wesley Chen
    Apr 7, 2009
  7. Wesley Chen
    Replies:
    9
    Views:
    494
    Sean O'Halpin
    Apr 14, 2009
  8. Replies:
    2
    Views:
    558
Loading...