Connecting to an external Sql Server ?...

[Cybertof]

Hello,

Is it possible to connect to an external (out of the lan) sql server
through c# code ?
I would like to connect directly my c# application to an external sql
server. (i'm at home on my laptop, the app is running on it, the
sqlserver is at the office, and visible through NAT configuration with a
special port).

If yes,
- how to 'see' it in the Server Explorer.
- how to make the connection with ado.net objects

If no,
- what type of connection sql server does accept ?
- any hints to do the connection from a c# app ?


Regards,
Cybertof.

 

[Greg Ewing [MVP]]

Cybertof, yes, it is definitely possible. You just have to set the correct
connection string. Here's a site that I've found helpful when trying to
remember the format for connection strings.

http://www.connectionstrings.com