Connecting to a remote web server and SQL database using Visual Studio

Question

I need to set up asp.net and SQL server database hosting with a 3rd party web hosting service. To simplify the deployment process, I'd like to be able to develop the web site within a Visual Studio environment in exactly the same way as VS allows local machine or domain web sites to be edited. I'd also like to be able to connect to the 3rd party SQL database directly - possibly using SQL server linked servers, or asp.net connection objects.

Is it possible to do this? What services do 3rd party hosts need to provide in order to allow integration with Visual Studio and SQL Server?

AccuWebHosting.Com · Accepted Answer · 2012-05-24 14:50:39Z

1

A good windows hosting company will by default offer you publishing using Web Deploy method and Web Matrix.Their web servers are designed to handle direct connectivity with Visual Studio and SQL Database Server.

I am using AccuWebHosting services and they're offering seamless connectivity using Web Deploy and Web Matrix.

answered May 24, 2012 at 14:50

AccuWebHosting.Com

1,1591 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aristos · Accepted Answer · 2012-05-23 07:47:58Z

1

In order to connect with the other machine that have the sql server, the server must left opened two posts, the 1433, and 1434.

With this port you can connect remotely.

But this is also left them open to all the other and maybe the attack begin, so you have two chooses here, ether to change the default port, ether use one SSH tunneling connection. With the tunneling connection the server run a tunneling server, you connect using a tunneling client, and you map this ports to the tunneling both on client and on server, and then you connect to the server via secure connection and with out open the sql ports. I hope that all this make sense.

answered May 23, 2012 at 7:47

Aristos

66.7k16 gold badges117 silver badges154 bronze badges

2 Comments

Trent Over a year ago

So I need a web host that allows users to connect via the SQL Server ports, or one that supports SSH tunneling connections?

Aristos Over a year ago

@Trent better is the support of the tunneling.

Collectives™ on Stack Overflow

Connecting to a remote web server and SQL database using Visual Studio

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related