SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
33 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
48 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
189 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
69 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
2k views

Office Web Apps can't read/edit Powerpoint or read Word, but Excel reads/edits fine

A brief overview: I have a Sharepoint 2010 installation on Windows Server 2008 R2, with Office Web Apps installed. The Central Admin SQL Database in on the local server, but the SQL database that ...
1
vote
1answer
464 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
140 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
111 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 ...
1
vote
1answer
869 views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
0
votes
1answer
25 views

Can we save few of list items in a separate database?

I have a different requirement that For suppose myCustomList having 40 columns and every 10 columns are similar kind of data. So, I want to save those each group of 10 columns into a specific table[my ...
0
votes
1answer
27 views

Calling infoPath form code from a Web Service to populate a drop down list

Using a web service solution to retrieve SQL data I'm wanting to return the list of values that I've collected and call the InfoPath form code to populate the drop down options. How do I call the form ...
4
votes
0answers
160 views

Sharepoint 2013 and SQL Server 2012 Service Pack 2

I've tried to research this, but I'm not seeing anything relevant to installing Service Pack 2 for SQL Server 2012. Our DBA's want to apply this to out SharePoint 2012 SQL Server, but I can't find ...
2
votes
0answers
142 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
64 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
12 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
29 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
514 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
188 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
42 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
122 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
308 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
129 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
3 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
12 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
25 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
28 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
73 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
60 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
34 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
24 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
92 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
34 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
34 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
49 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
41 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
19 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
113 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
98 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
1k 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
401 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
400 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 ...