Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-2016]

The tag has no usage guidance.

0
votes
0answers
12 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
14 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
0answers
10 views

Installation of SQL version %ReqVer of the SQL server component is not allowed on Microsoft SQL 13

When installing SAP BPC 10.1 Microsoft version onto Windows Server 2016, utilising SQL Server 2016 SP2 on another server (also running Windows Server 2016), we are getting the error: Installation ...
0
votes
1answer
17 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
8 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
0answers
41 views

Connect google cloud storage bucket in MSSQL(2016)

I host a SQL Server Enterprise 2016 + Windows Server 2016 DataCenter on google compute engine. I'm going to use .bak file on my google cloud storage (GCS) bucket, to restore database on other folder ...
0
votes
0answers
36 views

MSSQL 2016 Peer to Peer Transactional Replication Broken because distributor cannot alter a system table in the subscriber's database

Our set up is 2016 SQL server and we are using P2P transactional replication among our four servers. Recently one of the servers is reporting that it is trying to apply command “if COLUMNPROPERTY(...
0
votes
0answers
9 views

Network disconnect between 2 DC's for SQL server

We are trying to resolve NW latency issue for one of our new build servers which is not yet live but migrated databases for testing in SQL2016 on windows 2016 with mirroring setup Instance A - Total ...
0
votes
1answer
46 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 ...
0
votes
0answers
5 views

Microsoft SQL Reporting Server - Run report if query has data (based on query)

I have a situation where I need to run a query every day to determine if something has been complete. If it is complete then my script will show results, if it's not complete then my script returns ...
0
votes
0answers
24 views

sql server 2016 create trigger to grant permissions to user

I'm trying to create a trigger that will grant alter permissions to the new user in a database. The trigger fires, but the error message received is "Could not find stored procedure 'GRANT ALTER ON ...
0
votes
0answers
75 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 ...
4
votes
1answer
115 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 ...
0
votes
0answers
25 views

Cloudflare Not Handling Internal Server HTTP 500 Error

I'm on Cloudflare's Pro Service. I've created a custom page for "Always On" and 500 Custom errors. However, when I mimic an error on the server creating a 500 error I see the server error message ...
0
votes
0answers
23 views

Requirements for Windows Server 2008 application to connect to SQL Server 2016

I have a legacy web server running Windows Server 2008 32-bit - it is not running 2008 R2. I plan on replacing it in 2019 with Windows Server 2016. But in the meantime I would like to move some SQL ...
1
vote
0answers
22 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
16 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
189 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 ...
8
votes
1answer
4k 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
0answers
94 views

SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher

Question: Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher? We have an SQL Server 2016 which is a slave ( ...
0
votes
1answer
114 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 ...
0
votes
0answers
24 views

Sql Server shows as running process but does not show in Services Panel

Yesterday I had remoted in to our hosted cloud server, Server 2016, and started an install for SQL Server Express 2016 Advanced. I experienced a power outage while the SQL setup was running on the ...
2
votes
2answers
232 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
26 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
58 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
531 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
2k 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
156 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
699 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
50 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
729 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
65 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
345 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
637 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
557 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
242 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
68 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
74 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
1k 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
703 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
0answers
561 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
3k 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
620 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
1k 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
333 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 ...
6
votes
2answers
232 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
86 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 ...