Connection string: How to connect to Sql Server DB located on a different server RSS

• • Reply
  

  tcha143b

  Member

  2 Points

  10 Posts

  Connection string: How to connect to Sql Server DB located on a different server

  Dec 18, 2012 07:17 PM|LINK

  Hello all,

  How do I connect to a Sql Server DB located on a separate server that is part of the same network and what would the connection string look like in the web.config file?

  Thanks!

• • Reply
  

  limno

  All-Star

  117336 Points

  8003 Posts

  Moderator

  MVP

  Re: Connection string: How to connect to Sql Server DB located on a different server

  Dec 18, 2012 08:43 PM|LINK

  You should be able to find the connectionstring you want from this site:

  http://connectionstrings.com/

  Limno
  
  Format your SQL query with instant sql formatter:
  http://www.dpriver.com/pp/sqlformat.htm
  • Edited by tcha143b on Dec 18, 2012 09:13 PM
  • Marked as answer by limno on Dec 18, 2012 09:30 PM
• • Reply
  

  tcha143b

  Member

  2 Points

  10 Posts

  Re: Connection string: How to connect to Sql Server DB located on a different server

  Dec 18, 2012 09:13 PM|LINK

  Thank you.  I used this pattern that I found on that site for the correct connectionstring

  "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=myUsername;Password=myPassword;"

  http://www.connectionstrings.com/Articles/Show/define-sql-server-network-protocol