Questions tagged [sql-server]
SQL Server is a relational database server used in SharePoint
502 questions
0votes
0answers
56views
SSRS - Unable to use "As the user viewing the report" for Data sources
Environment Description: SharePoint Subscription Edition Microsoft SQL Server 2022 + SSRS installed We have a site collection created, one of the feature is to use SSRS to generate report which ...
0votes
0answers
19views
SharePoint sites not working after database restore from Production to DR
What is the correct way to move sites from production to DR? I followed these steps but it didn't work. Took backup using Backup-SPSite on production Restored site on DR using Restore-SPSite and it ...
- 3,728
0votes
0answers
73views
Readable Secondary as Yes in AlwaysOn Availability Groups in SQL Server
What impact will have selecting Yes for Readable Secondary in AlwaysOn Availability Group? I have always used 'No' for Readable Secondary when setting AlwaysOn Availability Group. If I am setting up ...
- 3,728
0votes
1answer
36views
Does SharePoint store everything of a OneNote notebook in SQL?
Suppose I have a 20GB OneNote notebook hosted on SharePoint. Will all of this data be stored in the SQL database or is the SQL database only used for meta data? Background of my question is that I am ...
- 103
0votes
1answer
681views
Upgrading Sharepoint 2019 to Sharepoint Subscription Edition
I want to migrate sharepoint 2019 to sharepoint subscription edition. In the Microsoft documentation for database detach method of migration, it is written that all databases must be of version 16.0....
- 31
0votes
1answer
46views
UserProfile.RetrieveUser() Exception, Cannot continue the execution because the session is in the kill state
I am using following C# code to read user profile of users but getting error. Please ignore any syntax error in following code as I typed by hand here. Code using (SPSite site = new SPSite(SPContext....
- 3,728
1vote
1answer
332views
Moving an SQL database to SharePoint lists
I have been asked to move an internal resource management system from Java/SQL to PowerApps/SharePoint Lists and feel as though I am going around in circles at the moment as I have colleagues who are ...
0votes
1answer
97views
How to refresh excel file having an on-prem SQL data source every morning?
I have an Excel file on-prem with macros and connection to an on-prem SQL server. Every user has a copy of this file. When they open it or click on refresh then it fetched data from SQL data source. I'...
- 4,440
0votes
0answers
33views
Securing our SQL server database when using Power Apps
I have been building power apps with SharePoint. and i always secure the datasource. so for example if we have this case:- User submit a request the manager review the submitted request and can ...
0votes
2answers
99views
SharePoint 2013 Split Content database reached maximum threshhold
We have been experiencing slow response from SharePoint 2013 site collection, sometimes the http request timeout. The content database have exceeded the supported threshold from Microsoft of 4 TB, ...
0votes
1answer
803views
SharePoint 2016 On-Premise Configuring Database after Migration
I have SP2016 installed on my Windows Server with a Database on a separate server. I moved to new servers and after that the SP failed to start. So, I am having a new server holding SP apps on IIS, ...
0votes
1answer
512views
Using SQL Server 2022 with SharePoint 2013
Can we use SQL Server 2022 with SharePoint 2013. I am trying to find evaluation versions of old SQL Server such as 2008 R2, 2012 and 2014 but they are not available. Seems like Microsoft only keep ...
- 3,728
0votes
1answer
2kviews
Sync a Sql Server Table with a SharePoint list
Is there a way to automatically sync a Sql Server Table with a SharePoint list? (Sql as source and SharePoint as destination). I tried to connect MS Acces to a SharePoint list as source and seem to ...
- 133
0votes
1answer
356views
How to display image in Sharepoint List from SQL Server
I have the following problem when I want to display an image in a column of type "Hyperlink or Picture" of Sharepoint List, the image comes from a column in a SQL Server table of data type &...
- 53
0votes
1answer
2kviews
Cannot Connect to Database Master at SQL Server - SharePoint 2019
I have a following setup: subnet is the same, two separate VMs First server has SQL Server 2017 RTM Second server has SharePoint 2019 Enterprise After installing SharePoint, I get the following error: ...
