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
0
votes
1 answer

failover cluster creation Error

I am creating a fail over cluster, but doing so i get the error "An error occurred while creating the cluster. An error occurred creating cluster 'testCluster'. This operation returned because the timeout period expired " Moreover following is my…
Sabih Ahmed Khan
  • 1
  • 2
0
votes
3 answers

SQL Server Named Pipe Error

I have been trying to install SQL Server Express for a few days now. I tried 2008, 2012, and now 2014 all with the same result. I cannot connect to the database remotely, even if I turn the firewall on the Windows 2012 Server off. I get the…
deflator
  • 11
  • 4
0
votes
0 answers

Database locks up with READ_COMMITTED_SNAPSHOT ON after upgrade to SQL 2014

Since we migrated our database from SQL Server 2005 to SQL 2014, we're experiencing repetitive locks in the database. We used to have very few locks in SQL 2005. The READ_COMMITTED_SNAPSHOT is ON in the database and still ON in SQL 2014. We migrated…
Blake Zero
  • 107
  • 1
  • 2
  • 9
0
votes
1 answer

SQL Server Management Studio always encrypt connections

In the connections dialog of Management Studio there is an option to encrypt the connection so that you can force the connection to the remote server to be encrypted. Is there a way that I can make every connection I make in Management Studio to be…
Laurence Frost
  • 101
  • 1
  • 2
0
votes
1 answer

Should I keep SQL Server/ IIS website on the same server?

I know this type of question has already been asked (Difference of speed if SQL Server is on one server and website is on another, rather than both on same server), I don't know if it's applicable to my situation. The current situation: I have one…
Tom741
  • 1
0
votes
1 answer

SideBySide Event ID 63 Error ~ Microsoft SQL Server

I am getting the following repeating errors in event viewer: Does anybody know what is causing these errors and how to fix them?
Linger
  • 251
  • 3
  • 9
  • 25
0
votes
1 answer

MS SQL-Server 2014 and SQL Server Data Tools

How do I install SQL Server Data Tools for MS SQL-Server 2014? In previous versions of MS-SQL-Server those tools come with the regular installation-package for the server itself. For SQL-Server 2014 the options are gone. Here you can see the…
wotanii
  • 113
  • 2
0
votes
1 answer

SSIS 2014 - map NFS

We are migrating SSIS from SQL 2008 to SQL2014. Old OS: WINDOWS 2008 R2 SP1 New OS: WINDOWS 2012 R2 I use the Execute Process Task to map an NFS share to a drive. Executable: C:\Windows\System32\net.exe Arguments: use Q: :/vol/ When I execute…
Boeykes
  • 1
  • 1
0
votes
1 answer

SSMS (2014) cannot connect to remote DB on local network

To start, this set up used to work. I wanted to help on a friend's project and installed git and vagrant and somewhere between the last time I opened my own project (using the setup listed below) and today, it has stopped working. Current set…
MetalPhoenix
  • 101
  • 1
0
votes
1 answer

Can I use SQL Server Enterprise Edition on VM Azure for production use

I have Microsoft BizSpark subscription in which I received Azure credits as well. I created a Virtual machine on it and I am planning to install SQL Server Enterprise edition which I see available under Subscriber downloads page. Can I install it on…
Shantanu Gupta
  • 219
  • 1
  • 8
0
votes
1 answer

SQL Server 2014 Backups not inheriting NTFS permissions

I am running a script I run on all my SQL servers however on this specific server I have run into the problem where the script fails to make a copy of the DB backups in an external location because the script gets access denied on the newly created…
ZZ9
  • 888
  • 3
  • 16
  • 47
0
votes
1 answer

how to create public SQL server

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server from outer computer). I'am using java, wotking with…
divelner
  • 1
0
votes
1 answer

32Bit ODBC DSN "Server does not exist or access denied" but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
ZZ9
  • 888
  • 3
  • 16
  • 47
0
votes
1 answer

Using a Load Balancer in front of SQL Server

We are setting up SQL Server 2014 AG with multiple secondary readonly instances since we have some significant queries that are killing our primary. What we would like to do is put a Load Balancer in front of the readers to help scale out. The web…
Thad
  • 101
  • 3
0
votes
0 answers

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ASAP if disaster happens. We requested our managed…
Alex Aza
  • 101
  • 2
1 2 3
4
5