Solved

Can I install SQL Standard (non SBS version) on to my SBS 2008 Standard Server?

Posted on 2011-02-24
3
230 Views
Last Modified: 2012-05-11
Hi,

As the title suggests - I have an existing SBS 2008 Standard box, and would like to add SQL Standard 2008 to this.

I know I can install the "SQL 2008 for Small Business Server" if I upgrade to Premium SBS, but I dont want to do that as I already have the SQL 2008 Standard software and CALs.

I also know that I cannot purchase SBS 2008 Premium with 5 CALs and then use the the SQL 2008 Standard CALs I own to cover licencing.

Does anyone know the answer?

Thanks,

Ben
0
Comment
Question by:TS_BenB
[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
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 250 total points
ID: 34972126
0
 
LVL 2

Assisted Solution

by:TS_BenB
TS_BenB earned 0 total points
ID: 34978502
Hi Ashilo,

This guide seems to refer to SQL 2005 not 2008 - nevertheless thanks for the input.

I emailed Microsoft in the end and this was the response:

---------------------------------------------------------------------------------------------------------------------

Hi Ben,
 
We have consulted the Technical Advisory team and they have confirmed that you can install SQL 2008 Standard on SBS domain, however it is not recommended because of security purposes as SBS is a domain controller.
 
You cannot use your SQL 2008 CALs on Small Business Server (SBS) 2008 Premium, you will require SBS 2008 Premium CALs for every User or Device trying to access the SBS Server 2008 Premium.
However in case of SBS 2008 Standard you can use your current SQL 2008 CALs if you install SQL 2008 Standard on SBS 2008 Standard Server.
 
The referance link that you have mentioned refers to Microsoft SQL Server 2008 R2 Standard for Small Business because it comes as a component of SBS Premium.
 
Hope this information is of help to you.
 
Kind regards,
Ruta Banavalikar
Customer Service Professional
Microsoft Customer Services  
---------------------------------------------------------------------------------------------------------------------
0
 
LVL 2

Author Closing Comment

by:TS_BenB
ID: 35015357
I answered the question.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

739 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