SQL2008 / IIS7 / ASP.NET Application
Printed From: Web Wiz Forums
Category: Web Wiz Hosting Services Forums
Forum Name: Web Wiz Hosting Services Pre-Sales Questions
Forum Description: Got questions about Web Wiz Hosting Services? We've got answers and solutions!
URL: https://forums.webwiz.net/forum_posts.asp?TID=26772
Printed Date: 28 March 2026 at 9:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL2008 / IIS7 / ASP.NET Application
Posted By: skelly
Subject: SQL2008 / IIS7 / ASP.NET Application
Date Posted: 02 January 2009 at 7:33pm
Hope you all had a great Christmas and New Years, and hopefully 2009 will be a good one...
In
my case that probably equates to looking at how to save money for my
business. So I have a MS SQL 2005 and IIS ASP.NET application which is
currently being hosted for testing using MSDN subscription
licenses. Essentially the architecture looks like:
Customers (web browsers) <-> FireWall <-> [IIS7 Guest VM] <- vlan -> [SQL2005 Guest VM]
_user session<--------- http & https only --> web application <-odbc only ->
To
license this and put it into production at co-location is going to be expensive due,
mainly, to the SQL licensing requirements, right? i.e. that SQL2005 VM
is going to need per processor or server license for £2500+
So, can I replicate my architecture using web wiz services without putting the http://asp.net/IIS7 - ASP.NET/IIS7 application on the same machine as the SQL server?
I need to make sure our application will work properly on SQL 2008 but I think it will. Any recommendations if I DID put the http://asp.net/IIS7 - ASP.NET/IIS7 application on the SQL2008 box too?
Security is also a significant issue as the database will contain some financial information (which was why I had them separated in the test environment).
With interest,
sk
|
Replies:
Posted By: skelly
Date Posted: 04 January 2009 at 11:03am
|
Obviously another solution could be simply use SQL Express 2008 until we meet it's limits. Hmmm.
|
Posted By: WebWiz-Bruce
Date Posted: 05 January 2009 at 9:24am
Our servers are setup with web and database server suppurate from each other, mainly for performance reasons.
In your case though for higher security I would place the IIS 7 and SQL Server on the same server. This way you can use a trusted connection to the SQL Server and not have TCP/IP enabled giving much higher security and you can lock down SQL Server to a local trusted connection only.
The limits of SQL Server 2008 Express are very high and I doubt you would ever hit these limits in a web environment. There is also the newer SQL Server 2008 Web Edition which is available at an extremely modest cost.
If you wanted to discus the security setup of our servers then I would suggest that you http://www.webwiz.net/contact - contact us as a public forum is not the ideal place to be discussing security aspects of our network.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: skelly
Date Posted: 08 January 2009 at 10:41am
Thank you very much for the reply. I will investigate SQL Server 2008 Web Edition and come back via the contact link when I know what I'm going to do.
Cheers,
sk
|
|