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.
30
questions with no upvoted or accepted answers
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
442
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
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
540
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
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
157
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
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
0
answers
340
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
0
answers
131
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
227
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
0
answers
250
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
100
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
0
answers
695
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
388
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
0
answers
727
views
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?
0
votes
1
answer
170
views
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 ...
0
votes
1
answer
428
views
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 ...
0
votes
1
answer
2k
views
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 ...
0
votes
1
answer
826
views
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 ...
0
votes
0
answers
142
views
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 ...
0
votes
1
answer
295
views
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 ...
0
votes
1
answer
1k
views
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?
0
votes
1
answer
228
views
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\...
0
votes
1
answer
401
views
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 ...
0
votes
1
answer
1k
views
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 ...
0
votes
0
answers
442
views
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 ...
0
votes
1
answer
2k
views
Unable to connect to SQL Server on live server
I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website.
When I test my local copy of the ...
-1
votes
1
answer
2k
views
ODBC Driver Version 03.86.3959 connection to SQL Server 2014
Ok so I have some accounting software running on a Windows Server 2003 box. This server uses a System DSN, that uses Microsoft SQL Server ODBC Driver Version 03.86.3959 to connect to a Management ...
-2
votes
1
answer
448
views
I need to fully automate sql server restores , PLease help me
I'm New to Sql server and dont have experience in automate restores
I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path.
I can ...