Does anyone know of a Web hosting provider with full SQL Server capabilities? I have used one specific one that I like but I can't publish my own SQL Server database without using their proprietary tool. I have copied a sample wedsite from ASP.net - the one with the "Classified Ad" website and it uses the real SQL Server and so I need a host that can support it if I write my own site using SQL Server.

thanks for any leads!

Eugene1968:

Does anyone know of a Web hosting provider with full SQL Server capabilities? I have used one specific one that I like but I can't publish my own SQL Server database without using their proprietary tool. I have copied a sample wedsite from ASP.net - the one with the "Classified Ad" website and it uses the real SQL Server and so I need a host that can support it if I write my own site using SQL Server.

thanks for any leads!

Looks like the shared web hosting server cannot be supported the full sql server control, my website is hosted by webhost4life.org and more Dedicated web hosting features can be found at here.

Good luck

Hello,

If you are looking for Shared ASP.NET hosting solution then check DiscountASP. They will meet your requirements and have great support.

Regards

Thanks.... I signed up on that site now.... how do I move my website from my current hosting site to my new hosting site? Should I delete my account with my old host after I move it to the new one? When I use VWD2008 to edit my site how do I make it point to the new site (I guess requiring my new ID & password?)?

hi eugene,

There are several steps that you need to do to ensure a smooth transition to a new host:

1. Please ask for a temporary URL from your new host. This temo URL is truly important so that you can preview your site on their server, even before you are doing the DNS changes
2. Please upload all your files to the required folder.
3. Please restore your database on their server
4. Once everything is done, please use the temp URL given to test your site. If things work out according to your requirements, you can then initiate the DNS changes
5. Once the DNS has resolved to your new host, you can safely terminate the service and say goodbye to your old host.

If you have any problems or concerns in migrating your site, you can always seek help from ASPHostCentral.  I have been using their service for a couple of months and those are the advises I got from them. Well, I managed to migrate everything smoothly and without any downtime

All the best :)

Did you mean a web hosting provider that supported for all SQL Server, like MS SQL 2000, MS SQL2005, MS SQL2008 and MS SQL Express? Just take a look here!