SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

2
votes
0answers
30 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
33 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
77 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
0answers
427 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
83 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 ...
1
vote
0answers
41 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
21 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
19 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
291 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
36 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
30 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
0answers
23 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
229 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, ...
1
vote
0answers
160 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 ...
1
vote
0answers
43 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
0answers
36 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
28 views

Submitting list data to SQL

I'd like to submit data from a Sharepoint List to my SQL Database. I want the user to be able to create a new list item, attach a file and then once added it will write to an SQL Database. How would ...
1
vote
0answers
806 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 ...
1
vote
0answers
262 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
49 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
0answers
138 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 ...
1
vote
0answers
321 views

SharePoint with SQL Server 2008 R2 Express Edition (max 1GB RAM)

I am planning to launch a light-weight app on a dedicated virtual sharepoint - Windows Server Web Edition 2008 - SQL Server Express Edition 2008 R2 - SharePoint Foundation 2010 When the 1GB RAM ...
1
vote
0answers
136 views

Dataview Web Part only works when pulling 110 lines or less of SQL

I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query. Unfortunately my queries appear to be limited to returning 110 ...
0
votes
0answers
23 views

SQL Server Reporting Services in SharePoint 2013

Please any one can help me in the following problem: When i try to working with SQL Server Reporting Service in SharePoint site the following issue faced me: Notes: All configuration steps 100% ...
0
votes
0answers
14 views

Permissions and Authentication for Business Data Connectivity Services

I have successfully installed BDC into my SharePoint 2010 environment, as well as an External Content Type and associated list. When navigating to the list however, I am receiving the error "Login ...
0
votes
0answers
14 views

Please suggest can we download Project Online Database with SSIS Using Azure site?

There is the capability to user SSIS to download copy of Project online Odata tables to On premise or Azure. Please suggest can download Project Online Database with SSIS Using Azure site. Preference ...
0
votes
0answers
22 views

Load SQL and SharePoint in PowerShell script

I need to create one PowerShell in which i am using SQL and SharePoint both. In my development environment it works fine because there is single server for Content DB server and WFE server. But in ...
0
votes
0answers
27 views

while upgrading sharepoint 2007 to 2010 errors

hi my upgrade fail from sharepoint 2007 to 2010 this is the log most of them are sql errors what can i do? [powershell] [SPContentDatabaseSequence] [INFO] [4/19/2016 2:41:58 PM]: ...
0
votes
0answers
28 views

Sharepoint designer 2013 WFC Not supporting .NET types

I'm trying to make CRUD operations with external content types with WFC Web services. In the Read item operation i'm returning all basic data from a class named "Curso" (Courses in English). That ...
0
votes
0answers
25 views

External List Without BDS

I am developing a Sharepoint site mostly as a document management solution for reports and invoices generated in the billing department. I have two tables in SQL that I would like to have access to in ...
0
votes
0answers
12 views

PerformancePoint: How to connect to sql/analysis services

I'm attempting to visualize list data as a chart. How would I go about requesting access/connecting to analysis services or an sql server table/cube? Much of my work is with sharePoint, so I'm not ...
0
votes
0answers
29 views

unable to load client print control error while printing

in our sharepoint 2007 farm . we are facing print issue in SSRS and users are getting errors "unable to load client print control" . with the help of our DBA's we found out that the issue is in the '...
0
votes
0answers
65 views

Unable to open document from Drop off library in SharePoint 2010

Unable to view documents from drop of library it showing error message When I open pdf documents from a web application, I found below error in uls logs System.Runtime.InteropServices....
0
votes
0answers
38 views

SharePoint 2013 fail over option

What are the options available for setting SharePoint 2013 fail over plan which have two tier architecture. Following servers in farm: SharePoint 2013 web front end SQL 2012 database Both servers ...
0
votes
0answers
42 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
0
votes
0answers
21 views

Cannot edit members of a provider - ,MOSS Forms Based Authentication

I have a MOSS web app using both Windows and Forms Authentication. I see that there is a Members group that can be edited for the forms users. It's server 2003, IIS 6, so I go to the properties of ...
0
votes
0answers
20 views

Command and Parameter Editor will not retain SQL Text

I have written a query that will provide a count of items by year and it works fine when running in SQL Management studio. I get the results I expect in 2 columns. select a.logged as logged, sum(a....
0
votes
0answers
131 views

SharePoint SSIS integration using oDATA Connection

I have been trying to integrate SharePoint & SQL/SSIS thru oData connection. I was able to integrate successfully once using above combination without any problems. I was able to extract data ...
0
votes
0answers
446 views

Call to Excel Services returned an error Sharepoint 2013

We have installed Microsoft SQL server 2014 installed and sql server Analysis server running on Sharepoint mode. Everything was working fine and 10 days we started getting the error Call to Excel ...
0
votes
0answers
17 views

The database collation is not supported error message when creating new Access web app to Sharepoint Online

I'm currently on a O365 Business Premium trial. I've setup a Sharepoint site, and now I'm trying to create an Access web app. When I create the web app using "Custom web app" tile from Access' main ...
0
votes
0answers
44 views

SharePoint Using all available SQL memory

Background We have two environments for SharePoint: Test 1 WFE, 1 APP server, 1 OWAP server and 1 SQL Server with 32 GB RAM All servers are Windows Server 2012 Tier 3 SAN disk (slower) ...
0
votes
0answers
62 views

Database locks on content database. How to identify what is generating the statement SharePoint side?

We're currently experiencing database locks on our one of our site collection's content database. These locks are generated by the SharePoint web server, and shows up in the Activity Monitor in MS SQL ...
0
votes
0answers
139 views

can't open office docs in sharepoint

I am running SharePoint foundation 2010 with office 2010. At some point yesterday sharepoint stopped allowing users to open any office document, word excel whatever. Here is what is going on. Click ...
0
votes
0answers
36 views

SSRS208 with sharepoint 2010 Intrigrated mode- ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created

I am trying to run SQL server 2008 SSRS with sharepoint Intrigrated mode and end up with ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created. Production ...
0
votes
0answers
28 views

Error when trying to create SQL Server PowerPivot Service Application

We recently migrated our 2010 environment to 2013. Everything is working except for Power Pivot. We're attempting to create a SQL Server PowerPivot Service Application and we're getting the ...
0
votes
0answers
23 views

Why Sharepoint Admin account cannot be a member of dbcreator and security admin in SQL server?

Once I am defining a server roles for SP_Admin account in sql server as a dbcreator and security admin, then I receive an error which says: Add member failed for server role... Can you please a ...
0
votes
0answers
89 views

Where to install SSRS SharePoint mode in a multi-server environment?

Hi I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server ...
0
votes
0answers
125 views

SQL Server reporting services report viewer parameters not visible after applying filters(Query string URL filter)

I am currently working on SharePoint 2013 and SSRS 2012. I have added a SQL Server Reporting Services Report Viewer web part on a page with few parameters. Next, I've configured QSUF (Query string URL ...
0
votes
0answers
10 views

data filter ssrs 2010 dosent work

My sharepoint list has 7000 items, I made report from this list 10 month ago, report made by data tools 2010. I have date filter in my report, table of report filter by parameter as date type. I ...
0
votes
0answers
111 views

Unable to start SQL Server (SHAREPOINT) service

Some days ago I had installed AD and DNS in one of my servers. These services was migrated and I then uninstalled them from the server. That server have the Sharepoint and SQL Server services. Just ...