Why is it the Web host services that use Windows Server 2003 are so limited with the MSSql databases?  I have sites on Linux/apache/PHP/MySql that allow me to have as many MySql db as I want.

I'm trying to move some of my sites into ASP, but this appears to be an obstacle.  I'm not complaining.  I have a reseller account and on one web host server I've got 9 sites.  I have anywhere from 3 to 6 MySql databases associated with each of the sites.  I found one Window Server 2003 host that would allow up to 5 MSSql databases total.  This would accomodate only one of the eight sites.   

My understanding is MSFT now puts the MSSql out for free.  I think that is what I DL along with the Express web developer tools. I realize the MSSql was a paid for tool previously.

Maybe I'm looking in the wrong places for web hosting provider.

I thought to put up my own webserver, but to be real honest I would think there are web hosts that should be more accomodating.   My IP is ATT and from what I've read getting static IP, etc. is very expensive.  Then of course the biggest issue of all is my DSL connection.  I'm thinking it is just not going to give anywhere near the performance I need (T1).  If I had more sites the $400+ for T1 might make sense, or going with RackSpace.  I cannot even justify a RackSpace server with the sites I have up now.   

I'm just discussing my issues so that maybe someone with similar experience could suggest a few things or links to so things that might get the door open a little wider for me to get more involved with ASP.

The biggest obstacle has been to find accomodating web hosting at reasonable cost for number of databases associated with my sites.

What kind of bandwidth do you need.  I can host your sites for you and I will charge for MSQL db based on disk space in 100MB blocks

$15/month for 100MB of MSSQL per site I dont care how many db you put in that 100mb block. This is actually on the Rackspace backbone so you know its up. 

let me know if you are interested usually I get $40/month for each domain (I can handle DNS or You can dont matter) but if you are doing 8 I am sure we could talk. ;)

myfirstnameATcyberjetx.com

Be sure to mark posts as a solution if they are.

Why do you need so many databases for one site?  There are a number of hosting companies that offer ASP.NET 2.0 and SQL Server 2005 for a very reasonable fee. Gate.com offers this for $9.95 a month, and each additional site is offered at a discount. That's just one, there are several other companies offering similar deals.

I'm spoiled I guess.  I have a reseller account and I'm hosting 9 (unlimited)  sites for 19.95 per month (all sites included)with unlimited MySql db.

Also, I have 10,000 MB of webspace and 100 GB bandwidth.  Just about everything else is unlimited., email accounts, etc. 

It comes with Fantastico installer, cpanel, and whm.

The sites have been up over 2-1/2 months and the reliability is 100% as far as I can tell.

Of course, the host doesn't provide Windows hosting.  Only Linux/Unix - Apache - Php - MySql.

-----------------------

I prefer to do all my installs of different software within my sites with separate databases, especially when if I'm using 3rd party software). If security vulnerability is made known I patch the respective software immediately. 

I noticed a CMS for ASP, which probably comes with one MSSql database.  I think that would be a nightmare to maintain especially with a forums or other software that allowed input of data from users.  The full featured forums I currently use would probably not be possible within an ASP community site with a forums using one MSSql database for security reasons. 

Don't get me wrong here.  I'm not bashing anyone here.   I bought a Visual Studio.NET - Enterprise Architect edition in 2002 that cost over $1,700 US for it.  I've never used it for building sites.  The new Express stuff kinda triggered new interest for me.  I doubt my old Visual Studio is viable now, but I can probably do some upgrading. 

The OpenSource server side environment has some benefits at least it appears for web hosting.   The support isn't too bad on some software, but it still takes a lot of patience and frequently doing some coding to get full use out of it.

Well, you are posting about Windows Server 2003 on an ASP.NET forum where virtually everyone here that reads your post is using ASP.NET on windows, usually with SQL Server 2000 or 2005, so I'm not sure I get the connection.

Hi,

My advice is to get one Virtual Private Server on reasonable price - from $40 to $120 per month. Then you could get SQL server installed and as many databases as you wish...

You could check here - http://www.HostingASPNet.net

Regards

The connection is--->

I would like to migrate my sites to ASP.  I'm developing proprietary applications using MSFT dev tools, not php,etc. 

The bit about so few MSSQL db provided by hosts is what has me in a quandry.  Like I said, " I have nine sites now on php with anywhere from 3 to 6 MySQL db".

I currently own many MSFT development software.  As far as web development... they are doorstops.  I don't want to buy a new Visual Studio, or Windows 2005-8 server unless I can get more juice outta what I've got.   Web development was a very small part of what I did 4 years ago, but has become more of an issue as clients want more integration (proprietary apps to the web). 

I did try couple years back to get more involved with the ASP, but I got so busy I just blew it off.  The Opensource environment was competent enough and the IIS was getting so much bad publicity it was easy to talk clients into OpenSource websites.

------------------------------

IS it common practice to build ASP apps with just one MSSQL db? 

  Is maintenance of the MSSQL that much better or easily maintained than say MySQL?

------------------------------

I'm just wondering how people can manage put up sites with just 1 MSSQL db?.

Is it common practice to just put all ASP sites on a single hosting arrangement, vs  a reseller account with a large number of sites?

You know I wouldn't ask what may seem like stupid questions if the MSFT sites information was more search friendly.  I hope I don't put anyone off with my questions... I'm just trying to weed through this to get to a place I can comfortably use the ASP.

This is all a matter of design.  Certainly you would want to segrigate your sites data for instance if client1 is www.BB&T.com and client2 is www.bobspuppies.com you would certainly want to keep the data seperate.  Also you get a certain amount of due diligence.  Additionaly you recieve the beni of individual backup and restores. 

My opinion is seperate clients = seperate databases.  Others will certainly chime in.

HTH,

Be sure to mark posts as a solution if they are.