Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [sql-server-2016]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
68 views

AWS - In place upgrade of SQL Server 2016 -> 2019 - How to Location Product Key

I have a AWS EC2 instance, specifically a t3.2xlarge, that has windows server 2019 and SQL Server 2016 Standard installed(license came from the instances, through AWS), I'd like to upgrade my server ...
user avatar
0 votes
1 answer
154 views

Reporting Services 2016: Cannot Edit or Upload RDL (Throws Exception and Memory Dump)

I have an SQL Reporting Services 2016 (13.0.5103.6) Standard native instance which won't let me edit Reports (RDLs) with Report Builder 15.0.19611.0 or upload them via the Reports portal, it throws an ...
user avatar
  • 1
0 votes
2 answers
52 views

Log Shipping & Target Database filenames

I have a production and disaster recover ('DR') server and have been using log-shipping on a single database ('DB1') between the two servers without issue for a few months. Recently I've had to ...
user avatar
  • 13
0 votes
0 answers
24 views

Why would drives become inaccessible after SQL Express 2016 installation

I was preparing a new Windows Server 2016 VM to host SQL Server Express 2016. I created a virtual drive for the OS (C:) and installed the operating system. I also created 3 additional drives for DATA (...
user avatar
2 votes
1 answer
315 views

How to debug the cause of my suddenly extremely slow running database backups maintenance plan?

(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.) Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server ...
user avatar
  • 121
0 votes
1 answer
63 views

?Does SQL Server 2016/2019 Web Edition supports encryption

I trying to find out if SQL Server 2016 and 2019 Web Edition supports encryption (on AWS)? any help will be appreciated. Thank you, Moshe
user avatar
3 votes
1 answer
487 views

SQL Server Always On Availability Group Zero Downtime Update Procedure

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary. The question is - what is the optimal way to install Microsoft Updates on the servers in the ...
user avatar
  • 319
0 votes
2 answers
720 views

Microsoft OLE DB Driver connection string for RDS High Availability

I need to configure RDS Farm High Availability based on Windows Server 2016 with MS SQL Server 2016. One of the steps is connect to database. All available guides tell me to use SQL Server Native ...
user avatar
  • 13
0 votes
1 answer
132 views

Everyday the DBs are in Recovery pending state

I have an Azure Virtual Machine hosting a SQL Server 2016 named instance. On this instance I have several DBs. Now, everyday we shutdown the virtual machine at 11.59PM and restart it at 8.00AM. The ...
user avatar
  • 101
1 vote
1 answer
78 views

Databases "Synchronized / In Recovery" after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). ...
user avatar
0 votes
2 answers
628 views

How to allow remote connection to SQL Server instance only to specific public IP Address (white-list) & restrict access to all other IP's [closed]

How do I allow remote connection to SQL Server instance only to specific public IP Address (white-list)? For example, login from SSMS to SQL Server instance hosted on Windows dedicated server ...
user avatar
0 votes
1 answer
157 views

How to install a certificate and encryption on SQL Server without downtime?

So I have a SQL Server 2016 instance running a mission critical workload. I want to install an SSL/TLS (publicly signed) certificate into the server, and enable encryption. But I don't want to incur ...
user avatar
  • 319
1 vote
2 answers
294 views

no permission to connect to the WMI provider - after sql server installation

I am the administrator of a windows server 2016. After installing sql server, I want to use the sql server configuration manager to have a look at what ports and accounts are there, check if all is ok....
user avatar
1 vote
0 answers
30 views

MS SQL 2008R2 Peer-to-Peer replication Zombie data

We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This ...
user avatar
0 votes
0 answers
30 views

Azure File Sync Svc installed on same server as SQL Server Issues

I've got Azure File Sync Service installed on the same server as SQL Server 2016. I'm attributing the issue to the File Sync service because this is the only change made to server after the issues ...
user avatar
0 votes
1 answer
1k views

Failover cluster SQL server 2016: 'the remote computer refused the connection'

BACKGROUND We have a new SQL server 2016 failover cluster (without Always On) (clu1) with 2 nodes (sql1-2) and 4 roles/instances (app1-4) Connections from de nodes to the cluster instances work fine ...
user avatar
0 votes
1 answer
624 views

SQLLOGDIR token maps to wrong path

I've some jobs running, which use the SQLLOGDIR token. Currently it places output in the following location: D:\sql\MSSQL14.MSSQLSERVER\MSSQL\Log However, I'd like to log it to H:\ I've been into ...
user avatar
  • 1
