SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
1answer
732 views

SQL Server 2012 - service account error

I am getting the following 2 errors when trying to install SQL server 2012 on Windows Server 2012. These occur at the server configuration page. Access is denied. The SQL Server service account ...
0
votes
1answer
7 views

Moving SQL Log files to a new drive

SQL log files(.LDF files) and data files are in the same drive because of which the drive is full. I want to move the log files to a new drive. Can someone help me with the steps on what to be done? ...
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 ...
1
vote
1answer
1k 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
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 ...
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 ...
2
votes
0answers
139 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 ...
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 ...
0
votes
1answer
1k views

Local farm is not accessible, cmdlets with featuredependencyid are not registered

So after moving all my databases to the new SQL server I run this on my SharePoint central admin box, http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx#Man Everything goes through ...
1
vote
1answer
866 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
685 views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
0
votes
3answers
73 views

Is it possible to have 2 Sharepoint 2013 Farms using the same SQL Server instance?

Can 2 SharePoint Farms use the same database instance? I know SharePoint can use DBs that have non-standard names (as in the case of databases that have been pre-staged). I'm not asking if they can ...
1
vote
1answer
462 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 ...
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 ...
0
votes
1answer
16 views

Sharepoint 2013 Online SQL Server Connect

We have a sharepoint 2013 online tenant. We have some sql server databases that are on premise. For this query we want to connect sharepoint 2013 online to those databases and read information from ...
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
1answer
418 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
1
vote
1answer
32 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 ...
0
votes
2answers
37 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
0
votes
0answers
16 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
1answer
30 views

External Data Editing and Modification

Can data in a SQL database be modified (new, delete, edit) through a SharePoint out-of-the-box feature or custom built feature?
1
vote
1answer
28 views

Add SQL Analysis Services to a existing SharePoint Farm

Our SharePoint Farm is based on a failover SQL cluster (MS SQL 2012 Standard). The problem is, that the Analysis Services were not installed with the database engine. If I'm understanding right, it's ...
1
vote
2answers
90 views

How to archive the AuditData table on a contentDB?

I have a content db whose audit log is getting really big (60GB) and it's starting to effect the DB. I know I can go in and delete entries via Powershell, but I wanted to archive this table before I ...
1
vote
1answer
17 views

How is DocumentSet Capture Version data stored in Content Database

Is it possible to know how a "DocumentSet Capture Version" data is stored in SQL Server Content Database ? (Not using OM but directly).
2
votes
1answer
67 views

SharePoint 2013 + Reporting Services + Kerberos

How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database? I found below blog but I'm not sure about ...
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
1answer
33 views

SharePoint 2013 FBA Pack without SQL server Management Studio

I used of "prerequisites installation" option for install all of prerequisites for SharePoint 2013. This option just installed SQL server 2008 R2 without SQL server Management Studio. After SharePoint ...
1
vote
1answer
47 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 ...
7
votes
9answers
4k views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
1
vote
1answer
215 views

Unable to perform A full Farm Backup

I have SharePoint 2013 server, containing one web application and three site collections. I want to perform my first full farm backup, so I wrote the following command inside SharePoint PowerShell: ...
0
votes
2answers
37 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
0
votes
3answers
1k views

Can local SQL Server data be made available in SharePoint Online

We have a SharePoint Online account and local data in a SQL Server instance. The data from the SQL Server is available as an OData feed in SharePoint and can be worked with in Excel Power Query. We ...
0
votes
0answers
71 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
1answer
234 views

SQL Server 2014 Features Required for SharePoint Foundation 2013

I'm migrating a simple SharePoint installation (WSS 3.0 with internal DB) to SharePoint Foundation 2013 backed by SQL Server 2014. SQL Server 2014 seems to have a lot of options about which features I ...
0
votes
0answers
57 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 ...
1
vote
2answers
8k views

failed to start the database services MSSQL$Sharepoint

I am trying to install Share Point 2010 Foundation on a Win7 SP1 64-bit desktop. It installed with an error, something about Office components. When I start the SharePoint Central Admin Web App, I ...
4
votes
0answers
149 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 ...
1
vote
2answers
42 views

Who has permission to see what?

We just encountered a problem in our site - 95% of the security permission settings that we had in place were lost. We have added them back manually and suspect we have added them back 95% correctly ...
0
votes
0answers
33 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
1answer
99 views

SharePoint: Perform a query to load data into external list and display the results in a list within the webpart

I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
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 ...
2
votes
1answer
27 views

How to fill up values from sql into a newform.aspx

I have a list that has fields like, name, position, year of birth. This information is stored in a database (read only). When a user opens list's form (an OOTB form) , I want to go to the database, ...
0
votes
0answers
89 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
2answers
52 views

Can we use SQL Server as a primary data storage for SharePoint 2013?

Is it possible to use external SQL Server as a primary data storage for SharePoint 2013? Having this implemented we can generate reports, query data and it would become very very powerful to use. Or ...
3
votes
2answers
7k views

“Invalid License Data. Reinstall is required” error when installing SharePoint 2013 after Sql Server 2012 on the same machine

I've already installed SQL Server 2012 on my machine. Then I tried to run the SharePoint 2013 Foundation installer but I received the following error before I even reached the splash screen menu: ...
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
1answer
45 views

Populate field in a form depending on value on another from database in SP2010

I have a List with three fields, all three text boxes. The first field is an ID, which when populated needs to trigger a DB query to pull corresponding title and description from a table in SQL Server ...