Connecting to SQL Server that is on the internet

[Khaledinho]

Hi

I am writting an application that needs to connect to a sql server that is on the internet.

http://www.yourmobileismymobile.com

This server has the sql server and sql server port is open and i know the (username and password),the question is how do i set the connection string

And i also know the database name in sql server

 

Any ideas

Thanks in advance

[DannyT]

http://www.connectionstrings.com

[bri189a]

If your using Visual Studio Profession you can use the server explorer to add a new connection. You'll be prompted for the information. After the connection is created, drop and drag the connection onto your form/page.

 

That's the overly simple way to do it.