Another SQL instance using SBS 2011 Premium Add-On?

Trish Benningfield
Trish Benningfield used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical Architect - HA/Compute/Storage
Commented:
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

Author

Commented:
Thanks!  I don't have a DVD drive, but I get the point. :-)
Philip ElderTechnical Architect - HA/Compute/Storage

Commented:
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

Author

Commented:
MountISO :-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial