Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

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

Move SharePoint 2019 into new setup

I have a new client with a unstable SharePoint setup. It is a two tier setup, web and app on one server and the SQL on another. The SharePoint services like e.g. User profile sync and Managed ...
Hes JvR's user avatar
  • 89
0 votes
1 answer
24 views

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 ...
divB's user avatar
  • 103
0 votes
0 answers
25 views

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....
Noorul's user avatar
  • 31
0 votes
1 answer
10 views

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....
Frank Martin's user avatar
  • 3,668
0 votes
0 answers
12 views

I'm searching for SharePoint farm planning tool

Is there any tool that can help me design my farm building plan. For example, I can give number of users and it can show me how many server I will need to use in my farm and if anyone access on ...
wael elkadi's user avatar
1 vote
1 answer
58 views

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 ...
crazybeckster's user avatar
0 votes
1 answer
77 views

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'...
variable's user avatar
  • 4,470
0 votes
0 answers
27 views

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 ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
50 views

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, ...
taps bops's user avatar
0 votes
1 answer
410 views

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, ...
Mohammed Abed's user avatar
0 votes
1 answer
346 views

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 ...
Frank Martin's user avatar
  • 3,668
0 votes
1 answer
1k views

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 ...
serge's user avatar
  • 133
0 votes
1 answer
290 views

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 &...
John Doe's user avatar
0 votes
1 answer
995 views

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: ...
tuljko188's user avatar
0 votes
1 answer
338 views

Get data from SharePoint List and SQL Table - compare them - PowerShell

I want to make a script which will get data from SharePoint list (from a specific column) and also get data from SQL table (from a specific column) and compare them. If the comparison value is true ...
jck4real's user avatar
0 votes
2 answers
558 views

Migrate On Premise SQL Server data to SharePoint Online

We have one site in which external content types are set up and data is stored in SQL Server On premise. Now we want that site to be migrated to SPO. What is the best way to have this set up in SPO? ...
Adarsh's user avatar
  • 31
0 votes
1 answer
193 views

How to know if SQL alias is used or Server is used in sharepoint if both are same

I have a situation where SQL server name is SQLABC and SQLAlias is configured on SharePoint server with same name SQLABC. So in Cliconfig.exe we see below in the fields: SQL Alias: SQLABC Server Name: ...
Amit's user avatar
  • 1
0 votes
1 answer
329 views

Block access between SharePoint Web Front and Servers and Database only allow WFE to Application Server access

I am a developer with limited knowledge of SharePoint Administration. We have a SharePoint 2019 multi-tier farm. 1 App with Central Admin 1 App with Search 1 F5 Firewall between App and Web Servers 2 ...
MMUNEEBALI's user avatar
0 votes
2 answers
378 views

New SharePoint 2010 install Error - Failed on SQL 2008 Native Client

I'm undertaking a new installed to replicates and excising infrastructure to test updating to new SharePoint server e.g. 2016, etc. When I try and install SharePoint 2010 Foundation on a windows ...
ShareWithMe's user avatar
0 votes
1 answer
250 views

Move documents from SQL database to file system

I have a SQL database server for the SharePoint 2013 on-premise site. The amount of BLOB data is huge which is slowing down the SQL server and hampering system's performance. I want to migrate and ...
Tafsir Ahamed's user avatar
0 votes
1 answer
21 views

Automatic task creation based on database condition

I am new to sharepoint and am having a difficult time on where to start on this one. I have a database of values(outside of sharepoint). I wish to check this database each day and if one of the values ...
Pearl's user avatar
  • 101
0 votes
0 answers
27 views

Query sharepoint list data in sql server [duplicate]

I am trying to query sharepoint lists data with sql server,for performance reasons. Is there any tool to help me do this? I heard about spud and SPViews but i am searching for something open source or ...
Ali Haddani's user avatar
0 votes
2 answers
174 views

Installing SharePoint in a different domain than SQL

There are two domains, DomainA and DomainB in my environment. Is it possible that i can install SharePoint in DomainA and SQL server in DomainB without having the trust relationship between both ...
Chillax Designs's user avatar
0 votes
0 answers
37 views

