[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

Install SQL Server 2005 Express on MS Small Business Server Standard

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
dijon316
Asked:
dijon316
  • 4
  • 3
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
 
dijon316Author Commented:
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
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
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!

 
dijon316Author Commented:
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
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
It's the older version, which is MSDE 2000.

Jeff
TechSoEasy
0
 
dijon316Author Commented:
OK...Thanks!

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

John
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now