Questions tagged [sql]
SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
254
questions
0
votes
0
answers
5
views
How to migrate InfoPath XML Data to SQL Server?
The project is to create .net website forms using razor C# to replace Infopath.
Migrate the xml data on the sharepoint 2013 server to an SQL Server. My lead says to write a script; I think there are ...
0
votes
1
answer
77
views
Is it possible to use environment variable in canvas Power Apps for SQL data source
Is it possible to use environment variable in canvas Power Apps for SQL server data source?
If not, any work around so that we can update the SQL server name and database name in a managed solution?
I ...
- 4,070
0
votes
0
answers
13
views
Guidance Needed: Connecting an On-Premises SQL Database to a SharePoint Online Column via Azure Web App Hosting WCF Service
I'm working on a project that involves connecting an on-premises SQL Database table to a SharePoint Online lookup column. As a part of the process, I've successfully set up an Azure Web App to host a ...
0
votes
0
answers
85
views
Updating Sharepoint list multi-choice field with excel VBA SQL code
For a given sharepoint list, I am trying to create a row via an SQL statement.
My SQL statement is as follows:
sql = "INSERT INTO `My Sharepoint List` (`Title`, `Lead`, `Part`) VALUES ('Project1',...
0
votes
0
answers
105
views
SharePoint 2019/Subscription Edition -- SQL Authentication
I have been working with SharePoint for the better part of 15 years. During that time, I almost always installed SharePoint in a domain environment where the Application Server(s) and Database Server(...
- 181
0
votes
0
answers
111
views
SharePoint Server 2016 after installing Sep 2022 patches trying to run the psconfig command and it fails with sql error
I am installing September 2022 patches in one our environments and patches installed no issues, after installation I am trying to run the psconfig powershell command and it fails every time with this ...
- 1,407
0
votes
2
answers
75
views
Get items from SPO and past them in Azure SQL
I am trying to make a logic app with "Recurrence" triger which get items from SPO list (from view) with condition:
if have null values, then pass them some string or boolean (if column is ...
- 1
0
votes
1
answer
39
views
How to join multiple lists in SharePoint 2013 on-premises?
sorry if my question is for old versions. the system I have access is sharepoint 2013, InfoPath , sharepoint designer. I need a list for report that I have to joint multiple list for retrieving the ...
- 103
0
votes
1
answer
54
views
Error on Central Admin's 'Check Database Status'
The default instance was upgraded to SQL 2019 for the server on which our SPinstance for SP2013 Enterprise resides. Our SP lives on a named instance.
ULS logs:
System.NullReferenceException: Object ...
- 61
0
votes
1
answer
586
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
76
views
How to show output of an SQL query in Sharepoint 2013 web part?
Is it possible to use the SQL query that I have written and outputted to a web part through JS and display it as a table in a SharePoint 2013 web part?
- 47
0
votes
2
answers
268
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
0
answers
737
views
Data table doesn't refresh
I have a canvas app where on one screen I have a data table connected to a SQL server table, which pulls a list of values. When I select a value in that list, it's supposed to take me to another ...
- 101
0
votes
1
answer
156
views
How to save binary file to SQL by power automate
I have got a problem with database. Is there a solution or connector to save a Binary field to SQL database?
- 1,709
0
votes
1
answer
250
views
Stuck at SharePoint2016 config Wizard
I already followed the tutorial and instructions but still cannot create database from SharePoint Config wizard.
Even I used SharePoint 2016 Management Shell, but still :
"Cannot connect to ...
0
votes
1
answer
23
views
T-SQL to CAML - I wonder what's missing in the CAML (T-SQL works)
I have this SQL query and it works perfectly. However, when I try to create a similar CAML it doesn't work. Is there a tool that can convert SQL to CAML. or can someone please help. Here is the ...
- 3
1
vote
1
answer
11
views
create report from external big data at sql database at sharepoint 2016
I need to create a report from an external SQL database and run the report at SharePoint 2016.
The SQL database size was big around 5 GB, How can I do it?
I think to create a procedure at SQL database ...
0
votes
1
answer
23
views
I need to create report from external sql database , and run the report at sharepoint 2016
I need to create a report from an external SQL database and run the report at SharePoint 2016. The SQL database size was big around 5 GB, How can I do it?
I think to create a procedure at SQL ...
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
1
answer
539
views
Power Apps without internet connection
I am wondering is it possible to create a PowerApp mobile app which can function without internet connection and perhaps store data from the database (i.e SharePoint List or SQL Database) locally on ...
- 19
0
votes
1
answer
197
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
1
vote
1
answer
616
views
SharePoint2016: Content Database in "Error" status, do not appear with Get-SPContentDatabase
I am stuck with this urgent issue, same as Harris' issue here.
In Central Administration, under "Manage Content Databases", for my main WebApplication, here is the two content databases I ...
- 592
1
vote
0
answers
195
views
Sharepoint 2013 TLS 1.2 SQL Native client issue
I've been following the below guide for updating to TLS 1.2.
https://docs.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/enable-tls-and-ssl-support-in-sharepoint-2013
I am working to ...
- 21
3
votes
0
answers
99
views
what went wrong with my sharepoint server deployment?
i have an azure subscription and i am trying to create a sharepoint server 2016 with an azure sql managed instance. i followed the steps from this article (https://docs.microsoft.com/en-us/sharepoint/...
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
2
answers
117
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 ...
- 11
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
109
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 ...
- 1
0
votes
1
answer
54
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 ...
- 1,802
0
votes
3
answers
91
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.
...
- 1,502
0
votes
1
answer
43
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 ...
- 3
1
vote
1
answer
139
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 ...
- 1,299
2
votes
0
answers
29
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 ...
- 21
1
vote
1
answer
26
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 ...
- 31
1
vote
4
answers
707
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 ...
- 13
0
votes
0
answers
129
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 ...
- 1
0
votes
1
answer
406
views
SharePoint 2016 compatibility with SQL Server 2016 SP 2
Is SharePoint 2016 compatible with SQL Server 2016 SP 2 ?
0
votes
1
answer
1k
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,008
0
votes
1
answer
824
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] ...
- 768
2
votes
1
answer
114
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 ...
- 2,612
0
votes
1
answer
32
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 ...
1
vote
1
answer
2k
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 ...
- 641
1
vote
1
answer
621
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 ...
- 318
1
vote
1
answer
277
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 ...
- 113
0
votes
1
answer
683
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 ...
- 101
0
votes
1
answer
779
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 ...
- 85
2
votes
2
answers
221
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 :
"...
- 93
1
vote
1
answer
141
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 ...
- 236
2
votes
1
answer
772
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 ...
- 435
1
vote
1
answer
1k
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 ...
- 11