0 votes
0 answers
116 views

Azure Cloud Witness with HTTP proxy

Windows Server Documentation states: Proxy considerations with Cloud Witness Cloud Witness uses HTTPS (default port 443) to establish communication with Azure blob service. Ensure that HTTPS ...
user avatar
0 votes
1 answer
52 views

WS 2012R2 Hyper-V Exchange and SQL Guest Backups

Background: 2012R2 host running Hyper-V. Virtualised: DC, Exchange 2013 and SQL 2016 (2012R2). This is a lab environment so numerous options are welcomed. In short, we currently backup the entire ...
user avatar
  • 305
4 votes
1 answer
185 views

What may increase the latency 3-4 times for SQL FCI the database?

We have SQL Server Basic Availability Groups (BAG) configured to run an SQL database running over local Intel SSD drive. I was asked to move a database to SQL Server Failover Cluster Instance (FCI) to ...
user avatar
  • 1,476
1 vote
0 answers
47 views

Restoring SQL Database with NoRecovery stuck

We are moving from a SQL 2008 standalone instance to a SQL 2016 HA Failover Cluster Instance (FCI) with an AlwaysOn Basic Availability Group (BAG) configured to replicate to a standalone DR instance ...
user avatar
  • 221
1 vote
0 answers
24 views

T-SQL Finding who attempted to backup the “master” database?

I'm running SQL Server 2016. For the last two nights at 7pm the SQL Server Alert System sent me this alert: 'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: ...
user avatar
  • 111
0 votes
0 answers
550 views

No remote client protocols are enabled and no remote protocol was specified in the connection string

Here's my situation. There are three servers: Windows Server 2016 (Server-1) Windows Server 2016 (Server-2) Windows Server 2016 with SQL Server 2016 (Server-SQL) I have some C# code which connects ...
user avatar
  • 101
13 votes
1 answer
13k views

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker ...
user avatar
0 votes
1 answer
226 views

Find outdated statistic in SQL server?

I have a stored proc which searches "bad" data in our application database (sql server 2016 enterprise, ~500gb data). "bad" in a business/process sense. It normally takes 10-30s to execute. After ...
user avatar
  • 101
2 votes
2 answers
551 views

Failover SQL cluster to DR site using replication

I am attempting to fail over a SQL cluster with 2 nodes using Zerto replication. I am running Server 2016 Standard and SQL 2017 standard. My network is not stretched, so I need to failover using a ...
user avatar
  • 21
1 vote
1 answer
45 views

Is Windows able to run Disk Optimize with SQL Server running?

I've just inherried a SQL Server, where the database file growth was set to 1MB. So there are a lot of databases (>25) that have grown in small increments until now (currently totalling 300 GB). So I ...
user avatar
1 vote
0 answers
78 views

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the ...
user avatar
1 vote
1 answer
2k views

You were not connected because a duplicate name exists on the network.

I am getting this error daily on my web server that is trying to connect SQL Server. "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server ...
user avatar
0 votes
1 answer
3k views

How to stop process fdhost?

I'm trying to update SQL Server 2016 to CU7. During the Files in Use check, I'm prompted to stop fdhost.exe for each running instance in order to prevent the need for a reboot. But how to stop this ...
user avatar
  • 703
0 votes
1 answer
263 views

Load balancing and failover with SQL 2016 and IIS on AWS

I apologize if this question is too general, but i just wanted a sanity check for a setup I've been planning. Right now i have an application that runs on an AWS server, with SQL and IIS both ...
user avatar
  • 103
2 votes
1 answer
3k views

SQL SVR 2016 - Relocating system databases to different drive (Invalid directory error Msg 5121)

I have a fresh install of SQL Server 2016 which i'm trying to relocate the system databases onto a different drive on the machine Drive:D I've ran the following commands but keep getting the same ...
user avatar
  • 157
0 votes
1 answer
285 views

Unable to get SSRS 2016 to send subscription emails

I'm having an issue with sending reports via email on SSRS 2016 So basically I have a VM on the Azure platform configured as an SQL server. SQL01 (Windows 2012 Server) + SQL SERVER 2008 R2 + SQL ...
user avatar
  • 151
1 vote
1 answer
2k views

SQL Server - Connect via SSMS works fine, but ODBC fails

I have a SQL 2016 Express instance, and I can connect to this fine using sqlsrv_connect() from within PHP. However, when I try to create a ODBC connection it fails. I get the error message "SQL Server ...
user avatar
  • 203
