SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
94 views

Can setting MAXDOP to 1 decrease performance?

I was looking at my client's UAT farm and found out that MAXDOP was set to 0 on SQL Server instance hosting SP databases. Before setting this value to 1, I measured response times of most commonly ...
1
vote
1answer
71 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
1answer
366 views

How to install SharePoint 2013 Installation with SQL Server Authentication

I'm just curious about the steps required to install Sharepoint 2013 using SQL Server Authentication. Also if there are any drawbacks that i might not be aware of. Here are some steps i currently ...
2
votes
0answers
215 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
68 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
20 views

How to give full permissions (such as permission to give other employers) to site manager in sharepoint 2013?

For example, the HR head department DOES NOT wants to give permission to a ECT (external content type) table view. However, the HR head just wants to give permission to submit data from a form ...
1
vote
0answers
32 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
43 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
30 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
32 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
18 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
659 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
212 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
46 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
129 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
313 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
133 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
12 views

Problem after configuring RBS on SharePoint 2013

I have configured RBS on a SharePoint site on one of our clients and I am getting the following error whenever I upload a file to a document library: The URL '' is invalid. May refer to a ...
0
votes
0answers
18 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
11 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
28 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
18 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
36 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
29 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 ...
0
votes
0answers
28 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 2014 is not a supported combination, but not ...
0
votes
0answers
12 views

SQL environments to a centralised environment

We are looking at moving our SQL environments to a centralized environment, with a single SQL installed and many DB instances on. Are there any problems that might arise? We currently have a separate ...
0
votes
0answers
12 views

SQL server 2012 SharePoint 2010

Can we use same SQL server for two farms of SharePoint 2010? Can I use different SQL instances on same SQL server for two different SharePoint farms? If I want to move from SQL 2008 R2 to SQL 2012 ...
0
votes
0answers
17 views

Grab image type from SQL and display in SharePoint

I have SharePoint Foundation 2013. I have employee information (name, titles, dates, photo [image type]) in a SQL database. I want to be able to grab this employee data from the SQL table and ...
0
votes
0answers
24 views

How to access ProjectWebApp site without define directory in Url

I am working on SSL configuration on PWA(ProjectWebApp)site with SQL Server 2008 and SharePoint 2013.Whenever someone wants to access it, need to put /PWA (http://servername/pwa ) explicitly in URL. ...
0
votes
0answers
25 views

Token-based server access validation failed with an infrastructure error

I am having the following error notification from the database server DESCRIPTION:Login failed for user 'Domain\XYZ_Admin'. Reason: Token-based server access validation failed with an ...
0
votes
0answers
51 views

RBS maintainance job Orphan cleanup not working

the problem are that Orphan cleanup won't start up. He starting up. chekcking pools and always stuck on 5 pool. And can delete other pool data. The command I'm runing: > C: cd "C:\Program ...
0
votes
0answers
22 views

Excessive DB Connections

Normally our SQL database has around 100-200 connections established to various webservers and application. Our DBA did a health check this week and this has jumped to 600-700 upon further ...
0
votes
0answers
37 views

List on External Content Type ECT modify edit form

I have a SQL 2012 table that that publishes a list in sharepoint 2013. I have been able to create some custom filters on the display page and pass those back and forth to get most of the list to ...
0
votes
0answers
30 views

Reporting server issue - external content type list

I created a new report with Report Builder, it is working fine into the client but when I open it in SharePoint I get this error: The shim execution failed unexpectedly - Proxy creation failed. ...
0
votes
0answers
21 views

Constant SharePoint 2010 read/writes to TEMPDB

We have a SharePoint 2010 farm consisting of 4 servers (1 WS, 2 Apps, 1 DB). Things appear to run smoothly except that we are noticing a surprisingly high number of IOPS hitting TEMPDB. We are talking ...
0
votes
0answers
52 views

Error while creating aspnet.db for Form Based Authentication

I want to install SharePoint 2013 FBA Pack for user password management. When I followed the instruction to prepare my system, I can not create a aspnet.db. I got the following error message: Setup ...
0
votes
0answers
145 views

KRB_ERROR KDC_ERR_BADOPTION (13) for MSOLAPDisco.3

Anyone encountered the KDC_ERR_BADOPTION (13) Kerberos error for the MSOLAPDisco.3 SPN (SQL Server Browser)? Couldn't find any resources related to it. What misconfiguration (or missing ...
0
votes
0answers
377 views

Configuring Windows Server 2008 R2 for SharePoint Server 2013 installation

I've a server running Windows Server 2008 R2 and I want to install SharePoint Server 2013 as evaluation. I don't have any experience with Windows Server roles, features and services. I want to know ...
0
votes
0answers
65 views

How to browse a multidimensional OLAP cube in SharePoint 2013?

I have an instance of SQL Server 2012 analysis services (multidimensional not tabular) with a couple of cubes. I want to browse the cubes from a SharePoint 2013 enterprise edition site. I tried using ...
0
votes
0answers
32 views

Migration from SQL server 2008 to 2012

I am upgrading MSSQL 2008 to MSSQL 2012. This box contains all of the DBs for our Sharepoint installation. We have identified that we can run the setup wizard to change the database and basically ...
0
votes
0answers
240 views

Downgrade SQL Server edition from Enterpise to Standart

Maybe somebody faced with the same task and have solved it successfully. If so then, Is there any way to save Web Analytics service application data? Will Search Service Application normally recover ...
0
votes
0answers
43 views

Creat AlwaysOn SQL Server 2014 and running SharePoint 2013 on the Replica

When i am gonna creat an AG the following error shown the following folder locations do not exist on the server instance that hosts secondary replica ...
0
votes
0answers
40 views

SharePoint remote blob storage confusion

We are considering using RBS with SharePoint 2010. I have researched it but I am still confused about one scenario. We want to store our BLOB's (mainly videos as files) on a NAS. I have read it is ...
0
votes
0answers
58 views

PerformancePoint services 2013 with SQL Server 2008

I am trying to use performancepoint 2013 services to create a report that simple displays a set of columns from SQL Server Table. Apparently, PerformancePoint services can only display data from ...
0
votes
0answers
2k views

Critical error in event log after installation: Login failed for user

The following error will occur in the event log after starting my Windows Server 2012 server with SharePoint 2013 (Farm installation, not stand-alone): SQL Database 'SharePoint_Config' on SQL ...
0
votes
0answers
454 views

RBS with SharePoint 2010 and SQL Express 2008 / 2012.

My client has about 100GB of files loaded on a File Server. Initially the plan was to upload everything to SharePoint and bring everything under one hood. They have SharePoint Foundation 2010 and SQL ...
0
votes
0answers
55 views

Upgrading default SQL server express of SharePoint 2010 for reporting services

I need to upgrade default SQL server express of SharePoint 2010 with SQL Server 2008 Express with Advanced Services. What are the things I should keep in mind before upgrading? Thanking you in ...
0
votes
0answers
87 views

After shrink the error still occurs

When I try to save the aspx page an error occures. It says "....It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web". At SQL Server Man. ...
0
votes
0answers
423 views

Passing parameters to stored procedure in data view web part

I have a stored procedure which accepts 2 parameters. The stored proc is executed as EXEC MySP N'Val1, Val2', N'A,B,C' I inserted a Data View Web-Part and tried to get data from stored procedure. ...
0
votes
0answers
283 views

Move Sharepoint 2010 and SQL from one server to 2 different servers

I am moving a server that has Sharepoint 2010 Standard and SQL 2008 R2 installed to 2 different servers. Could someone explain in detail, what are the steps to achieve this? What are the things that ...