We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

111 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
2k views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
2
votes
2answers
292 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 ...
2
votes
0answers
477 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 ...
2
votes
1answer
264 views

SharePoint 2013 DR - Warm Standby

We have really struggled with our Disaster Recovery processes for our SharePoint farm. I would appreciate any input on improving our current processes. Here is the technology that we're currently ...
2
votes
0answers
105 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
2
votes
0answers
93 views

SQL usermapping for Farm-account: dbo vs itself

On my SharePoint farm (in SQL) the farm-account is sometimes mapped as user (itself) to a SharePoint database and sometimes the farm-account is mapped as dbo to a database. On all databases the farm-...
2
votes
0answers
89 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no "...
2
votes
1answer
462 views

Running SharePoint 2010 on SQL Server 2014 with Compatibility Level 110?

Can anyone confirm if it is supported to run SharePoint 2010 on SQL Server 2014 with Compatibility Level 110? Have seen SQL Server 2014 and SharePoint 2010 is not a supported combination, but not ...
2
votes
1answer
396 views

“Missing documents” in RBS after restoring database

I'm assisting a client with a SharePoint migration, but have run into a situation with some of the document libraries. The SharePoint server was configured to use RBS via the native FileStream ...
2
votes
2answers
77 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
2
votes
0answers
679 views

Usage and Health Data Collection using SQL Authentication

I'm having an issue with trying to set my Usage and Health Data Collection to use SQL Authentication. I have tried setting my database credentials to SQL Authentication using both Powershell and ...
2
votes
0answers
970 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
2
votes
0answers
97 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
2answers
1k views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
1
vote
0answers
19 views

Connecting User ID to Search Report Results

SharePoint 2013 allows the search reports to be pulled from site collection level by month and day. The report is helpful but I want to know who did the search. The report seems inaccurate because ...
1
vote
1answer
30 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 ...
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
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
146 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. ...
1
vote
1answer
337 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
67 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 ...
1
vote
0answers
97 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
0answers
217 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 ...
1
vote
1answer
894 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!
1
vote
0answers
77 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 ...
1
vote
0answers
41 views

what to use for files that reach 4TB in size?

We have got a customer which has 4TB of files, but we are not sure yet what kind of files they are. Now the question rises, what is the best way to store these files? Is it best to store them in SQL ...
1
vote
0answers
67 views

Sharepoint backup permissions

When I run a Sharepoint farm backup, I get an error Object SharePoint_2013_Config failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup ...
1
vote
1answer
72 views

Restoring content database on SQL Server throws error database size limit

We a standalone SharePoint 2013 server with SQL Server Express. I have received a content database backup file of ~50MB. When I try to restore this content database backup file in our SQL Server ...
1
vote
0answers
45 views

App Config not working

I have a sharepoint code, where I use connection to sql database, when I use a string to connect it works, string connstr = "Data Source=CH-SQLD;Initial Catalog=LOGS;User ID=***;Password=***"; ...
1
vote
0answers
75 views

Error while Creating New Web Application

Environment : SharePoint 2010. Description: I am trying to create new web-application through Central Admin. Once I click on 'New' I am getting below error. Steps Performed till now: Verified ...
1
vote
0answers
145 views

Exception: Microsoft.Data.SqlRemoteBlobs.BlobStore Exception

In SharePoint 2010 I get this error from RBS. This error is shown in event viewer. I could not find any questions around about this error. This error is shown very ofthen. Too often I would say. ...
1
vote
0answers
41 views

Transaction log file for FAST Search

I have a FAST database that has a transaction log file that is growing at an unusually high rate, possibly after applying the FAST SP2 update. It ends up taking up the whole volume within a few days. ...
1
vote
0answers
1k views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
1
vote
0answers
76 views

Questions regarding migration of existing content to RBS

How much time does it take to migrate existing data into RBS? I am talking about $rbs.Migrate() command. For e.g. if I want to migrate 1GB of data, surely it will take time. But question is how much? ...
1
vote
0answers
41 views

Save infopath web form library published on Sharepoint to SQL database

I am very new to sharepoint. I have created an Infopath 2010 form template, which is hosted in Sharepoint 2010 library. I want to store the form data to SQL Database, so that I can create reports and ...
1
vote
1answer
815 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
1
vote
0answers
63 views

SQL Error 18456 state 8 on SharePoint Excel Services

I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint. I created new account with which I can easily login to SQL Server Management Studio: the username and password ...
1
vote
0answers
816 views

Farm configuration failed during step 3 = sqlexception error + infinite “not running in high constrat …” messages

I try to install a farm with the following requirments : windows server 2012 r2 + sql server 2012 sp2 windows server 2012 r2 + sharepoint 2013 SQL Server was correctly configured (alias, autogrowth, ...
1
vote
0answers
55 views

SharePoint 2007 crawler is not stopping

I recently tried to start a full crawl after my colleague mentioned that some of the files are not visible in the search. Normally the crawler start full crawl every week. so i manually tried to ...
1
vote
1answer
491 views

Change default Calendar events to have dropdowns populated by SP Lists

I figured out how to change the fields in a calendar to add extra info about events. Is there a way that I can take the fields that popup when I try to add a new event and get a dropdown table based ...
1
vote
2answers
77 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
1
vote
2answers
60 views

Who has permission to see what?

We just encountered a problem in our site - 95% of the security permission settings that we had in place were lost. We have added them back manually and suspect we have added them back 95% correctly ...
1
vote
1answer
160 views

Changing sql servers crashes sharepoint

So I have two SQL servers, server A and Server B. Server B is the newest one and the one we are moving things to. I have moved over all the content databases and changed everything in central admin ...
1
vote
0answers
49 views

RBS won't work with default “0x” SID credentials

I'm trying to get RBS to work without having to specify credentials for each user (SID) in the RBS tables. MSDN notes that default credentials starting with 0x can be used: Each credential entry ...
1
vote
0answers
310 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
50 views

Which installation option I should use for SQL server 2008 to work with SharePoint 2013

I want to prepare a development environment for SharePoint 2013, so I want to know which SQL server option I should use from the SQL server 2008 installation center , the available options are:- 1.New ...
1
vote
2answers
2k views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
1
vote
1answer
208 views

Sharepoint 2010 - Delete Picture Library

I had picture library on Sharepoint with 500MB of images. I have deleted it from site and farm level also. But data still rely on SQL DB. I have daily backups on server. Before uploading images daily ...
1
vote
1answer
125 views

Sharepoint 2010 multilingual support and SQL Server 2008 Collation

I am wondering when I install my respective SQL Server 2008 R2 database for Sharepoint if I will need to set the collation to anything specific to support Sharepoint's multilingual capabilities?
1
vote
0answers
155 views

BCS connection with SQL DB and Sharepoint list passing parameters

Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...