Questions tagged [sql]

SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

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

Search Topology - too many databases and one corrupt

Our organization was having an issue with our Search Service App on our SharePoint 2016 On-Prem environment. Once we got it working properly, we noticed that there were 3 sets of topology component ...
1
vote
1answer
814 views

List view threshold - over 100,000 items in library

I have a query about the List view threshold on SharePoint 2013 where the limit is set to 5000 items in Central Administration. We have a document library with 150,000+ items which means currently we ...
1
vote
2answers
4k views

How can I run REST from batch or powershell?

I want to create an item (Title,ID, description) in Mylist by using REST/batch/powershell/SQL store procedure Any reference or information will be appreciated.
0
votes
1answer
14 views

Downgrade the sql server version in sharepoint server

Need urgent help. I have installed sharepoint server 2019 with sql server 2016 enterprise edition. clients were using it. Evaluation period is over and site is not opening now. How easy it will be ...
0
votes
1answer
739 views

SSRS bar-chart do not show the x-axis name when value is zero

We have a Dashboard implemented by SSRS in SharePoint 2010 and data source is a SharePoint list. We have a bar table in which the x-axis is month but when data is zero it doesn't show the month name ...
0
votes
1answer
806 views

insert value from sharepoint list to SQL table

I have list with approx 20000 items, and want to push that into sql table. Can anyone help me with c# code. Thanks
0
votes
1answer
885 views

Upgrade SQL Server 2012 to 2014 or 2016 for Sharepoint Server 2016 instance

I have a Windows Server 2012 R2 with Sharepoint Server 2016 installed but the SQL server version is 2012. What do I need to do to upgrade the database to 2014 or 2016. Everything is installed in the ...
0
votes
1answer
801 views

Limits of Running Foundation, Server 2012, SQL 2012 Express

What are some of the major limitations of using SharePoint Foundation 2013, it's compatibility with Server 2012 Standard, and the limitations of SQL 2012 Express?
0
votes
1answer
12 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,...
0
votes
1answer
653 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
1
vote
1answer
916 views

Sharepoint Hosted Add-In using External SQL Database

As in the title, I would like to create a Sharepoint hosted add-in that accesses data from an SQL database on my companies database. Is there any way to do this? Thank you!
0
votes
1answer
23 views

rbs(remote blob storage) wont disable

target is to upgrade sharepoint 2013 to 2016. i have backed up the contentDB and restore it it will mount in new web app in 2016 farm but there s some problem: first. it kinda seem like it mounted ...
3
votes
1answer
11k views

Updating a SharePoint list via an Access query and VBA code exhausts system resources

My apologies: I asked this on StackOverflow already but have received no responses. I am hoping that reposting on a site more oriented to SharePoint might lead to more insight. For reasons beyond my ...
0
votes
0answers
26 views

Don't get records in PowerApp from stored procedure

I am using stored procedure by following https://baizini-it.com/blog/index.php/2018/05/10/powerapps-concurrently-returning-variables-and-multiple-arrays-from-azure-sql-database/ link to get records in ...
1
vote
4answers
2k views

SP 2013 How to create new FBA sql users with PowerShell?

I set up SharePoint 2013 with FBA users (SQL). I'd like to know if it's possible to create new users using PowerShell script ? What I tried but did not work : [System.AppDomain]::CurrentDomain....
1
vote
4answers
97 views

Join SharePoint lists using a a SQL like SELECT statement

I'm trying to figure way to join SharePoint lists using a a SQL like SELECT statement. I have the following tables: [customer details] [customer notes] [customer reviews] all these have a common ...
0
votes
1answer
28 views

WebDAV issues since moving SQL instance

We are currently running a SharePoint 2013 farm on-site, and one of our intranet sites is used for file storage & collaboration. For one specific business case, users use a mapped drive to quickly ...
0
votes
3answers
37 views

Set Up 3 Tier SP 2016 farm in AWS

I'm currently creating a 3 tier SP 2016 farm in AWS. I was updated that AWS doesn't have SQL Servers and SQL is managed by RDS Engine. I was given a SQL endpoint string instead of SQL server name. ...
0
votes
1answer
34 views

Starting SharePoint Approval Workflow With Data in SQL

I am working on automating a license process fro my organization. With asp.net I am able to create a WebPart that submits data to a database in SQL. Now what I want to do is to initiate the approval ...
0
votes
0answers
26 views

SQL Server Reporting Services Report Viewer - Error Message

We are trying to add the SQL Server Reporting Services Report Viewer webpart to a page, but get the following error: "An error occurred during local report processing. For more information about this ...
1
vote
1answer
64 views

Microsoft Flow vs BCS/ECT to keep an Azure SQL table in sync with an SPO Modern List?

We worked with BCS (Business Connectivity Services) and ECT (External Content types) a while back and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a ...
2
votes
0answers
18 views

Create, read, and update from SQL table to on-prem SharePoint 2016?

Ultimately I would like to create an external list that can be customized (i.e., partly columns from a SQL table and partly native SharePoint columns). BCS isn't an option because it would not let me ...
1
vote
1answer
16 views

SQL table to external content type (or types) - Suggestions on how I might do this

I have an SQL table that has 11 columns. I need to use what is in each column as a separate, independent drop down in a list item. The columns and rows aren't related, there just grouped into one ...
0
votes
0answers
19 views

Removing web solutions completely - Now getting runtime errors

