[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Install SQL Server 2005 Express on MS Small Business Server Standard

Posted on 2006-07-11
7
Medium Priority
?
747 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 1000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

656 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