This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server toread from the conf db

I am getting this error when i try to open our websites. Also we checked sql connection and passwords/usernames I can connect to sql with this user and i can execute a query and select on db and ...
f_gulay's user avatar
  • 641
1 vote
2 answers
264 views

SharePoint 2019 - MSSQL 2019 configuration to protect DB's (Basic Availability Groups)

I'm searching for advise with SharePoint database when using Always On availability group. I have MSSQL server with 2019 Standard version and SharePoint 2019 Standard license. I wanna protect my DBs ...
Rademenes's user avatar
0 votes
1 answer
813 views

How do I connect to an Azure SQL Server database programmatically from SharePoint Online?

I am migrating several on-premises websites to Azure, I can choose either SharePoint 2019 hosted on PaaS, or SharePoint Online as SaaS. I have external SQL Server databases that must remain in SQL ...
CigarDoug's user avatar
  • 1,063
0 votes
0 answers
187 views

Database Failover not happening for Sharepoint 2016

I have a Sharepoint 2016 farm with shared roles in the following configuration. 2 X Web Front End Servers with Distributed Cache 2 X Application Servers with Search 1 X Domain Controller 2 X SQL ...
Pankaj Dalvi's user avatar
0 votes
0 answers
38 views

SP2007 (All)UserData nvarchar field content garbled for choice fields

In our SharePoint 2007, one of our lists field is configured as such: <Field Type="Choice" DisplayName="Standard" Required="FALSE" Format="RadioButtons" ...
Jean-Sébastien Petit's user avatar
0 votes
2 answers
371 views

Sharepoint 2016 not able to connect to database intermittently

I have a Sharepoint 2016 Farm configured with Shared Roles. Below is the Configuration details. 2 X Web Front End Servers with Distributed Cache 2 X Application Servers with Search 1 X Domain ...
Pankaj Dalvi's user avatar
0 votes
1 answer
378 views

Is SharePoint 2016 & SharePoint 2019 supports SQL Server 2017 developer edition as backend SQL Server

I have a plan to upgrade our SharePoint 2013 web application to SharePoint 2019 for this task now I am preparing Test Environment for SharePoint 2016 & SharePoint 2019 before that I want to clear ...
user3520155's user avatar
0 votes
3 answers
2k views

Why is SharePoint 2016 PSCONFIG Upgrade Failing with User Does Not Have Permissions?

I receive the following error during PSCONFIG upgrade: Failed to upgrade SharePoint Products. This is a critical task. You have to fix the failures before you can continue. Follow this link for more ...
C1TonyB's user avatar
  • 435
0 votes
1 answer
232 views

Update Azure SQL Managed Instance sql account in SharePoint

I completed setting up SharePoint 2019 using Azure SQL MI, as you would know MI does not accept service account and have to connect to SharePoint using a local sql account. Now the issue I'm facing is ...
dkorra's user avatar
  • 87
2 votes
2 answers
2k views

How do I set up SharePoint Server with an Azure SQL Database Server?

I am trying to create a SharePoint Server environment. I have an Azure subscription, so I created a Windows Server 2019 virtual machine and set up Active Directory. I also created an Azure SQL ...
Ralph Greene's user avatar
0 votes
2 answers
2k views

Getting SharePoint List data into a SQL Server table from URL

I have been hitting dead ends when trying to pull SharePoint List data into SQL Server. The goal is to query the data so I am able to use it in a Tableau dashboard. The reason we have to do it this ...
Mike - SMT's user avatar
0 votes
1 answer
1k views

Connect excel file in Excel Web in Sharepoint to external SQL server

It is the first time that I am using the web version of excel with external data sources on Sharepoint so I hope that you can help my with that. I do have an Excel list that grabs data from an on-...
Benedikt W's user avatar
0 votes
1 answer
22 views

SQLServer.exe utilizes almost 95% of the RAM in SharePoint farm based SQL Server

