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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-24 : 08:47:55
|
| Joseph writes "Hi all,I'm fairly new to SQL Server and I want to turn my spare home PC in to a web host for my SQL Server 2000 databases. I tried to use IIS, but couldn't get it. I also tried VCN and couldn't get it. Basically, I want to be my own web host. What steps do I need to take to do this?" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-01-24 : 18:00:19
|
| Are you talking about web sites that are accessible by the public? Then one of the main things you will have to do is spend the money to get a static IP address from your ISP. Without a static IP, nobody will be able to find your web server because every time you reset your connection to the Internet you may get a different IP address. All domain names are ultimately mapped to an IP address.Then you'd best start doing some reading on how to configure IIS. It's not difficult to get it up and running, but can be quite a project to keep it (or ANY hosting software) secure from attack. And if you don't understand mapping of domain names to DNS servers, etc. you'll need to read some there, too. I suggest you contact your ISP and ask if they have some documents on how to get started.Once you have that all under control, then you need to determine whether you are going to use NT Authentication to your SQL Server or SQL Security. NT Authentication is trickier but more secure.Are you sure you don't just want to use a third-party hosting service like WebHost4Life?---------------------------------------------------------------------------------Infoneering: Information Technology solutions engineered to professional standards. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-24 : 18:16:19
|
Never miss an opportunity Mark  I love it!My advice to Joeseph, and I mean this constructively, "if you have to ask, you probably shouldn't". Play with this stuff behind your firewall a bunch, learn about securing a web server. There are too many internet facing boxes without the proper security that just become hosts for worms and trojans. It's a scary world out there.Damian |
|
|
|
|
|
|
|
|
Being your own Web Host (SQL Server 2000)