How to connect to Sql Express by ip address?

M

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
 
C

Cor Ligthert [MVP]

MagicMax,

You just use the IP address instead of the ServerName.

That should work.

Cor
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting to Sql Server using an IP address 6
Unable To Connect To Internet - IP Address Conflict 6
Resolving an IP address from a SQL Server Instance Name 6
Oracle connection string with IP address 2
Connect to remote SQL server ... 7
Connect to SQL Server 2005 on a server in a workgroup 1
Resolving DataSource if IP has multiple SQL Server instances 4
Connecting to SQL Server 2005 on a server in a workgroup 8

Top