Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2014]

Microsoft SQL Server 2014 is a version of the relational database management system designed by Microsoft, released on April 1, 2014.

Microsoft SQL Server 2014 was released on April 1, 2014, and brought with it some notable changes. They include but are not limited to:

  • New cardinality estimator
  • New In-Memory OLTP Engine
  • Enhanced Windows Server Integration
  • ...

For a full list of features, Microsoft supports and updates a comprehensive list of features, comparative to older versions of SQL Server.

The full list of editions has been updated as well in the latest version of SQL Server.
Currently they have three mainstream production editions:

  • Enterprise
  • Business Intelligence
  • Standard

A specialized edition in Web, and two breadth editions in Developer and Express.

70 questions
1
vote
1 answer

Is it possible to use the SQL Profiler on SQL Server 2014 Web or Express edition?

I'm a bit confused as to whether or not it is possible to use the SQL Profiler on the Web/Express edition of SQL Server. From what I've read so far people generally say "No - it was removed in SQL Server 2012/2014". But then I read the…
Torben Warberg Rohde
  • 169
  • 3
  • 9
1
vote
1 answer

How to determine the common name (CN) for a microsoft sql certificate?

I'm in the process of trying to set up a self signed certificate for connecting a jetty server to a development sql database. I'm following the instructions here:…
pbuchheit
  • 151
  • 2
  • 11
1
vote
1 answer

SQL Server: A connection was successfully established with the server, but then an error occurred during the pre-login handshake

When I try to connect to the SQL Server I get the following error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period…
Pawel
  • 121
  • 1
  • 3
0
votes
1 answer

Defining 2014 SQL Backup and Restore Process

I have an Vmware vsphere environment with 3 vlans, Prod,Test and Dev. The client has 6 SQL servers within the production environment and wants to make full,differential and transactional log backups. My question is, I have defined the backup…
Yourdaman
  • 23
  • 3
0
votes
1 answer

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with various other versions. How can I change which…
Rob
  • 31
  • 7
0
votes
1 answer

How to create different databases in sql server 2014, with single or multiple instances?

I am very new to SQL server and currently in my organization for an automation project, we need to create two databases each for Dev, Pre-Prod and Prod environments. Our application is supporting SQL server 2014 but now i am confused how to create…
SSharma
  • 3
  • 1
0
votes
1 answer

Unable to Connect to SQL Server 2014 SP2 using the SQL Native Client 10

Attempting to connect using the SQL Server Native Client 10.0 Results in the below error: Client Unable to establish connection Shared Memory Provider: No Process is on the other end of the pipe. Forcing the connection to use TCP just changes the…
Rhys
  • 26
  • 4
0
votes
0 answers

Random Machines Briefly Losing Connection To MS SQL Server

My company has designed an application for our in-house processes that runs on about 50 virtual machines. This has been running for over 5 years now and at the beginning of the year we setup a new server cluster for our new Microsoft 2014 database.…
Patrick
  • 147
  • 3
  • 11
0
votes
1 answer

Can You Debug Constraints In SQL Server?

I have a constraint that will not let me add it if the conditions are invalid, but the constraint allows invalid data into the table after it is added. I would like to debug what it is doing at run time, but I cannot figure out how to create either…
Elias
  • 93
  • 1
  • 9
0
votes
1 answer

MS SQL Server 2014 license reusability

I have a MS SQL Server 2014 Standard license in my server. I need to restore a database in a different secondary machine to get data of a particular table from a backup. The problem is that this table is stored in a database of more than 10GB and I…
Tobia
  • 1,272
  • 9
  • 41
  • 81
0
votes
0 answers

SQL Server 2014 stuck on uninstall

It must be around one hour and a half that I'm waiting for the uninstall process but it is frozen on this task: Can't Uninstall Any ideas?
Marco
  • 101
  • 2
0
votes
1 answer

Cannot deploy SCCM 2012 client

I'm attempting to get System Center Configuration Manager 2012 up and running for my organization, but my attempts to roll out the client don't appear to be successful within my test group. My current installation attempt is on a Hyper-V virtual…
ORAORAORA
  • 1
  • 1
0
votes
1 answer

Intermittent timeouts connecting to Availability Group Listener

I have a database in a SQL Server Availability Group running on a database server. If I log into my web server and connect to the primary database directly by the database server IP the connection is instantaneous every time. If I instead connect…
NorthFork
  • 151
  • 6
0
votes
1 answer

Is it possible to update existing SQL Server 2014 Express with Advanced Services RTM to SP1 using the SP1 SQLEXPRADV_x64.exe?

I'm creating an installer that configures a SQL Server instance, and I'm trying to allow for it to update an existing installation if it is RTM. I tried with /Action=Upgrade with no success. Same story with /Action=Install. Is there any way I can do…
Pablo Montilla
  • 103
  • 2
0
votes
1 answer

SQL Server 2014 Reporting Services failure

I have a server that is also a domain controller running 2012 R2. I have successfully installed SQL Server 2014 with native reporting services. However, when I go to the web server .../reportserver I get this: An internal error occurred on the…
MikeAinOz
  • 101
  • 4
1 2
3
4 5