Questions tagged [sql-server-2016]

The tag has no usage guidance.

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

Stretch Database but not to Azure

I'm technically a Developer but I'm effectively a pseudo-DBA. I'm trying to a newer version of SQL Server to the decision-makers. As part of that, I want the functionality of a "Stretch" database, ...
0
votes
0answers
41 views

SQL Server 2016:Always on Availability Groups with Different Named Instances

I'm working with a SQL Server Always on 2016 Configuration with two data centers. At these two data centers,they have their own named instance. For Example: MYDC1\ADC1 MYDC2\ADC2 So the hostnames ...
0
votes
0answers
17 views

SQL Server AlwaysOn cluster - seeding large availability database creating strange behavior

I set up a 2-node SQL Server 2016 AlwaysOn Availability Group cluster (1 primary, 1 secondary). The underlying hardware is fairly powerful; 4 CPUs, 16 GB of RAM and local-attached SSD disk. Then I ...
1
vote
1answer
20 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). ...
0
votes
2answers
89 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
1answer
116 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 ...
1
vote
2answers
148 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....
0
votes
0answers
14 views

How to specify overwrite file when creating a maintenance plan for full nightly backups

I don't see how to specify that the backup file (a full nightly backup of a particular database) should overwrite the previous night's file, when creating a maintenance plan using the Wizard or using ...
1
vote
0answers
29 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
0answers
16 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 ...
0
votes
1answer
485 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 ...
0
votes
1answer
136 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 ...
0
votes
0answers
41 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 ...
0
votes
1answer
47 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 ...
4
votes
1answer
144 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
vote
0answers
34 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 ...
1
vote
0answers
20 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: ...
0
votes
0answers
350 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 ...
11
votes
1answer
7k 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 ...
0
votes
1answer
167 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 ...
2
votes
2answers
380 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 ...
1
vote
1answer
31 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
0answers
73 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 ...
0
votes
1answer
1k 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
1answer
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 ...
0
votes
1answer
215 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
144 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
80 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
1answer
434 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
906 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 ...
0
votes
1answer
381 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 ...
0
votes
1answer
80 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....
1
vote
0answers
75 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 ...
3
votes
0answers
2k 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 ...
2
votes
0answers
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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
805 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 ...
0
votes
3answers
4k 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 ...
8
votes
1answer
722 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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
497 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 ...
7
votes
2answers
411 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 ...
2
votes
1answer
2k 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\...
1
vote
0answers
39 views

Update SQL installs remotely

I have sys admin, local admin and remote desktop access on a bunch of Windows Server 2012 R2 VM's with SQL Server 2016 installed. Is there a way to install an update on all of them from a single ...
1
vote
1answer
125 views

SQL Server backup overwrite increases in size

I have a small database, that backs up to around 3.5mb. If I overwrite the backup Tasks -> Backup -> Type: Full -> Backup to disk it increases in size each time around 3.5mb. If I delete ...
1
vote
0answers
486 views

SQL Server 2016 Always Encrypted and AlwaysOn readable secondary connection error

I've used Always Encrypted in SQL 2016 to encrypt the data in a few columns of a table in my application. Always encrypted appears to be set up correctly, because I can see the encrypted data in SSMS ...
0
votes
1answer
2k views

Windows update error code 86430003 - Security Update for SQL Server 2016 RTM GDR (KB3194716)

My server is failing to install update KB3194716. I am getting an error code 86430003 from windows update. Server is Windows Server 2012 R2. Windows update is consistently failing to apply this, my ...