SQL Server connection string to a remote server

I have a remote SQL Server Express (2008 R2) with an IP: xx.xxx.xxx.xx and an instance name: myInstance.

I have been trying to connect to a DB (myDB) as user (dbUser) and with password (myPass).

I have tried various string combinations but none works. I am sure I got it wrong because the server is ok, I can ping the IP Address, SQL Serve开发者_C百科r runs on port 1433, which is open. I have also enabled browser service and remote connection on the server.

Please someone give me the correct string...

How to: Configure Express to accept remote connections

There could be many reasons for this, however, you didn't post any useful details such as error messages or what exception was thrown (if any).

Check that Windows Firewall allows access on port 1433 - this is the most likely reason for the failure, since you are using an IP address and not the name of the instance.

I suggest looking at http://connectionstrings.com to check your connection string.