Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Course Of The Month
5 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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 today
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 today
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
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| SQL - Aging Report - Display Months with no data | 8 | 43 | |
| Suppress if value zero or NULL in crystal report | 2 | 43 | |
| VMware PVSCSI SQL Server 2016 AlwaysOn | 2 | 37 | |
| Redirected folders moving to new domain | 5 | 19 |
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install. In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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 Month5 days, 3 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.