1 vote
1 answer
89 views

Error accessing database after migration

We've an old application made on Classic asp and we're migrating this to a new server. until here everything works fine, our problem is when the application needs to access the database, we get the ...
user avatar
0 votes
1 answer
544 views

UNICODE version supported by SQL Server 2016

What is the Unicode standard version supported by SQL Server 2016? (I'm specifically interested in this version. However, information for 2014 or 2017 is welcome as well.) I can't find this ...
user avatar
0 votes
1 answer
2k views

How to enable/force Microsoft SQL Availability Group Listener IPs to register Reverse DNS?

I have a few Availability Groups and would really like to have their Listener IP Addresses register reverse DNS, is there a setting I missed to enable this? (forward dns works as expected). SQL ...
user avatar
  • 7,525
0 votes
1 answer
2k views

SQL server 2016 express - Error 1067: The process terminated unexpectedly

I have installed SQL server 2016 on windows 10. The install process completed successfully except for the final step, which was a restart. Prior to this I had tried a couple of times and the process ...
user avatar
  • 101
0 votes
1 answer
723 views

SQL Server 2016 Install entering Single User Mode

We have a problem which happens on approx 1 in 5 installs of SQL 2016 on Win 2016 (using amazon EC2). The install fails and seems to be that the SQL Server enters single user mode whilst the install ...
user avatar
  • 1
0 votes
1 answer
107 views

SQL Server 2016: Invisible Alias

SQL Server 2016: Alias doesn't show up but when I add it, it tells me it's a duplicate I've got an alias that I'm sure I created under SQL Server Configuration Manager>>SQL Native 11 (32bit)>>Aliases....
user avatar
1 vote
0 answers
78 views

SQL 2016 clustering, creating and failover

I'm a application manager, and I had my application wizard create a SQL database on the clustername, not on one of the two nodes of the cluster, but on the clustername. Now a week later, my ...
user avatar
  • 519
3 votes
0 answers
3k views

How can I completely uninstall SQL Server 2016 and everything that it installed?

I installed the Express edition of SQL Server 2016 to test and I now want to uninstall it and everything that it installed on this server. I have SQL Server 2014 installed and do not want that ...
user avatar
  • 41
2 votes
0 answers
2k views

Does SQL Server 2016 Support Windows Server 2016 Essentials?

The Requirements for SQL Server 2016 list the following operating systems as being supported: Windows Server 2016 Datacenter Windows Server 2016 Standard Windows Server 2012 R2 Datacenter Windows ...
user avatar
0 votes
1 answer
2k views

MS SQL Server Errors/sec

I need some help tracking what is causing some errors reported by the Errors/sec Counter for MS SQL Server 2016. The counter is showing around 2 errors per 10 seconds however I don't see anything in ...
user avatar
  • 163
0 votes
1 answer
1k views

SQL Server Manager crashes when viewing user permissions

I have a problem that I can't seem to find a solution to. When I click on a user in a specific location, SQL Server Manager 2016 crashes to an error dialoge. This is a repeatable incident. I'm on ...
user avatar
  • 137
0 votes
3 answers
5k views

SQL 2016 - FILESTREAM feature is disabled. (bogus message)

I'm having problems getting filestream to work. I know how to configure it, and have setup numerous servers running it. For some reason, even though Filestream is definitely enabled, I keep getting ...
user avatar
8 votes
1 answer
782 views

The setup of S2D that delivers up to 2M IOPS to SQL FCI

We are about to deploy shared storage researching for ultra-fast storage to implement Microsoft SQL Server Failover Cluster (FCI). So far the project goes, we would to start with 500K IOPS for 8k ...
user avatar
2 votes
2 answers
3k views

SQL Server Bulk insert over UNC path failing, despite full access

I have a setup with 2 machines (client on win2012r2, sql server on win2016) which are both not part of a domain. The client machine has a share, accessible to Everyone. I'm using SQL Server ...
user avatar
  • 133
1 vote
1 answer
850 views

MSSQL proxy system permissions required to run PowerShell steps

I started to ask this on StackExchange DBA but decided it was probably going to be more of a Windows Server security type of question. SQL Server 2016 SP1+CU on Server 2012 R2. I'm trying to run a ...
user avatar
7 votes
2 answers
697 views

SQL on Server Core pitfalls [closed]

We are going to try new SQL Server 2016 and we're thinking to install it on Windows Server Core. I know there are some benefits from going this way. From what I've heard, this setup is more secure and ...
user avatar