Solved

Install SQL Server 2005 Express on MS Small Business Server Standard

Posted on 2006-07-11
7
726 Views
Last Modified: 2012-05-05
Would there be any problem installing SQL Server 2005 Express on MS Small Business Server Standard? I work for a SMALL business with limited funds, so getting the full blown SQL Server would be out of the question. Right now, I am currently using an Access back end on a peer-to-peer network, so I felt it would be a step up.

Thanks
0
Comment
Question by:dijon316
  • 4
  • 3
7 Comments
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17087758
Are you aware that getting "Full Blown SQL Server" for SBS just means upgrading to SBS Premium?  The SKU for this upgrade it T75-00754 and a quick check shows that is about $750.00 these days:  http://froogle.google.com/froogle?q=T75-00754&lmode=online&scoring=p

Your current CALs would work just fine, so the only other cost might be a bit of additional RAM on the server.  I generally recommend running with 2 GB of RAM if you have SBS Premium.

Otherwise, SBS actually already has what is essentially SQL Server 2005 Express, since that is the newer version of MSDE.  So installing SQL Express on SBS is no problem.

I'm confused though about your statement that you are currently running Access back end on a p-2-p network... is this attached to the SBS somehow?

Jeff
TechSoEasy
0
 

Author Comment

by:dijon316
ID: 17089831
We just got a Dell PowerEdge 830 with SBS. We are currently running our Access back-end on just a workstation in a peer-to-peer network at this time until I can get the real server going. I will then use SQL Server as the back-end. Since our needs are low, I thought it best just to use the Express version of SQL Server for now.

Thanks
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 250 total points
ID: 17094059
Setting up SBS really requires that you set up your entire network and join all the workstations.  You should get http://sbsurl.com/best as a good starting guide for this.

Since you JUST bought the SBS, you qualify for a free upgrade to SBS 2003 R2 when it is released in a few weeks.  

If you got the Premium version of SBS, R2 has SQL Server 2005 for Workgroups... http://www.microsoft.com/windowsserver2003/sbs/r2/default.mspx

Otherwise, you can upgrade the MSDE instances to SQL Server 2005 Express
but make sure to follow the instructions to do so:

http://uksbsguy.com/blogs/doverton/archive/2006/07/04/Upgrading_SQL_2000_and_MSDE_2000_to_SQL_2005___in_SBS_R2___this_could_be_the_sharepoint_or_WSUS_database.aspx

Jeff
TechSoEasy
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:dijon316
ID: 17094179
I took your advice and ordered the SBS Best Practices book. I hope that one is more in depth on setup than the current one I am using (MS Small Business Server 2003 Unleashed). It seems things were not explained well enough. At least for a beginner like myself.

I am a little confused. Are you saying that SBS 2003 aleady has SQL Server 2005 Express already installed? Or is it an older version?

Thanks for your help!
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17094690
It's the older version, which is MSDE 2000.

Jeff
TechSoEasy
0
 

Author Comment

by:dijon316
ID: 17096044
OK...Thanks!

Looks like I need to upgrade from MSDE 2000 to SQL Server 2003 Express before proceeding.

John
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17096133
Do you mean SQL Server 2005 Express?  It's not necessarily a "need" as opposed to a want, I would think.  But SQL Server 2005 Express has a bunch more features than it's predecessor.

Jeff
TechSoEasy
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 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