Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Visual Web Developers using SQL Server Express

Posted on 2007-12-02
2
Medium Priority
?
173 Views
Last Modified: 2013-11-07
Hi,

I am planning on developing a small to medium size e-commerce web site for a customer. I will be using visual web developer to deploy the application. Is this possible? If not, are there any pluggins that would let me deploy (.dll and .exe) and package the application? Also I am using Sql Server express edition. I understand that it is free for redistribution as long as one registers the copy. I would like to now if there are any limitations for what I am trying to do using visual web developer and Sql Server express Ed. I think that Sql Server express is enough for what I am doing and it should not be to bad to upgrade as the business grow.



How many processors and memory bandwidth would Sql Server Express support? Are dual core processors considered one cpu or two cpu's? Any inputs or thoughts will be greatly appreciated. Thanks.
0
Comment
Question by:vielkacarolina1239
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
surajguptha earned 2000 total points
ID: 20391733
If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express.

About multi core support of SQL server express. More details are available here
http://support.microsoft.com/kb/914278

You might want to check the scalability and performance section on this link http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

Also check out the common issues section for more details about SQL server limitations
http://msdn2.microsoft.com/en-us/library/bb264564.aspx#sqlexpuser_topic8

You should be able to deploy the web application with Visual Web Developper with ease. As far as i know there are no limitations you might have deploying web apps using the web edition.
0
 

Author Closing Comment

by:vielkacarolina1239
ID: 31412183
Thanks for the links.
0

Featured Post

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question