Questions tagged [sql-server-2016]
The sql-server-2016 tag has no usage guidance.
63
questions
1
vote
1
answer
1k
views
Can't find NT SERVICE\MSSQLSERVER to give it Read privs on a cert
I've got SQL Server 2016 happily running under the default account NT SERVICE\MSSQLSERVER. Now, though, I need to give that pseudo-account read priv on a newly installed SSL Certificate.
The pseudo-...
- 223
0
votes
2
answers
966
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 ...
- 1
0
votes
2
answers
59
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 ...
- 13
2
votes
1
answer
857
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 ...
- 121
0
votes
1
answer
172
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
3
votes
1
answer
1k
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 ...
- 459
0
votes
2
answers
1k
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 ...
- 25
0
votes
1
answer
235
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 ...
- 101
1
vote
1
answer
260
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).
...
- 299
0
votes
2
answers
755
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 ...
0
votes
1
answer
223
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 ...
- 459
1
vote
2
answers
458
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....
1
vote
0
answers
33
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 ...
0
votes
0
answers
38
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 ...
- 1
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
...
- 55
0
votes
1
answer
885
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 ...
- 1
0
votes
0
answers
173
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 ...
- 626
0
votes
1
answer
54
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 ...
- 305
4
votes
1
answer
217
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 ...
- 1,476
1
vote
0
answers
53
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 ...
- 219
1
vote
0
answers
35
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: ...
- 111
0
votes
0
answers
648
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 ...
- 101
14
votes
1
answer
18k
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 ...
- 410
0
votes
1
answer
243
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 ...
- 101
2
votes
2
answers
604
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 ...
- 21
1
vote
1
answer
69
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 ...
1
vote
0
answers
87
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 ...
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 ...
0
votes
1
answer
4k
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 ...
- 753
0
votes
1
answer
276
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 ...
- 103
2
votes
1
answer
4k
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 ...
- 157
0
votes
1
answer
301
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 ...
- 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 ...
- 203
1
vote
1
answer
117
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 ...
0
votes
1
answer
587
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 ...
- 404
0
votes
1
answer
3k
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 ...
- 7,816
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 ...
- 101
0
votes
1
answer
835
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 ...
- 1
0
votes
1
answer
121
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....
- 165
1
vote
0
answers
80
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 ...
- 658
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 ...
- 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 ...
- 410
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 ...
- 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 ...
- 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 ...
- 355
8
votes
1
answer
839
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 ...
- 530
2
votes
2
answers
4k
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 ...
- 133
1
vote
1
answer
957
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 ...
- 188
7
votes
2
answers
827
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 ...
- 454
2
votes
1
answer
3k
views
Cannot generate SSPI context SQL Server 2016
First post here :)
I've been trying to connect to a SQL server 2016 in a pc using SSMS 2016, both EXPRESS editions.
Server shows up in Network Servers window.
I'm trying to connect with HOSTNAME\...
