Questions tagged [sql-server]
SQL Server is a relational database server used in SharePoint
499
questions
1
vote
1
answer
43
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 ...
0
votes
1
answer
17
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'...
- 4,456
0
votes
0
answers
26
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 ...
0
votes
0
answers
13
views
How do I set up a SharePoint 2016 farm to work with AOAG?
My college and I have successfully set up AOAG groups on MS SQL 2019 Server, but when we try using failover with SharePoint 2016, SharePoint stops working.
We've hade issues finding a complete ...
- 111
0
votes
0
answers
29
views
SQL Alias Works on One Server, Not Another
I have SQL aliases setup identically on two different client (SharePoint) servers. On one server, everything works fine. On the other server, I get an error from SSMS that says "A network-...
- 65
0
votes
2
answers
29
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, ...
- 23
0
votes
1
answer
171
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, ...
0
votes
1
answer
192
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 ...
- 3,646
0
votes
0
answers
21
views
Design the Backed when using SQL Server Vs using SharePoint Online
We want to build a document management system where each document will have the following properties:-
ID - system generated
version - system generated
Revision- only user with PM role can modify it (...
0
votes
1
answer
674
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 ...
- 121
0
votes
1
answer
245
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 &...
- 53
0
votes
1
answer
601
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:
...
0
votes
1
answer
271
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 ...
- 1
0
votes
2
answers
412
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? ...
- 31
0
votes
1
answer
137
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: ...
- 1
0
votes
1
answer
209
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 ...
- 33
0
votes
2
answers
271
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 ...
0
votes
1
answer
155
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 ...
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 ...
- 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 ...
0
votes
2
answers
150
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 ...
- 180
0
votes
0
answers
33
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 ...
- 641
1
vote
2
answers
188
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 ...
- 11
0
votes
1
answer
666
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 ...
- 1,063
0
votes
0
answers
153
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 ...
- 43
0
votes
0
answers
35
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" ...
0
votes
2
answers
201
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 ...
- 43
0
votes
1
answer
295
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 ...
- 147
0
votes
3
answers
1k
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 ...
- 435
0
votes
1
answer
198
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 ...
- 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 ...
- 21
0
votes
2
answers
1k
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 ...
- 51
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-...
0
votes
1
answer
15
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 ...
- 467
0
votes
1
answer
820
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?
- 169
1
vote
3
answers
89
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 ...
- 643
0
votes
1
answer
24
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,...
- 1
0
votes
1
answer
45
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 ...
- 1,018
1
vote
1
answer
300
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 ...
- 497
1
vote
0
answers
191
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 ...
- 1,502
0
votes
0
answers
17
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 ...
- 8,020
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 ...
- 1,443
0
votes
1
answer
211
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 ...
- 107
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 ...
- 1
0
votes
1
answer
72
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 ...
- 8,020
1
vote
1
answer
65
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 ...
- 1,885
0
votes
1
answer
938
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 ...
- 930
1
vote
2
answers
272
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 ...
- 11
1
vote
1
answer
183
views
Need SQL statement to get contentdbid
Looking for the SQL statement to retrieve the content db id of WSS_Content (only available at the SQL level). In what table is this id stored?
when I ran cmdlet Get-SPContentDatabase for a list of ...
- 295
0
votes
1
answer
873
views
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
I want to Backup/Restore our managed metadata managed service's database from live to test which are both sharepoint 2013 farms. So i did these steps:-
1- Inside the live database i select the related ...