Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL server 2008 placed on a virtual server

Author  Topic 

sven2
Yak Posting Veteran

57 Posts

Posted - 2010-03-22 : 04:42:53
Hello,

when I install SQL server 2008 on a virtual server and I want to access this SQL using the internet what is the procedure to do this and what kind of port should I open regarding the firewall.

Thanks in advance,
Sven.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-22 : 05:14:56
The default port of sql server is 1433 and this is the one you need to open up in your firewalls and as far as I know there is no difference in the procedures for a physical server than for a virtual server. However, when you're exposing the server to the internet you should really know what you're doing and make sure that the server and the methods of connecting to it are sufficiently hardened. Exposing a database to the internet isn't exactly recommended...

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein
Go to Top of Page
   

- Advertisement -