Solved

Install SQL Server 2005 Express on MS Small Business Server Standard

Posted on 2006-07-11
7
731 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 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