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.
0
votes
0answers
7 views
How can I connect and install driver to sql server from phpdesktop [closed]
My application run smoothly on wamp but when I tried to convert it to desktop application using phpdesktop, this error was displayed on the screen could not find driver
I have alredy done this in ini....
1
vote
1answer
110 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 ...
0
votes
0answers
6 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 prod environment and wants to make full,differential and transactional log backups.
my ...
0
votes
0answers
43 views
Set a specific port for SSAS
I'd like to force the SSAS (SQL Server Analysis Service) instances to use from a specific port instead of using dynamic port because of the firewall policy.
According to this link The default port ...
1
vote
1answer
22 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
0answers
124 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
1answer
278 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 ...
0
votes
1answer
45 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
0answers
35 views
SQL SERVER 2014 copy a multi file group database to a single file group db for transferring to azure
I have been trying to transfer a 1TB sql server db to azure sql db for performance assessment. I tried using Data Migration Assistant many times but it hangs and exits every time during data transfer. ...
0
votes
1answer
35 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 ...
1
vote
0answers
38 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 ...
0
votes
0answers
352 views
Not able to connect to Availability group Listener
I have an availability group configured for 2 servers SQL Server 1 and SQL server 2. From client, I am able to connect to SQL Server 1 and SQL Server 2 separately. But when I try to connect to the ...
0
votes
1answer
851 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.
...
2
votes
1answer
890 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
1answer
277 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 ...
0
votes
0answers
103 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 ...
1
vote
1answer
3k 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...
0
votes
1answer
99 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 ...
3
votes
2answers
60 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) ...
0
votes
1answer
20 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 ...
2
votes
0answers
48 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
1answer
2k 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 ...
0
votes
0answers
250 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?
3
votes
1answer
43k 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
1
vote
1answer
34 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
1answer
94 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 ...
3
votes
1answer
222 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
1answer
9k 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....
0
votes
1answer
82 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
1answer
492 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 ...
1
vote
0answers
308 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 ...
2
votes
0answers
118 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 ...
0
votes
1answer
297 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
1answer
1k 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
1answer
414 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
3answers
1k 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 ...
2
votes
3answers
2k 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 ...
1
vote
1answer
248 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 ...
0
votes
0answers
124 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 ...
1
vote
1answer
281 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
1answer
119 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.
...
0
votes
1answer
102 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
1answer
576 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 ...
15
votes
1answer
6k 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?
3
votes
1answer
116 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) ...
-1
votes
1answer
136 views
SQL Server Failover Clustering (4 nodes)
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 ...
2
votes
6answers
18k 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 ...
0
votes
1answer
854 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
1answer
47 views
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 ...
0
votes
1answer
98 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\...
