Solved

Install SQL Server 2005 Express on MS Small Business Server Standard

Posted on 2006-07-11
7
738 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
[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
  • 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 NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 

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

Technology Partners: 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!

Question has a verified solution.

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

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

726 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