Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to install another SQL instance on SBS 2008

Posted on 2014-03-11
6
Medium Priority
?
477 Views
Last Modified: 2014-03-12
Where can I find the install files for SQL on SBS 2008 so that I can install a new instance?
0
Comment
Question by:ClintonK
  • 3
  • 2
6 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39922847
You should have a disc titled "Microsoft SQL Server 2008 Standard Edition for Small Business", or else have the downloadable media somewhere on your network.
0
 

Author Comment

by:ClintonK
ID: 39922923
Unfortunately not. I only have two discs; one labelled "Operating System" and the other "Additional Software" and neither appear to contain SQL. Disc 1 must contain it somewhere as it is installed and working after the clean build. I am 100% confident that there are no missing discs because I have more than one set of SBS 2008 discs and they are all the same.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39923389
if you have SBS 2008 Premium, the SQL installation should be on the disks, otherwise you don't have Premium edition, and are not entitled to use sql server ...
also, afaik, you may install a additional sql server ONLY for a migration of the SBS, otherwise you need to install a regular SQL Server on a dedicated member server, but on on the SBS server itself.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 

Author Comment

by:ClintonK
ID: 39923558
But SBS2008 comes with SQL Express doesn't it? I agree that I won't have the full SQL version that is supplied with Premium but I wasn't expecting that. It's an additional SQL instance on the same SBS Server that I can use with AVG.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1500 total points
ID: 39923583
>But SBS2008 comes with SQL Express doesn't it?
not that I know of.
but you can download sql express from MS site and install it, best on a member server, not on the SBS server itself.
0
 

Author Closing Comment

by:ClintonK
ID: 39923729
Downloaded a copy of SQL Express. I'd got it stuck in my head that the install files were included in the SBS build but that only seems to be true for SBS2011 and not SBS2008.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
Organisation is organized in a pattern to flow the day to day business, every application and system is interdepended on each other and when very important “Exchange Server downtime” happened.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

602 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