Solved

Foundations Server

Posted on 2016-09-09
7
53 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 500 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

920 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

15 Experts available now in Live!

Get 1:1 Help Now