In preparation for a migration soon, I am cleaning up our 2013 environment. We used to use Metalogix ControlPoint when we did 2010 to 2013, but that was a long time ago, and it has itself all over ...
3
votes
0answers
277 views

Create a SharePoint Farm using SQL Azure

I have an on-premise installation of SharePoint 2013. I need to create a new farm (Using either SharePoint Configuration Wizard or Powershell) in SQL Azure. Using Configuration Wizard, it keeps ...
0
votes
0answers
36 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
1answer
154 views

SharePoint 2016 compatibility with SQL Server 2016 SP 2

Is SharePoint 2016 compatible with SQL Server 2016 SP 2 ?
1
vote
1answer
583 views

Internal site works External site gets “Server Error in '/' Application.”

Our sharepoint works great on our internal network. We use Sharepoint 2013 and SQLEXPRESS 2012. We have a domain intranet.crkoes.org that we have setup but get this error. Server Error in '/' ...
0
votes
1answer
311 views

Extract Document from Content DB SP 2013

I am currently trying to retrieve a single document from a DB from SP2013 environment with SQL. I have taken a snap shot of the db and am trying against it (so not touching production in any way at ...
1
vote
0answers
1k views

You do not have permission to run the RECONFIGURE statement

I am attempting to upgrade a SP2010 content database to SP2013. Once I get to 100% of the Mount-SPContentDatabase, etc, I am presented with the error: Mount-SPContentDatabase: user does not ...
0
votes
1answer
172 views

Get data from VARBINARY fields

System: SharePoint 2010 and SQL Server 2012. Question : how to get data from a content database field that are tCompressedString(varbinary) type? For example, table [Content_DB].[dbo].[AllWebParts] ...
2
votes
1answer
39 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
16 views

Migrating items from columns residing in different sql tables(5 to 10) to single SharePoint list

I have SQL database where there is a master table and several child tables. There is a key column (id). What I want is to migrate all these column values from multiple tables to one pre-created ...
0
votes
1answer
518 views

The attach operation cannot continue because another object in this farm already contains the same ID

My SQL DBA Team decided to change the SQL version and they did migration from one sql server to other sql server and when i tired to do add content database operation from central admin it gives this ...
1
vote
1answer
211 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 ...
0
votes
1answer
350 views

Does SharePoint Server 2016 need a licensed SQL Server 2014?

We're trying to upgrade to SharePoint Server 2016 and I understand that there is no Foundation version for it anymore. My question is, when I buy the SharePoint Server 2016 Standard/Enterprise ...
3
votes
1answer
235 views

SQL Server Max Memory

In our farm, we have 3 servers dedicated for SQL Server and all three are consuming 99% of the memory available. Looking in to it I learned that we didn't change the Max Memory setting in our SQL ...
1
vote
1answer
124 views

How can I connect SQL DB to SharePoint List without Business Data Connectivity

I have a table in a sql database that I'd like to use to populate (and regularly update) a List in SharePoint. I'm the manager for the site with this List, but not the installation (which includes ...
0
votes
1answer
385 views

Can't update data Excel Online from Azure SQL datasource

Here's what I've done: Created new Excel file on my desktop. Added connection to Azure SQL using database authentication. Read in a view. Save this document to Sharepoint for my tenant. It's hosted ...
2
votes
2answers
80 views

Attach Database Failed SQL Error

I have a .mdf file which contains more than 30 GB data. On trying to attach this to SQL on one of our standalone dev servers (with independent database), I am getting the following error message : "...
1
vote
1answer
56 views

BCS - Cannot open server requested by the login. The Login Failed

I am trying to create an external list from my Azure DB using BCS. I already setup the SQL, and I was able to connect to it through SSMS. But when I tried SPD to create external content type I am ...
2
votes
1answer
461 views

SharePoint 2016: Transaction (Process ID 58) was deadlocked on lock resources

I receive the following error when attempting to create a new SharePoint 2016 Configuration db in SQL 2017. PS command and Error: The local farm is not accessible. Cmdlets with FeatureDependencyId ...
1
vote
1answer
500 views

How to make a SP list by using SQL Data through PowerShell

I have the following assignment: Our campus has a SQL database filled with printers. My job is to create a SharePoint list that printer constructors can use to read certain counters. This will be ...
0
votes
1answer
1k views

Custom message for those who don't have access

How can I provide a custom message to a user who doesn't have access to a folder in Microsoft Online SharePoint? Appreciation in advance.
2
votes
1answer
1k views

Call SQL procedure from Workflow - Sharepoint 2013

Is there a way to call an procedure stored on SQL server from SharePoint 2013 workflow?
0
votes
2answers
38 views

Work with SQL table in SharePoint environment

I have to create a simple custom list with half a dozen of columns, but due to number of items it will create (there will be more then 5000), OOTB SP custom list will bread after 5000 items threshold ...
0
votes
2answers
2k 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
1answer
74 views

Sharepoint - The search result is not expected

Above is the data, however the search criteria need to be exact. I tried to search data and type in "AA" but it doesn't return result. It has to be exact type in "AAA" any idea?
1
vote
2answers
2k views

SharePoint 2013 list in SQL

I have a couple of questions: Where does SharePoint list stores data in SQL? Is there article for SP2013 on MSDN or TechNet? - I can find outdated articles which explain table structure for a list ...
1
vote
0answers
892 views

Get the library name from GUID in VBA

I want to pull information from a SharePoint 2016 list in VBA. Below Code is what I found and that is working without depending on a view. Unfortunately the SQL query uses the list Name. A user could ...

1
2 3 4 5