cancel
Showing results for 
Search instead for 
Did you mean: 
otalado
New Contributor

Connecting to SQL SERVER works with SSMS ...

I can connect with SSMS to remote, using SQL authentication. But  I trying connect from my C# app using the exactly same server address and login credentials as with SSMS  it times out after a while because host failed to respond.

when I modify the  server connection string replacing only the server address with a server address of SQL serve deployed on my LAN things are working OK.

So that means:

a) the firewall cannot be a problem or it will not be working with the SSMS.

b) the connection string is (probably) not a problem, because as soon as I use a LAN address in it everything is 

   fine.

That leaves me out of the ideas what else should I try. So any fresh ideas will be greatly welcome