?
Solved

Foundations Server

Posted on 2016-09-09
7
Medium Priority
?
77 Views
Last Modified: 2016-09-12
Willa  Foundations Server support SQL Installs? Have a client that needed just a basic server and the current old server has SQL 2008 loaded on it. Thanks in advance
0
Comment
Question by:cntech
[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
  • 3
  • 3
7 Comments
 
LVL 1

Expert Comment

by:Brad Featherstone
ID: 41791928
I do not understand  your question.

Are you asking:
   Can I install a new instance of SQL Server from Team Foundation Server?
or
   Can I deploy SQL Database Projects from Team Foundation Server?

Brad
0
 

Author Comment

by:cntech
ID: 41791930
I have sold a client a new foundations server. Will Sql 2008 install on it. Their old server has sql 2008 on it. Will the new one handle it....
0
 
LVL 1

Expert Comment

by:Brad Featherstone
ID: 41791956
What do you mean by "new foundations server"?

Is this a physical box or is this a software service?

If it is a physical box please describe the CPU, RAM, and Storage configuration, including the number and/or size of each.

Brad
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cntech
ID: 41791959
MS Windows Server 2012 Foundation R2 x64 1 Proc  (Up to 15 Users)
400W EPS Power Supply
Intel Quad Core Xeon E3 1220V3 3.1GHz S1150
Server Board S1200V3RPS C222 Socket LGA1150
24X DVD-RW 5.25 Optical Drive
32GB DDR3L 1600MHz ECC Unbuffered
Pedestal Chassis no Power Supply Black
Two 1Tb Solid State Hard Drives
3 Year Depot Server Warranty
Do Not Install PC Angel Recovery
Configure To RAID Level 1 For SATA
Server Red Depot Parts Warranty
Microsoft USB Keyboard and Mouse Combo
Thank You,
0
 
LVL 1

Accepted Solution

by:
Brad Featherstone earned 2000 total points
ID: 41791970
Now I understand.

You have 4 CPUs, 32 Gig of RAM, and 1TB of available RAID 1 storage (mirrored data)

Yes, SQL Server 2008 will install on the new box.

I do not understand why you would install such an old version of SQL Server on a shiny new box, but so it goes...

Brad
0
 
LVL 9

Expert Comment

by:RantCan
ID: 41792002
"Principal Editions of SQL Server 2016" from here: https://msdn.microsoft.com/en-us/library/ms143506.aspx#TOP_Principal

Which looks like it does install on Foundation server. This also applied to SQL 2012. I assume it applies to 2014 as well. Check and see if the client has a software assurance agreement under open license. You might be able to upgrade the SQL.
0
 

Author Closing Comment

by:cntech
ID: 41794035
Thanks good solid answer and well worded.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

752 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