Sunday, February 19, 2012

Deploy local SQL Server on internet?

Hello,

Sorry for posting this here, I couldn't find an accurate forum name to post this in.

We are using Windows SBS Server 2003 with SQL Server installed. We have a static IP. I am wondering if we can host our database. I am specifically interested in having outside websites access our database. Is there anything special I need to do to make this happen? I am pretty clueless about this.

Thanks!I dont think this question can be answered here. You could try other database app development related developer forums.|||

Hi Yaron,

IMHO its simple when you have experienced hosting database driven Intranet site, the difference is just to BOUND dedicated IP address in the IIS's Directory. As you have SQL server installed on your SBS now just copy the website files in folder and map those using IIS. map your Static IP to that IIS Directory(where your website file is located)

Open DNS manager, create a forward and reverse lookup zone , create a pointer record, bound your static ip address. Reboot your server and that's it!!!!

If still you find problem hosting it, refer article here

http://www.webmasterstop.com/122.html

http://support.microsoft.com/kb/317604

http://support.microsoft.com/kb/247931

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc02.mspx

HTH

Hemantgiri S. Goswami

No comments:

Post a Comment