SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

2
votes
0answers
26 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 ...
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
384 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
81 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
18 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
109 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
27 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
29 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
19 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
165 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
145 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
42 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
35 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
24 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
778 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
253 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
48 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
137 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
320 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
135 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
17 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
22 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
19 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
9 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
21 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
45 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 ...
0
votes
0answers
37 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
36 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
15 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, ...
0
votes
0answers
87 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
282 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
15 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
35 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
34 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
124 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
32 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
25 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
22 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
69 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
109 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
9 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
84 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 ...
0
votes
0answers
23 views

How can I use SQL data in SharePoint form

I have a SharePoint form with some fields and would like to populate it with some data from a SQL Server table. I wanted to have a search button besides the title field for example and when that is ...
0
votes
0answers
50 views

How to move data files from local C drive to Content Database in SQL Server

I am having some html files in local C drive in the laptop.. the dynamic data in those files should be moved to SQL database.. the data is further used through sharepoint after its saved on sql. ...
0
votes
0answers
50 views

Custom WCF Service in SharePoint That Queries SQL Server

I'm able to create a WCF service and deploy it SharePoint. When I try to add functionality to interact with a SQL Server database, the service stops working. For testing, I've tried creating an ...
0
votes
0answers
408 views

SPDataAccess Role is not visible - Sharepoint 2013

I have a Sharepoint 2013 farm and SPDataAccess Role is available for some content DBs and not for others. Is there a way to add this role to a specific DB using PowerShell?
0
votes
0answers
29 views

WSS 3.0 single server system with external SQL Server

I have installed WSS 3.0 with SP2 on Windows Server 2008 R2 SP1 (not domain joined) as a single system (Basic or Advanced -> Complete in the installation wizard selected). Everything works fine. I can ...
0
votes
0answers
306 views

Read operation on a large object failed while sending data to the client

We recently upgraded our DB's for SharePoint 2013 by following these directions: http://blog.entos.at/Lists/Posts/Post.aspx?ID=14 Now we're receiving this error multiple times in Event Viewer ...
0
votes
0answers
42 views

I can open Sharepoint Central Administration Page, but most clicks are inop?

I just installed Sharepoint 2013 server on top of WIN2012r2/SQL2014 and all seemed to go well until I tried to click on anything behind the home page Sharepoint Central Administration: I can get ...