Questions tagged [sql-server-2016]

The tag has no usage guidance.

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

getting error when changing “log on” user from “NT Service\MSSQLSERVER” TO “local” machine user for “MSSQLSERVER” service

I have installed SQL Server 2017 in one domain machine and "MSSQLSERVER" service running with user "NT Service\MSSQLSERVER" And when running sql command EXEC xp_logininfo 'DOMAIN\...
0
votes
0answers
8 views

Sqlserver: maintenance-task fails

On one particular Sqlserver (2016) we have an issue with a maintenance task. The task consists of a single t-sql-statement: USE DbaUtils GO EXEC pDoSomething In about about 5% of executions, this job ...
0
votes
0answers
16 views

SQL Server Always On Availability Group Database Mirroring Certificate Zero Downtime Renewal Procedure?

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary, and there are certificates that encrypt the traffic from node 1 -> node 2, and node 2 -> ...
3
votes
1answer
51 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 ...
0
votes
2answers
149 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 ...
0
votes
0answers
21 views

Create a server role with some (not all) sysadmin permissions

Microsoft SQL Server Enterprise: Core-based Licensing (64-bit), Version: 13.0.5850.14 OS: Microsoft Windows NT 6.3 (14393), Platform: NT x64 We need to give another IT group limited sysadmin ...
0
votes
1answer
63 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 ...
0
votes
0answers
69 views

Does SQLLocalDB ever require an internet connection?

Does SQLLocalDB ever require an internet connection? I have seem some very strange behavior on an end user PC. The computer is normally offline (and user wants it to be for security). They have small ...
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, ...
1
vote
1answer
39 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
308 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
130 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
199 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
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
20 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
893 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
364 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
67 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
48 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
162 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
40 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
22 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
476 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 ...
12
votes
1answer
10k 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
202 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
487 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
32 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
75 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
238 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 ...
2
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
271 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
82 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
487 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
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 ...
0
votes
1answer
1k 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
593 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
93 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
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 ...
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
922 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
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 ...
8
votes
1answer
751 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
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 ...
1
vote
1answer
677 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
518 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 ...