Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

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

Display data from On-premsies SQL Server table & from Azure SQL server inside SharePoint modern page

We have 2 SQL Server instances. One which is On-Premises & the other is inside Azure. now we need to have 2 web parts or 2 sections inside our SharePoint Online home page, to show data in tabular ...
user avatar
  • 948
0 votes
1 answer
59 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 &...
user avatar
0 votes
1 answer
49 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: ...
user avatar
0 votes
1 answer
24 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 ...
user avatar
0 votes
2 answers
57 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? ...
user avatar
  • 11
0 votes
1 answer
23 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: ...
user avatar
  • 1
0 votes
1 answer
46 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 ...
user avatar
0 votes
2 answers
42 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 ...
user avatar
0 votes
0 answers
81 views

User Profile Sync Service stuck on Starting / Looking for wrong

We have a SharePoint 2013 farm (1 SP server, 1 SQL server) where the User Profile Sync Service is stuck on the status "Starting". When going to the service's page it says "User Profile ...
user avatar
  • 435
0 votes
1 answer
56 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 ...
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 ...
user avatar
  • 101
0 votes
0 answers
26 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 ...
user avatar
0 votes
2 answers
81 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 ...
user avatar
0 votes
0 answers
22 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 ...
user avatar
  • 641
1 vote
2 answers
73 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 ...
user avatar
0 votes
1 answer
279 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 ...
user avatar
  • 1,051
0 votes
0 answers
69 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 ...
user avatar
0 votes
0 answers
29 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" ...
user avatar
0 votes
2 answers
90 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 ...
user avatar
0 votes
1 answer
139 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 ...
user avatar
0 votes
2 answers
485 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 ...
user avatar
  • 435
0 votes
1 answer
154 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 ...
user avatar
  • 87
2 votes
2 answers
1k 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 ...
user avatar
0 votes
2 answers
828 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 ...
user avatar
0 votes
1 answer
962 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-...
user avatar
0 votes
1 answer
14 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 ...
user avatar
0 votes
1 answer
651 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?
user avatar
1 vote
3 answers
66 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 ...
user avatar
0 votes
1 answer
19 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,...
user avatar
  • 1
0 votes
1 answer
34 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 ...
user avatar
  • 1,008
1 vote
1 answer
181 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 ...
user avatar
  • 485
1 vote
0 answers
117 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 ...
user avatar
  • 1,460
0 votes
0 answers
10 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 ...
user avatar
  • 7,930
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 ...
user avatar
0 votes
1 answer
81 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 ...
user avatar
0 votes
1 answer
21 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 ...
user avatar
  • 1
0 votes
1 answer
47 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 ...
user avatar
  • 7,930
1 vote
1 answer
55 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 ...
user avatar
  • 1,885
0 votes
1 answer
701 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 ...
user avatar
1 vote
1 answer
158 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 ...
user avatar
1 vote
1 answer
137 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 ...
user avatar
  • 285
0 votes
1 answer
739 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 ...
user avatar
0 votes
0 answers
86 views

Accessing Remote Blob Storage using SQL

In my SQL server database I have a table with "AllDocStreams" where in the field "Content" some documents are stored as BLOBS. However, some document entries do not have a "Content" entry but rather a ...
user avatar
0 votes
2 answers
38 views

Can I keep SQL Server and just restore Sharepoint to earlier time?

I have two separate VMs for sharepoint and SQL server. Unfortunately Sharepoint crashed and I couldn't repair it and just could restore a full OS backup (by Symantec System Recovery) for about one ...
user avatar
  • 1
0 votes
1 answer
347 views

SharePoint 2016 compatibility with SQL Server 2016 SP 2

Is SharePoint 2016 compatible with SQL Server 2016 SP 2 ?
user avatar
1 vote
1 answer
222 views

How can I create an ALIAS in SQL Server to SharePoint connect

I need to create the ALIAS SQL01-ST01\ST01 for a Sharepoint 2007 FARM to connect on standalone SQL Server 2008 R2 instance. In SQL Server Configuration Manager, I tried to create an alias, but I can ...
user avatar
  • 31
1 vote
1 answer
20 views

I am having an error in the event viewer multiple times

I am receiving below error in the event viewer multiple times: Unknown SQL Exception 10061 occurred. Additional error information from SQL Server is included below. A network-related or ...
user avatar
  • 631
1 vote
2 answers
608 views

How i can know the SQL service account for our sharepoint 2013 on-premises farm

To be able to run the BackUp-SPFarm i need to create a network location/drive and grant the sql service account read/write permission. but for our sharepoint on-premises 2013 /2016, how i can know ...
user avatar
2 votes
1 answer
95 views

Is there a way to tell if SharePoint was installed using a SQL Alias?

I know that a SQL Alias is listed now but I would like to find out if SharePoint was installed while specifying that alias during the install. On the 'Servers in Farm' page, I see both a SQL Alias ...
user avatar
0 votes
1 answer
111 views

InfoPath Data Connection Email

Working in InfoPath 2013. Background - I have a InfoPath form connected to a SP List. When the form is submitted an notification is sent. The notification email is sent from InfoPath that was ...
user avatar

1
2 3 4 5
10