How to connect to Sql Express by ip address?

microsoft.public.dotnet.framework.adonet

3 Apr 2006 10:03 AM

MagicMax

Good day!

Is anybody know how to connect to remote Sql Express by IP address from
C# program (main question is how to build connection string)?

I have to use Ip address instead of server name. I make some tests and
when I use server name then I can connect, when (in connection string)
I replace server name by server's Ip address I catch exception.

Tcp/ip is enabled...

Thank you!

Best regards, Max

3 Apr 2006 1:34 PM

Cor Ligthert [MVP]

MagicMax,

You just use the IP address instead of the ServerName.

That should work.

Cor