Saturday, January 05, 2013 10:17 AM
I have a PC that I installed Windows Server on, did all the maintenance.
We needed to install SQL Server so that we could run the accounting system we purchased.
The configuration was supposed be the server, a local client running Windows 7 and a remote client using VPN.
When we (the accounting software technical guy, since I am a novice with Server) attempted to install SQL Server we ran into the invalid edition issue.
In order to complete the accounting software install, we opted to install Express Advanced which seemed to install fine and completed the accounting installation. The local client is not having any issues in using the accounting package. BUT we are using the free SQL Server instead of the $800 Standard version.
I have several questions (and I am sure that I will think of others as I get educated):
1- What am I losing with Express Advanced compared to Standard?
2- Should we have ordered a different set of software?
3- How does one go about setting up a Domain Controller?
I would appreciate any and all help.
Saturday, January 05, 2013 4:26 PM
You have a lot of questions. Let me start with the basics,
1. SQL Server Express should do if this is a basic setup.
Main points: Express databases can have a max size of 10 GB (per database). You can have multiple databases in a single SQL instance though.
For DB-Administration, assuming you are using SQL 2012, you get the full blown Management Studio for free, if you install SP1.
You don't get high availability features like clustering, mirroring etc with Express.
You can find more details in this comparison chart
2. Can you be a little more specific?
3. You need a windows server license to begin with, looks like you have this already. Here are some article that provide step-by-step instructions with screenshot showing how to setup a domain controller (applies to Windows 2008/2008 R2)
Patience is a Virtue... So is "Delayed IO" :) Need SQL Server help? Visit my website: http://www.theSQLDude.com