Solved

Another SQL instance using SBS 2011 Premium Add-On?

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

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
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.

919 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

21 Experts available now in Live!

Get 1:1 Help Now