Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2016]

63 questions
0
votes
1 answer

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 installed on the same server with about 4 GB RAM. …
Phil
  • 103
  • 3
0
votes
1 answer

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 SERVER 2016 (+ SSRS) The 2008 instance holds the data…
henda79
  • 151
  • 2
0
votes
1 answer

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 information in Technet / MSDN. The only information I was…
Ondrej Tucny
  • 404
  • 1
  • 7
  • 25
0
votes
1 answer

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 Server 2016, Microsoft Server Std. 2016
Jacob Evans
  • 7,886
  • 3
  • 29
  • 57
0
votes
1 answer

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 did not seem to get as far. I manually restarted…
tony09uk
  • 101
  • 2
0
votes
1 answer

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 is taking place. I have the full logs, but have…
AndyB
  • 1
  • 1
0
votes
1 answer

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. However, the alias disappeared. So I tried to…
Michael Barber
  • 165
  • 2
  • 3
  • 10
0
votes
1 answer

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 the event logs or sql server logs. Count anyone…
Exocomp
  • 163
  • 10
0
votes
1 answer

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 Server 2012 R2. To trigger the error: Connect to…
Roger M
  • 147
  • 16
0
votes
3 answers

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 this error when trying to restore a filestream…
user1751825
  • 365
  • 6
  • 13
0
votes
1 answer

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 update history is a list of these updates with a…
Sprintstar
  • 173
  • 1
  • 7
0
votes
1 answer

Login failed for user 'sc' even after creating user

I am trying to run a web application but I just cannot login with a user account (sc). I keep getting Login failed for user 'sc'. Description: An unhandled exception occurred during the execution of the current web request. Please review the…
Pirate X
  • 101
  • 3
0
votes
2 answers

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 exception and creates a memory dump. I can still…
Vjz
  • 1
  • 3
0
votes
2 answers

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 duplicate an instance of the application and this…
Daniel
  • 13
  • 6
0
votes
1 answer

?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
Moshe Harel
  • 1
  • 1
  • 1
1 2 3
4
5