March 13, 2007 at 10:05 pm
HI,
Due to our web application is hosted at Web Hosting company and it is
required to access to our SQL server which is hosted internally, just wondering what is the best
solution/practise to achieve this as open the SQL server port to public might
raise the possibility of the information leaking (hacking).
Normally we are using the ASP connection string to for the database connection, as below:
ConnString="DRIVER={SQL Server};SERVER=yourServername, 1433;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"
Just wonder normally how do we achieve this?
pls advise....
March 16, 2007 at 8:00 am
This was removed by the editor as SPAM
March 16, 2007 at 11:04 am
I see your problem. Opening your SQL Server to the outside world can be very dangerous. You must make sure you lock it down as best you can at the firewall level by perhaps putting a rule that only allows a connection from the IP address of the webserver. I would definately change the ports as everyone knows SQL Server listens on 1433, just make sure all of your applications are aware the the port change.
Marvin Dillard
Senior Consultant
Claraview Inc
March 16, 2007 at 11:06 am
Also, don't forget about the VPN option between your sql server and the web hosting site. That keeps it more secure.
Marvin Dillard
Senior Consultant
Claraview Inc
March 17, 2007 at 6:18 pm
In addition to what was said:
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy