Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Another SQL instance using SBS 2011 Premium Add-On?

Posted on 2012-12-20
4
Medium Priority
?
693 Views
Last Modified: 2012-12-20
Hi!

I have a server running SBS 2011 with the premium add-on.  I need to create a separate SQL instance on my server for an app I'm installing.

Is this in agreement with the license terms (I'm having trouble decoding the licensing terms), and how would I do this?  I did an "add/remove" on SQL 2008 64 bit, selected Add, and it prompts me for the media.  I don't have a DVD on this server, but have copied the entire DVD contents to a directory on the drive. Pointing the browse window to the media results in "d:\ is not a valid installation folder."  Directing this browse window to the actual DVD on a share off another server results in the same message.

And a side question-- I have two entries in my start menu-- One says "Microsoft SQL Server
2008" with only "SQL Server Installation Center (64-bit)" under it, and another that says "Microsoft SQL Server 2008 R2" with all the tools.  Why?

I would greatly appreciate all assistance and direction!!  TIA!
0
Comment
Question by:pbenningfield
  • 2
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
Philip Elder earned 2000 total points
ID: 38711211
Drop the SQL media in and run the setup.exe.

When setup starts, choose NEW INSTANCE NAME and give it a name during the setup process.

You can use the configuration manager to set static ports or make sure the SQL service is given access programmatically in the Windows Firewall.

It's easy. ;)

Philip
0
 
LVL 2

Author Comment

by:pbenningfield
ID: 38711495
Thanks!  I don't have a DVD drive, but I get the point. :-)
0
 
LVL 40

Expert Comment

by:Philip Elder
ID: 38711557
If you are looking for an excellent, and free, utility to mount ISOs then:
Virtual CloneDrive by Slysoft.
http://www.slysoft.com/en/virtual-clonedrive.html

Philip
0
 
LVL 2

Author Comment

by:pbenningfield
ID: 38711697
MountISO :-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

886 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