Accessing SQL Server remotely

Dear All,

I have created a database on my SQL server, I want to access my database through C# .NET project . By just installing the software on the client side I would be able to access my SQL server remotely.

On internet can i Do that?

Plz let me know any solution for this.

Regards,

Anil Dhiman

DId I understand you right that you want to connect through the internet to your SQL Server ? Then you have to redirect/forward port 1433 of the connected internet gateway to the SQL Server that you have within your infrastructure.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Anil,

Also keep in mind that your server is a named instance, then it may not necessarily be using port 1433. I this case, you may need to make sure that SQL Browser is started and UDP port 1434 is opened on the firewall in addition to the instance port. These KB articles may be of some assistance for configuring the firewall:

http://support.microsoft.com/kb/287932/en-us
http://support.microsoft.com/kb/841249/en-us

Alternatively, the client's connection string can explicitly contain the connection port in which case, you don't need SQL Browser.

Il-Sung./