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.
71
questions
31
votes
1
answer
14k
views
SQL Data-Tier Application - Export vs. Extract
What is the difference between the "Extract data-tier application" and "Export data-tier application" in the SSMS Options when right-clicking on a database?
5
votes
2
answers
6k
views
SQL Server 2014 SP1 installation failure - bug in SSIS_hotfix_install.sql
Installation of SQL Server 2014 SP1 fails if you have as SSIS Catalog on your server. After that, server does not start. Rebuilding system databases did not help (not sure, maybe because system ...
5
votes
1
answer
71k
views
Where can I find End of Life Support Dates for Microsoft Products? [closed]
Specifically, I would like the the End of Life Support Dates for these:
Windows Server 2012 R2
SQL Server 2014
4
votes
1
answer
3k
views
Why am I getting "RESTORE DATABASE TERMINATED ABNORMALLY" (Error 3013) when restoring from Azure Blob Storage to SQL Server 2014
Our production database server is backing up its databases nightly to Azure Blob Storage, using the BACKUP TO URL command in SQL Server 2014 Standard. I'm now attempting to restore those backups to a ...
3
votes
1
answer
20k
views
Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"
On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016....
3
votes
2
answers
305
views
Is there a performance overhead in having 2 instances of SQL Server 2014 running on the same VM
I have inherited an SQL Server 2014 which has been setup with 2 instances of SQL Server. Each instance hosts a number of databases and each instance has been setup to use all the CPU (4 processors) ...
3
votes
1
answer
128
views
OK to disable TLS1.0 with IIS and SQL Server 2014?
(This identical question in dba is drawing a blank)
Background
We need PCI-DSS compliance, and so must disable TLS1.0. In my test environment we have SQL Server 2014 SP1 with CU 1 (as per this post) ...
3
votes
1
answer
426
views
Sharing keys and certificates between SQL Server 2014 server for encrypted backup and restoration
I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server.
I would like to be able to take an encrypted backup of a database on ANY server and restore that ...
2
votes
5
answers
25k
views
SQL Server in "Recovery Pending" status after reboot
We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to ...
2
votes
1
answer
2k
views
Upgrading SQL Server (2014) Express to Standard
I have a server running SQL Server 2014 Express Edition that is fast approaching the 10GB limit for a database.
I've now purchased SQL Server 2014 Standard and wish to use it. SQL Server is no longer ...
2
votes
1
answer
3k
views
C:\Windows\System32\Config\systemprofile\desktop is unavailable
We are trying to set up Always On Availability Groups for SQL Server 2014 and we began with creating a cluster between two SQL Servers. Everything went fine until validating cluster creation and ...
2
votes
3
answers
3k
views
Why do I keep getting Microsoft-Kernel-Power error and my 2012 R2 DataCenter is randomly restarting with this error
Microsoft-Kernel-Power error ID=41 on Windows Server 2012 R2 Data Center.
My server went down twice yesterday due to this error happening, causing the server to restart on its own. This is an Azure ...
2
votes
3
answers
1k
views
Do SQL backups run faster if you set the databases to read only first?
I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined).
Will it go faster if I configure the script to set the database to read only first before backing it ...
2
votes
1
answer
2k
views
SQL Server Load Balancing Splitting Read/Write Operations
Hello We have 3 nodes of SQL Server 2014 Standard Edition one of them as primary and the other one as Replication of the Primary using Transactional Replication database
We want to use the other 2 ...
2
votes
0
answers
493
views
Importing data from Informix DB to SQL Server
Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard.
I selected source tables and views(steps in SQL ...
2
votes
1
answer
3k
views
Windows Backup / wbadmin errors | Source: SPP | Event id: 16389 | Increase SPP CreateTimeout?
After a reboot we encounter while the first backup (wbadmin) on a Windows Server 2016 these errors in the eventlog:
Source: SPP
Event ID 16389
Details: The writer's timeout expired between the ...
2
votes
0
answers
53
views
SQL Mirgations - Domain Trusts or not to Trust?
I am about to migrate something like 18 SQL servers into AWS from an on prem\colo. We will be building a new Domain in AWS and would like to leave the old domains behind. Do I need to setup a domain ...
2
votes
0
answers
154
views
Kerberos Double Hop - SQL2014 HA - MSA's
OK, so i'm at my wits end.
We have a system which works perfectly in our UAT environment (not HA) but will not work in live.
so the config is:
dns A record to iis box
binding in iis on :80 to ...
1
vote
1
answer
4k
views
MSSQL Management Studio 2014 not showing the "Tasks>Restore>Database..." Dialog
When right clicking on a database in the Object Explorer panel of SQL Server Management Studio 2014, and then expanding to "Tasks>Restore>Database...", then selecting it, the database restore dialog ...
1
vote
1
answer
3k
views
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: https://codekabinett.com/rdumps.php?...
1
vote
1
answer
62
views
Why do I get different memory numbers using TSQL versus the GUI?
I'm preparing to bump up our max server memory value after a RAM upgrade on our server. I'm testing the commands out on a test SQL Server and I'm not sure why I'm seeing different results with T-SQL ...
1
vote
1
answer
39
views
How can I isolate data-warehouse workloads from production/on-demand queries?
I'm using VMware's vSphere 6 and I'm considering consolidating several SQL servers, these servers have different usage profiles;
On-demand burst reporting (Cognos/Data-warehouse)
Interactive web ...
1
vote
1
answer
212
views
How to import SQL v8 (2000) DB in v12 (2014) Server
I made a backup of a db on one server and tried importing it on another server.
I got the error message saying they are incompatible.
I'm currently running SQL Express v12 on windows server 2012.
...
1
vote
1
answer
4k
views
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 ...
1
vote
1
answer
10k
views
Is Microsoft Sql Server 2014 certified for Windows Server 2016
I would like to update so version of my machine where is installed Microsoft Sql Server 2014, is this certified for Windows Server 2016? I don't want problems with MS assistance...
1
vote
1
answer
285
views
Azure SQL Express 2014 VM: Cannot update/patch SQL Express
I created a VM using the standard Azure image "SQL Server 2014 SP1 Express on Windows Server 2012 R2".
I immediately ran Windows Update and all patches for the server worked but the Security Update ...
1
vote
1
answer
400
views
Passing AD identity from Sharepoint Online to Analysis Services Tabular on an Azure VM
We are presenting charts & reports in Excel Services hosted in SharePoint Online. The Excel files in turn connect to an Analysis Services Tabular Model hosted in an Azure VM. In order to use ...
1
vote
1
answer
7k
views
SQL Server 2014 Install Failed with The computer must be trusted for delegation and the current user error
I'm attempting to install SQL Sever 2014 newly installed Windows Sever 2012 R2 Standard edition OS. During the GUI portion of the installation it fails with the following error:
There was an error ...
1
vote
1
answer
4k
views
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 ...
1
vote
1
answer
2k
views
SQL Server 2014 setup fails: SSL Provider, error: 0 - The token supplied to the function is invalid
I am attempting to install SQL Server 2014 Standard edition on a new Windows Server 2016 set up as a domain controller that replaces a retired DC. (I know it's not recommended, but we are a small ...
1
vote
0
answers
45
views
Can't build second Azure VM in an availability set without selecting managed disks
I have an Azure availability set which I built a SQL server in without managed disks, manually creating two 2TB volumes out of 1TB volumes that get assigned. If I go to build a second in the portal ...
1
vote
1
answer
146
views
SQL Server uses CPU too much
I have a server 2012R2 with SQL Server 2014 Express SP2 installed. There are some applications and databases, but nothing too big. Databases are small, about 100MB size combined.
At some moment (not ...
1
vote
0
answers
339
views
Deployment fails for SQL Server 2014 SP1 Standard on Windows Server 2012 R2 VM
Apologize in advance - this stuff isn't exactly my wheelhouse.
I'm trying to provision a VM with Windows Server 2012 R2 and setup SQL Server 2014 SP1 Standard using the Azure portal. I pretty much ...
0
votes
3
answers
2k
views
"Unknown token received from SQL Server" errors since recent Windows Updates
I posted a question to Stack Overflow about this error when it started occurring for our older Delphi 7 applications on Windows 10.
It is now happening on Windows Server 2012 R2 systems that had these ...
0
votes
1
answer
73
views
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 ...
0
votes
1
answer
1k
views
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 ...
0
votes
3
answers
2k
views
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 ...
0
votes
1
answer
938
views
Should I keep SQL Server/ IIS website on the same server? [closed]
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 ...
0
votes
1
answer
316
views
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 ...
0
votes
1
answer
73
views
how to create public SQL server [closed]
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 ...
0
votes
0
answers
68
views
SQL DB failing to send server email - intermittent
Recently, we noticed an issue in SASS 2014 logs regarding the failure of some emails to send:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using ...
0
votes
0
answers
186
views
error 17054 severity 16 state 1 sql server 2014 enterprise edition
Our new database is just inaccessible.
I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL ...
0
votes
1
answer
151
views
How to enable more than 4 GB in SQL Server X86 under Windows X64
I have read here that I can use more than 4 GB in X86 SQL Server Systems and X86 Windows servers via /PAE option, but my scenario is different.
I have a 32 bit SQL Server std in a Windows 2019 X64 std ...
0
votes
0
answers
225
views
SQL Server: Are shared locks used for foreign key constraint enforcement, and how long are they kept?
Main question is in the subject.
In more detail: Let's say we have a table T with a FK constraint to table U (for simplicity, to its PK, and both table use clustered indices on their PKs). Now, we ...
0
votes
1
answer
24
views
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.
...
0
votes
1
answer
87
views
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 ...
0
votes
1
answer
2k
views
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.
...
0
votes
0
answers
578
views
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 ...
0
votes
1
answer
381
views
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 ...
0
votes
1
answer
51
views
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 ...