Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

0
votes
0answers
13 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 ...
0
votes
0answers
6 views

external list in Sharepoint filter on workEmail with no unique ID

I have a question about external lists in Sharepoint, I'm using SQL server in azure and Sharepoint online. In school I want to make a Sharepoint page for parents where they can see and edit data only ...
1
vote
1answer
14 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
37 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
24 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
25 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
23 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
249 views

Database server for SharePoint 2019

Can we use sql server 2016 with service pack 2 for SharePoint 2019?
0
votes
2answers
139 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
31 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
31 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
21 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
57 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
44 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
147 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
93 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
45 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
164 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
61 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
205 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
46 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
0answers
41 views

InfoPath SQL Connection question

I have a form where I am connecting to a SQL Server to pull Vendor Data based on PO's, which will then connect to another SQL Table and pull the Vendor Name. Here is the Code I have: shape {...
0
votes
1answer
267 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
565 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
179 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
71 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
71 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
144 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
37 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
74 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
17 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
717 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
88 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
33 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
147 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 ...
4
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
229 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
37 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
393 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 ?
1
vote
1answer
2k views

Is SharePoint 2010 supported on SQL server 2012 SP2

Is SharePoint 2010 supported on SQL server 2012 SP2? Thanks...
0
votes
1answer
202 views

Is SQL Server 2008 R2 SP3 compatible with SharePoint 2010?

Is SQL Server 2008 R2 SP3 compatible with SharePoint 2010? Does SharePoint Server needs any additional CUs\SPs to be installed to be in compatible with SQL Server 2008 R2 SP3
1
vote
1answer
33 views

Find the missing records in a SQL table based on Order Number

I have a custom database which stores Orders details in Order table. I have a SharePoint list which stores same Orders details as well. I would like to, get Order number from SharePoint List and ...
1
vote
0answers
173 views

Sharepoint 2013 running ultra slow

Any help appreciated. We have a single farm SharePoint 2013 environment. We have had issues intermittently with ultra-slowness. Previously the issue was the crawl configuration which is now sorted ...
2
votes
0answers
417 views

Connect On-Premise Database to Sharepoint Online

I have a SQL table in SQL Server Management Studio that I want to set up as an external content type in Sharepoint Online. I've used Sharepoint Designer 2013 to create it, and the link works fine in ...
0
votes
1answer
77 views

SP task list data push to SQL

What is my option so my sp task list still push the data to our sql database using the datasheet view? I was told that adding new item to the list triggers an event handler which uploads the data from ...
0
votes
1answer
182 views

MAXDOP with Database Scoped Configuration on SQL 2016

It's a requirement to install SharePoint 2016 with a SQL Server that has MAXDOP=1. It's long been a best practice to configure SharePoint with its own SQL instance, and this is certainly one reason ...
1
vote
1answer
25 views

Can OS of the servers hosting SharePoint and OS of the Server hosting SQL be different?

Can Operating System of the servers hosting SharePoint and operating system of the Server hosting SQL be different? For example: Windows 2008 R2 - SharePoint Hosted Servers Windows 2012 - SQL ...
1
vote
1answer
674 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' despite User ID in the connection string

I have a visual web part that is calling a database. I’m using a connection string that passes through a SQL account and password to access the DB. This works when trying to access a DB on the same ...