SQL Server Express configuration

This topic is locked

SQL Server Express configuration	6/2/2007 8:27:47 PM
ASPRunnerPro General questions
R raginbull author I am thinking about deploying a SQL Server Express configuration and having ASPRunner be the main user interface. My general questions are Do I need to have two databases (one for IIS) or does this directly write back to the main database? Has this software been proven to be a solid interface? What limitations would I have Thanks,


S	stealthwifi 6/4/2007
	Jason, I am no expert at SQL or at AspRunner, but I am using both to run all the sites at my company. Currently we are running SQL Express 2005 on a Windows 2k3 server (so IIS) and AspRunner 4.0 There does not need to be a seprate DB for IIS and your AspRunner site as far as I know (you may be setting up a diffrent type of site than us not sure...) AspRunner does directly interface with the main DB that you set it up too. We run a seprate DB for each individual site as to keep maintance and database structure clean and organized. SQL Express in my opinnion (and I am sure many can argue eathier way) is a much better choice for running your DB on a production server than MS Access or even MySQL due to the shere power MS SQL has over it. AspRunner connects and interacts with SQL Express wonderfully and we have had no connection problums and only seen increased productivity and speed since switching from MS Access. Hope that helps. Cheers, Stealth-