Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [sql]

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

0
votes
1answer
9 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
19 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
10 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
30 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
42 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 ...
1
vote
1answer
39 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
0answers
49 views

Managed Metadata and SQL for one list

I've recently been given a task slightly out of my wheelhouse. In fact, SharePoint is slightly out of my wheelhouse with version 2016 and designer 2013, since I lost the design view from 2010. This ...
0
votes
1answer
102 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 ...
0
votes
1answer
98 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 ...
0
votes
0answers
24 views

How do I know which user is hitting a particular SQL Server on my SharePoint Server?

I need to understand which user is hitting a particular SQL Server on my SharePoint Server? Also which web service is being hit? Also which app service is being hit? I checked the Central admin > ...
2
votes
2answers
46 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
26 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
152 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
107 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
2answers
36 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
538 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
52 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
839 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
537 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 ...
2
votes
0answers
33 views

Attaching an Azure SQL Datebase to Sharepoint Online Provider-hosted Web Forms Add-In

I found this guide but it's specifically made for MVC add-ins. I'm looking for a way of attaching my Azure SQL Datebase to a Web Forms Sharepoint Online add in but I can't find it anywhere. It was ...
1
vote
2answers
277 views

want to convert sql quer to caml

I want to convert my sql query to caml query and my sql query is sql query: select Room from hotel where (time between starttime="2:30" and endtime="4:00") and (date between startdate="1/2/017" and ...
3
votes
1answer
98 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 ...
0
votes
1answer
72 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 ...
1
vote
1answer
89 views

Add a SQL table for each item in a custom list?

I am fairly new to Sharepoint, so please forgive me if this answer is readily available somewhere, because in my searching I have not encountered the same issue. Goal: I have a custom list with ...
3
votes
1answer
52 views

Autopopulate sharepoint list using sql

I am using sql to pull data from a specific table, is it possible to autopopulate certain columns in a sharepoint list with this data? Currently I'm pulling the data and copy pasting into the list (...
0
votes
1answer
277 views

Crawl Database Size

So I have a SharePoint 2010 farm. Last month I noticed it was getting unreasonably bigger, everything was working fine though. Then I noticed that Search_Service_Application_CrawlerStore..... database ...
1
vote
0answers
39 views

How to pull data on to SP Online from an external source without Azure instance?

I am new to SharePoint Online, so checking is there a way to connect and pull/push data from an external data source like (SQl on prem, Chatter) on to SharePoint Online through BCS or External content ...
0
votes
1answer
629 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
82 views

How to change web application settings via Powershell or SQL?

Third-party tools like SharePoint Manager allow you to change settings on your web application. I need to toggle the LookupDropDownUseStandardControl from TRUE to FALSE, but SharePoint Manager is not ...
1
vote
0answers
826 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
20 views

SQL configuration for Sharepoint

We are migrating SharePoint 2010 data(100GB) from one company A to company B(After acquisition) creating a new SharePoint 2010 farm. Company B also has around 100GB data in SP 2007 version which ...
1
vote
1answer
729 views

MS Recommended Reindex of Sharepoint Databases

I find a high level of index fragmentation in many tables of the SharePoint 2013 database (greater than 75%). Documentation appears to indicate that SharePoint Timer should be running tasks to ...
1
vote
1answer
271 views

SharePoint Provider hosted app with backend as sql server for CRUD operation

I have a provider hosted app in SharePoint on premise. Is it possible to retrieve data from sql server and crud operation database using app?
1
vote
1answer
91 views

How to move web app data between farms

I have SharePoint Prod and Sharepoint Dev farm envirenment, In my SharePoint Dev I have already "Site1b" an older copy of webapp "Site1a" from Prod and I would like to update it How should I proceed?
1
vote
1answer
406 views

Connect Azure SQL Database to Provider Hosted Add-In

If I have both a provider hosted add-in and an SQL database running on the same Azure server, how do I access the database from within my Sharepoint add-in? Thank you!
0
votes
1answer
38 views

Upgrade my SharePoint 2010 database from 2008 SP1 to 2008R2 SP3

I have SharePoint 2010 running on SQL Server 2008 SP1. I would like to upgrade the database to 2008R2 SP3. Are there any problems with that?
1
vote
1answer
840 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
71 views

Sharepoint with mirrored database

i'm tryin to build a lab farm where a sharepoint 2013 server will use a mirrored database. I read lots of stuff but i'm still not sure about the correct installation path. I would roughly proceed the ...
1
vote
1answer
85 views

Error Report to SharePoint library

I have configured the reporting service in native mode, add the SQL Server Reporting Services Service application, start the service, I created the data source for the report. But when I try to enter ...
0
votes
1answer
79 views

Possible to Install Any Version of SharePoint Using SQL Server 2014 Express?

The company I work for is thinking about moving our SharePoint services in-house. Currently, we have a SharePoint 2010 Foundation site through a remote host and we are considering either moving to ...
1
vote
0answers
57 views

Can not retrieve sql server routine return parameter schema information

I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error: Invalid Object Name '#...' .Can not retrieve sql server routine return ...
4
votes
2answers
2k views

Suddenly am getting “Cannot open database requested by the login. The login failed.”

My virtual machine was working fine, and everything was OK, suddenly, when I tried to connect to central administration, I started having an error saying connection closed and 200 OK http status. ...
0
votes
1answer
76 views

MOSS 2007 <SharePoint:SPSqlDataSource /> compatibility with SQL Server 2012 version database

We have a MOSS 2007 version sharepoint site, and a database in Sql server 2005 ver (a application specific database with all required tables) we are accessing the data (by using <SharePoint:...
0
votes
1answer
25 views

How to use xml definition in SharePoint list which is configured using BCS

I have a SQL database server with 3 columns ID, Location, FileType, I have used BCS service to connect SharePoint with this table. Now for example Location field is int type something like 19 means ...
1
vote
2answers
127 views

How to export Sharepoint 2013 list to SQL Server

Suggest best possible way to add data from SharePoint 2013 list to SQL. If the suggested option is SSIS please elaborate on how to perform the same, i am not able to find any links or video tutorials ...
1
vote
2answers
508 views

SQL service accounts keep getting Locked out

SQL service accounts keep getting locked out in AD. I have to unlock them everytime. What could be the probable cause and a solution?
0
votes
1answer
124 views

800+ open connections being caused by SharePoint 2013 crawl?

All are "sleeping". Everything seems to be working fine but need to figure out why there are so many open connections. Any ideas? CREATE PROCEDURE dbo.proc_MSS_GetNextCrawlBatch @ComponentID int, ...
0
votes
1answer
51 views

How to create Sharepoint 2013 list with column entries incrementet by a button for every row

i want to create a list in Sharepoint 2013 where i can manage all my microsoft licenses. I want to be able to increment the number of used licenses after i used one. So, my licenses are on a ...
1
vote
1answer
534 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 ...
0
votes
1answer
18 views

SP2013 - Migrate SQL from all in one server to separate servers

I have a SharePoint implementation that was set up (not by me) with everything on one VM, SharePoint and SQL. We now have a requirement to move SQL to a separate server to increase performance and my ...