Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

Filter by
Sorted by
Tagged with
1
vote
1answer
22 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 ...
0
votes
1answer
26 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 ...
1
vote
1answer
19 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 ...
0
votes
1answer
16 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 ...
0
votes
1answer
23 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 ...
0
votes
0answers
25 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 ...
0
votes
2answers
26 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 ...
0
votes
0answers
19 views

SharePoint external list with SQL server trigger

Does SharePoint external support SQL trigger function? After adding update trigger function, my existing external list got this error: Failed to update a list item for this external list based on ...
0
votes
1answer
27 views

SharePoint 2016 compatibility with SQL Server 2016 SP 2

Is SharePoint 2016 compatible with SQL Server 2016 SP 2 ?
1
vote
1answer
27 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 ...
0
votes
0answers
7 views

RBS rollback step on SharePoint 2010 comes too long

We are migrating SharePoint from 2010 to 2016. One of steps of the migration is RBS rollback (as you know, we can't upgrade SPContentDB until we have switched off a remote blob storage on that DB) and ...
0
votes
0answers
20 views

The requested Data Feed could not be found (rrDataFeedNotFound)

we have couple of rdl files with data alerts in SharePoint from past week we are getting status as The requested Data Feed could not be found (rrDataFeedNotFound)The log file contains detailed ...
1
vote
1answer
16 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 ...
1
vote
2answers
56 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 ...
2
votes
1answer
20 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 ...
0
votes
1answer
25 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 ...
2
votes
2answers
26 views

Is changing sharepoint registry values supported?

we are required to add the attribute 'Encrypt=true' in connection string for enabling SSL connection to SQL DB. Can we change this in connection string through registry settings under this location? ...
3
votes
1answer
28 views

What negative impact can occur if I detach a Sharepoint content database file location via SQL?

The end goal is to move the MDF file of a non-critical Sharepoint site collection to a different drive. The database server/name/etc... is going to be unchanged. Microsoft basically states that the ...
3
votes
2answers
573 views

Database server for SharePoint 2019

Can we use sql server 2016 with service pack 2 for SharePoint 2019?
0
votes
2answers
233 views

Sharepoint 2013 - Workflow suddenly stopped working

I have a custom workflow which has suddenly failed. The workflow sends an email, copies the form list to another forms list and then deletes the original form list. I have read it may be a sql ...
0
votes
2answers
54 views

SharePoint Database Compatibility mode After Upgrade - What is the Best Practice?

I upgraded a SharePoint Site Collection DB from SQL 2012/SharePoint 2013 to SQL 2016/SharePoint 2016. Compatibility mode still shows 2012. Should I change compatibility mode to SQL 2016 and run ...
0
votes
1answer
36 views

SharePoint 2016: Move all farm databases from a SQL Server 2016 Standard to SQL Server 2016 Developer Edition

First time doing this and I would like to confirm the procedure to follow. This is a MinRole farm with 1 Application with Search server and one Front-End with Distributed Cache server. I've been asked ...
1
vote
2answers
22 views

SharePoint Content Database on a non-SharePoint configured Database

Is it advisable to have a SharePoint Content Database on a SQL Database Server that is not specific for SharePoint?
1
vote
1answer
75 views

Cannot connect to SQL Server. domain\sqlservername not found. Additional error information from SQL Server is included below

I get the above error on my server manager where SharePoint (2016 on prem) is running: (SQL 2014 and SP 2016 running on same server Windows 2012 R2) Connection Timeout Expired. The timeout period ...
3
votes
1answer
57 views

SharePoint memory settings

I am gonna build a new SharePoint 2016 farm, 2 web and app servers 2 DB servers cluster What's the setting required for SQL memory in management studio?
1
vote
2answers
32 views

Use SharePoint database backups and restore on new site

I suspect my client's SharePoint site is 'corrupt'. Some links give "File not found" for example when going to a certain sub site's settings. They have SharePoint 2016 with SQL 2014 on Windows 2012 ...
0
votes
1answer
252 views

Hybrid solution - SharePoint online and SQL on-prem

My client have some PII data in their on-premise SQL DB. They have only O365 SharePoint Online, they don't want to have data inside SP as list and library since their site is cloud. want to use same ...
1
vote
1answer
124 views

SharePoint Online Azure SQL Database External Content List Error

I have an Azure SQL database created. I also have fallowed the steps listed hereExternal List from a SQL Azure table with Business Connectivity I have also created an external list on my SPO site. ...
0
votes
1answer
52 views

Move all SharePoint Databases to new SQL Server

SharePoint databases are running in a instance SP16 on Microsoft SQL Server 2016 (SP1) on a Windows Server 2012 R2 Datacenter at the moment. SharePoint is installed with 4 machine MinRole WFE-APP-...
2
votes
2answers
234 views

How to Query a SharePoint list in Office 365

I am moving the company SharePoint site from SP 2010 on premises to online 365. I have a website for the vocations office here in our diocese which has a calendar. To update the calendar I enter the ...
1
vote
1answer
79 views

SharePoint Central Administration and SharePoint Web site not working

I am using SharePoint Foundation 2010. I have it installed and ran the Configuration tool. Everything finished fine. This is on a Windows Server 2016 Standard with SQL Server 2008 Express When I ...
1
vote
1answer
280 views

Database login errors in SharePoint event viewer

We are seeing the below error message in SharePoint server event viewer frequently. "Event ID: 3355 Cannot connect to SQL Server - "ServerName" not found. Additional error information from SQL ...
1
vote
1answer
54 views

SharePoint Database Backup Failure on SqL Server

We do have two DB and two Application servers for high availability purpose . Regarding SQL Server: We have full and transaction log Backup . We created a high availability group and define the two ...
0
votes
1answer
330 views

Connecting on-promise database to SharePoint online

We have some SQL view on-promise server, we would like to display this data on the SharePoint online. Normally once we need to connect to this database from different network, VPN connection is ...
1
vote
2answers
687 views

Cannot access any SharePoint sites and Central Administration

I am running SharePoint Server 2016 on two separate servers: one application server and one database server. I have created a number of sites in a site-collection. Recently today, I am not able to ...
0
votes
1answer
290 views

C# export list items to data table? change date time

I'm doing an export to a table from the SharePoint list, I do not understand why the date changes when unloading into a table, tell me what's wrong with my code? public void SPExportCalendar() { ...
1
vote
3answers
81 views

Use compression during Database backup

In some circumstances, we can use compression to decrease the size of backups and the time to complete each backup. I use following command to restore site. Mount-SPContentDatabase "MyDatabase" -...
0
votes
1answer
78 views

SharePoint 2016 with SQL Server 2008R2

I fully understand that SharePoint 2016 DBs must be on SQL SERVER 2016+. My question is NOT related to SharePoint databases (DBs SharePoint uses to manage the site). However, my environment has many ...
0
votes
1answer
166 views

How to add new user as farm admin without powershell without central admin and without sql server

As we don't have the credentials to central admin, sql server whenever facing problem related to jobs and user profile service unable to do anything. Currently the issue is every 1 min the support ...
0
votes
1answer
38 views

How to implement Auto-fill behavior for search in custom Web Part in SharePoint

I am trying to implement Auto-fill behavior for search in custom Web Part in SharePoint here I have to read data either from SharePoint list or SQL Server database table. Here I can implement these ...
0
votes
1answer
106 views

how to check if SharePoint content databases are corrupt?

I have SharePoint 2010 and would like to check if the databases are corrupt or not. Can someone tell me how can I do that either via powershell or T-SQL without making any modifications to the ...
2
votes
1answer
19 views

Virtualizing Highly Available SQL Server database on SharePoint

I am planning on virtualizing my SharePoint environment. So, I am thinking on virtualizing all the roles (Application Server, Frontend, ...) including the Database. My question is: is it recommended ...
0
votes
2answers
1k views

Find saved data of SharePoint list in SQL Server

Could you please halp my find saved data of SharePoint list in SQL Server? Where is Sharepoint list data stored in SQL Server Thanks in advance! Have a greate day!
1
vote
0answers
94 views

Accessing SharePoint online data in SQL server using Odata feed

I tried accessing data from SharePoint's project web app using admin account(with full control) in excel using Odata feed. I was successful. But when I tried to replicate the same thing with Sql ...
1
vote
2answers
37 views

Deleted a Service Application did not remove the database in SQL HA

We are new to SQL HA and have the SharePoint Service Databases (Except Usage & Health) in a SQL HA Availability Group and they are Synchronized. I went to remove the Machine Translation Database ...
0
votes
1answer
174 views

Moving Content database's from SharePoint 2010 to Azure Blob Storage

I am working on approaches for moving Content databases from SP 2010 to Azure Blob Storage. Its a lift and shift from SP 2010 to SP 2016 in Azure (eventually). At the moment the content databases ...
5
votes
2answers
2k views

Does SharePoint 2013 supports sql server 2016 or not

we need to do upgrade SharePoint 2010 farm to SharePoint 2013, Does SharePoint 2013 supports SQL Server 2016 or not? or we can go for Server 2014?
1
vote
1answer
274 views

Crawling data from external database

I need to crawl data from SQL Server Database. For this, I created an external list using Business Connectivity Services. However, I encountered a limit on the number of requested rows: my table ...
0
votes
1answer
40 views

Getting “Error on executing: Secure Store can only be used with SharePoint Server.” on a SP2013 list workflow on my SP Server farm

I have a SP workflow that runs on creation/modification of a list item. The workflow connects to an SQL Server db and executes a usp. The SQL Server credentials are stored in Secure Store. When the ...
2
votes
2answers
494 views

Can there be two SharePoint 2016 Farms on same SQL Server?

Can there be two SharePoint 2016 Farms on same SQL Server? If we are planning so, what are the dos and donts ?