SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
46 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
52 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
2k views

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

I am using Sp2013 Standard server, with 1 APP, 1 WFE, 1 Workflow and 1 Clustered SQL. Everything was all great until Monday Morning (7-28-14). Thats when Event Log started to fire off following ...
1
vote
1answer
229 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 ...
1
vote
1answer
73 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
1answer
489 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
1answer
142 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
115 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
1answer
86 views

SQL Server 2008 Installation on SP 2010

I'm installing SP 2010 on Virtual Machine Windows Server 2008 R2. My Question: Is it necessary to install SQL Server 2008 (or R2) before installing Sharepoint Server 2010? Plus, when installing SQL ...
2
votes
0answers
161 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
65 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
19 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
30 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
16 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
543 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
193 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
43 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
126 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
310 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
131 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

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
12 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
8 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
13 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
12 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
10 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
15 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
17 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
37 views

Slow SharePoint 2013 site 18000ms in SQL queries

I have a fresh virtual machine with 12gb RAM and 64bit 4 core CPU. SQL is running on a separate server. My SharePoint 2013 site is running extremly slow. It takes over 20s to load a page. I tried ...
0
votes
0answers
32 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
79 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
142 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
39 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
26 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
119 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
37 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
37 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
50 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
26 views

SP2013 reporting in MicroStrategy

I want to use MicroStrategy to build my repots. Normally i use sqlServer and microstrat with the ODBC links but i don't know how to do that with sp. Can i execute some SQLs directly in the ...
0
votes
0answers
43 views

Move SharePoint 2010 and SQL 2008 R2 Reporting Services to new server

I have a server with SQL 2008 R2 and SharePoint 2010 installed on the same box and Reporting Services is running in SharePoint Integrated mode. I'm now looking to move all of this to a new server and ...
0
votes
0answers
21 views

Error when creating new site collection by new user (developer)

We have installed SharePoint on a server. A new sharepoint developer has joined the team and the system admins have provided him a login: server\newemployee Now, if he logs into Windows and opens ...
0
votes
0answers
117 views

Expand SharePoint Calendar Recurring Event in SSIS Project using CAML

Is it possible to expand recurring SharePoint calendar events using a CAML query in a SharePoint List Source using the SharePoint adapter off of Codeplex? I have been searching all day and found many ...
0
votes
0answers
20 views

Creating a BCS conectivity with Sharepoint Designer 2010 with MS SQL server 2005 (Externall Table)

When I tryied this Link and Connect with server 2005 : http://kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/ Get a lot of errors with tables(No One ...
0
votes
0answers
103 views

Row-Wrapping… What limit?

Currently at site collection level on this instance of which is single on both counts, row-wrapping is set to 6. I want to increase this to 7. Traffic is based on 300 or so office employees of which ...
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
415 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
85 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
401 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
282 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 ...