Questions tagged [sql-server-2014]

Question 1

I have tried to open a "log" file of SQL DB with Windows Notepad application. Unfortunately, I forgot to remove the tick from the checkbox of “Always use the selected program to open this ...

Question 2

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

Question 3

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

Question 4

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?...

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 Freeze ...

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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) ...

Question 24

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

Question 25

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

Question 26

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

Question 27

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?

Question 28

Specifically, I would like the the End of Life Support Dates for these: Windows Server 2012 R2 SQL Server 2014

Question 29

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 usage ...

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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?

Question 49

(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) ...

Question 50

I think I was able to convince my cow-erkers that jamming all the databases on one server is a good idea. So, our setup will be something like this: Production - SQL 2014 Enterprise Standby - SQL ...