Windows 2008 SBS Premium: installation of SQL on second server

Does installation Windows 2008 SBS Premium will install SQL automatically? or there's an option "customize" to deselect SQL installation.

If SQL installation is automatic in server 1, can i use ADD/Remove programs to uninstall the software and install the server on the second server?

Thank you!
LVL 3
charles_lawrenceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shreedhar EtteCommented:
Hi,

"SBS 2008 Premium Edition does not require that you use two servers. With premium edition, you are granted two Windows Server 2008 Standard technologies licenses and a SQL Server 2008 Standard Edition for Small Business license, and you have the option of installing on a second server, but there is no requirement to do so. " extracted from the SBS 2008 FAQ "http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_25800407.html"

Refer this:
http://blogs.technet.com/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx

I hope this helps,
Shree
0
Shreedhar EtteCommented:
Also refer this:
Windows Small Business Server 2008 SQL Server Installation
http://www.brighthub.com/computing/windows-platform/articles/24594.aspx
0
charles_lawrenceAuthor Commented:
HI shreedhar,

It seems that SQL 2005 is preinstalled in SBS 2008 Premium. Please correct me if iam wrong, does this SQL 2005 is use for SharePoint Services purposes? If it is, can we then install  SQL 2008 on the second server with 2008 server standard?

Thank you!

0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Shreedhar EtteCommented:
Hi,

You cannot remove SQL2005 from SBS 2008 Premium. It is required for some of the core functionality. It is needed for Monitoring & Reporting, Company Web and I believe WUS.

From SBS 2008FAQ: http://www.microsoft.com/sbs/en/us/faq.aspx

Q.  SBS 2008 Premium Edition comes with SQL Server 2008 Standard Edition for Small Business. Can I exercise my downgrade rights and run an earlier version of SQL Server?

A.  
As a rule, the components of the SBS solution cannot be separated. However, Microsoft recognizes that due to line-of-business application compatibility issues moving from one version to the next, some businesses may need to run the previous version of Microsoft SQL Server 2005, so we will ship SQL Server 2005 Standard (both 32- and 64-bit platforms) in addition to the SQL Server 2008 Standard for Small Business in every retail and OEM System Builder package of SBS 2008 Premium and allow the direct Original Equipment Manufacturer (OEM) channel to provide customers SQL Server 2005 (both 32-bit and 64-bit platforms) on request until June 30, 2010.

Note that once Microsoft stops shipping both versions of SQL Server, customers are restricted from downgrading just the SQL Server component. Microsoft downgrade rights specify that if a user downgrades, the user must downgrade all the component parts of the server software. Customers who received SQL Server 2005 Standard with their SBS 2008 can continue to use it after the shipping period ends, but they may not use both SQL Server 2005 Standard and SQL Server 2008 Standard for Small Business simultaneously. Customers can, however, move between SQL Server 2005 Standard Edition and SQL Server 2008 Standard Edition per their needs.

Hope this helps,
Shree
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
charles_lawrenceAuthor Commented:
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.