Questions tagged [sql-server-2016]

For issues pertaining to SQL Server 2016 or when an error occurred in SQL Server 2016.

Filter by
Sorted by
Tagged with
1 vote
1 answer
573 views

Subscription Settings Service Application stuck on starting in SharePoint Server 2016

I am deploying a solution to a client's SharePoint Server 2016 site. Whenever I deploy, Visual Studio returns the following error. Details in my Output window are as below; ------ Build started: ...
Collin T's user avatar
0 votes
1 answer
94 views

SharePoint High Trust Application - stopped being trusted - 401

We've got a high trust application which ok, in the mornings seem to 'not work' but then after the first hour was fine. But now it just blankly doesn't work with the non helpful. System.Net....
Richard   Housham's user avatar
0 votes
2 answers
119 views

SharePoint 2013 on Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 Working fine

I installed SharePoint 2013 on below SQL Server 2016 Version and its working fine Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) Sep 13 2018 22:16:01 Copyright (c) Microsoft ...
user3520155's user avatar
1 vote
1 answer
1k views

SSRS 2016 native mode fail to connect SharePoint list datasource

We are using SP2016 with SQL 2016 standard (13.0.5026.0 SQL Server 2016 Service Pack 2 (SP2)). SSRS feature is enabled in SQL server and service started. I am able to browse the SSRS portal with http:/...
Mark L's user avatar
  • 4,065
0 votes
1 answer
445 views

Install SSRS SP mode after SP2016 is setup not working

We are using SP2016 on-premise with SQL 2016 enterprise edition. After everything is setup we realize we also require SQL Reporting service enable on the farm. Hence, on our application server we ...
Mark L's user avatar
  • 4,065
2 votes
1 answer
1k views

Restore-SPSite : The Web application at http://site/ could not be found

On my newly created SharePoint 2016 development server, I have one web application which currently stores our production server intranet backup. Now I want to take the backup of this dev WA site and ...
Rishi Jagati's user avatar
2 votes
1 answer
44 views

SharePoint using SQL Report Server Manager outside of SharePoint farm

Can we have SharePoint use SQL Report Server which is already set up outside of SharePoint Farm? The SQL Server which would be having this SQL Report Server Manager will not have Configuration ...
Zakir HC's user avatar
  • 3,650
1 vote
1 answer
1k views

Sharepoint 2016: failed to create configuration database although necessary database permissions set

I am running Sharepoint 2016 on a domain controller, running Windows Server 2012 R2. It is running in a development environment as a single-server with SQL Server 2016. I have installed Sharepoint ...
synthesis's user avatar
  • 103
1 vote
0 answers
74 views

Do SharePoint 2016 servers have to be members of the same domain as SQL Server (w/replication)?

Scenario: The environment includes two domains, A and B. Appropriate trusts have been configured between the domains. A 4 server SharePoint 2016 farm as been configured, each server is a member of ...
Eric Bowden's user avatar
0 votes
1 answer
28 views

Sharepoint Server Farm Project - Where do I start?

I am doing a class project where we are deploying Sharepoint on a server farm technically(Virtual Machines). It will be used to have an IT ticketing system. One of us is doing SQL, one of us is doing ...
Chazman17's user avatar
2 votes
0 answers
189 views

Support for SQL Server 2016 Query Store on a SharePoint Database

SQL Server 2016 has a new performance tuning feature Query Store. Query Store must be enabled at database level. All Query Store information will be stored in the primary filegroup of the database. ...
MHeld's user avatar
  • 5,133