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.
Solved
Another SQL instance using SBS 2011 Premium Add-On?
Posted on 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!
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!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
Active 2 days ago
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
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
Active 2 days ago
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
Virtual CloneDrive by Slysoft.
http://www.slysoft.com/en/virtual-clonedrive.html
Philip
Featured Post
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 ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses
Course of the Month9 days, 17 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.