Solved

Another SQL instance using SBS 2011 Premium Add-On?

Posted on 2012-12-20
4
679 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 38

Accepted Solution

by:
Philip Elder earned 500 total points
Comment Utility
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
Comment Utility
Thanks!  I don't have a DVD drive, but I get the point. :-)
0
 
LVL 38

Expert Comment

by:Philip Elder
Comment Utility
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
Comment Utility
MountISO :-)
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now