We have a single Server dedicated for SQL DB in our sharepoint farm. Now I do see the task manager of the DB Server regularly and find day by day the RAM utilization is increasing upto 95% by only ...
Kailash Sahoo's user avatar
0 votes
1 answer
885 views

Is it possible to pull on- premises SQL server data into SharePoint page using spfx

I have a requirement like , have to pull on-premises SQL server data in to SharePoint online page using spfx without importing into the SP list?
user2915027's user avatar
1 vote
3 answers
101 views

Storing data to a separate SQL database instead of content database

Our team is planning to move away from storing to SharePoint content database and save the data instead to an own designed SQL database. The goal is to use SharePoint just as an interface. My task is ...
Eliya Amanoeel's user avatar
0 votes
1 answer
31 views

Optimal Infopath SQL integration

What is the optimal implementation if I need an application using Infopath to create forms to store data into SQL Server. And querying that database with perhaps Stored Procedures to show information,...
FcoLG's user avatar
  • 1
0 votes
1 answer
62 views

Set Simple recovery model before shrinking SharePoint database

I read several articles recommending switching to Simple recovery model before shrinking dbs. Here, here and here. Please explain me - Why it is needed. I also read the white paper about Maintenance ...
Raf's user avatar
  • 1,038
1 vote
1 answer
372 views

Save data from SharePoint Online to SQL Table [closed]

I have created one html "User Detail" Form. Using content editor web part, add this form into SharePoint page(web part page / wiki page). "User Detail" form contain Button(Save/Submit) for store ...
Chandresh's user avatar
  • 499
1 vote
0 answers
234 views

Updating SharePoint User Profile Picture

I have a SP 2013 Production on premise environment where the users are not allowed to update their User profile pictures. User pictures are updated in a different application and image files are ...
George's user avatar
  • 1,522
0 votes
0 answers
20 views

Prevent writes from primary farm to DR database after failover?

I have two SharePoint farms, an active and a DR farm, using SQL Availability groups to sync content and some service DBs. In the event of a manual failover, how do I prevent the primary farm from ...
Mike2500's user avatar
  • 8,060
1 vote
0 answers
22 views

Connecting User ID to Search Report Results

SharePoint 2013 allows the search reports to be pulled from site collection level by month and day. The report is helpful but I want to know who did the search. The report seems inaccurate because ...
SharePoint Lady's user avatar
0 votes
1 answer
380 views

On-prem SharePoint 2016 trying to talk to a database that doesn't exist

My Sharepoint 2016 server is acting flakey and constantly requiring a reboot of my database server. I have a bunch of critical Database and Timer errors on the SharePoint server which are: Database ...
bulltorious's user avatar
0 votes
1 answer
22 views

Using MSSQL server freeware with Sharepoint

i recently downloaded Windows Server 2016 and sharepoint 2013, and then i went on to download SQLServer Express. Here is what i want to know. Can i use the freeware version of SQL Server together with ...
Jack's user avatar
  • 1
0 votes
1 answer
90 views

Combining HA and DR

The best guidance I've found is this, though I'm having difficulty understanding some aspects of it. A summary of the advice is to create farms such as: farm 1: Availability Group 1 with Config ...
Mike2500's user avatar
  • 8,060
1 vote
1 answer
67 views

uninstall SQL server 2008 r2 from SharePoint 2013 server

We have installed SharePoint 2013 on a server and one of the SQL engineers has also installed SQL server 2008 r2 on the same server where SharePoint is installed. ?Though that SQL server is not ...
Achiever SP's user avatar
  • 1,915
0 votes
1 answer
1k views

Does SharePoint use the FILESTREAM data type to store videos in SQL Server?

Our IT department is firm on storing photos and videos in a file server citing issues with SQL server handling this type of content. This is creating issues for users as uploading and referring to ...
Martin Muldoon's user avatar
1 vote
2 answers
348 views

Low free space on a SharePoint Content DB

We have to upload up to 133 video files to a SharePoint 2016 Site but there is a very low free space in the content DB. There are multiple sites for the same content DB but only 1 site collection is ...
Sean Driver's user avatar

1
2 3 4 5
11