Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Another SQL instance using SBS 2011 Premium Add-On?

Posted on 2012-12-20
4
Medium Priority
?
694 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
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 UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

571 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