SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
5 views

How to rollback RBS and what happens to existing data

Let's say I am using Remote Blog Storage (RBS) in one of my content database and decide not to use anymore. How can I roll back RBS? What will happen to my data and how can I migrate it out of RBS? ...
0
votes
1answer
20 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
1
vote
0answers
25 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
2answers
25 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
0
votes
1answer
26 views

Creating a list-backed SQL Server database without using External Content Types

I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only ...
1
vote
2answers
19 views

Multiple SQL databases in a farm

Is it recommended to have multiple SQL servers in a farm to host content databases or usually just one? sorry if this is a basic question but i am new to the SP architecture
0
votes
1answer
19 views

SQL server WSS_Logging fragmentation

We are running SP2013 on SQL Server 2014 (setup with a Available Group) and we use a tool called SQL spotlight to monitor the health of our SQL servers. It constantly complains that many of the ...
0
votes
0answers
11 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
1answer
35 views

Mount ContentDB

I am mounting a contentDB to a 2013 web application (upgrading from 2010). The contentDB size is around 2,5GB , the mounting process is stucked. I checked in the log and it is stucked here: ...
0
votes
0answers
10 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 ...
1
vote
2answers
50 views

upgrading SharePoint 2010/2013 Databases from SQL Server 2008 R2 SP2 -> SP3

How can i confirm that upgrading SQL Server 2008 R2 SP2 to SP3 is safe to roll out.(Compatible?) Any resources or tips would be appreciated Thanks in Advance
1
vote
2answers
57 views

Programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists

I need to programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists. By programatically I mean using a power shell, SQL query or even a webpart Libraries can be Asset ...
0
votes
2answers
37 views

Clone SharePoint VM containing SQL DB on different Box

I have a SharePoint 2010 Setup in a VM. And Content DB of central admin of this server, say "Server A" resides on "DB Server 1". Now i clone the VM and create another copy say "Server B". I changed ...
0
votes
0answers
13 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
16 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
2answers
54 views

Resolving permission error in sql for username domain\computerName$

I'm trying to resolve a permission error on our sharepoint sql server. The login for the user that has failed is the WFE computer name on the farm config db. What permission or role can I grant that ...
0
votes
1answer
25 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
0
votes
0answers
17 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 ...
2
votes
5answers
110 views

Creating SQL Alias after configuring SharePoint 2013 farm

I am trying to configure sql alias in SharePoint farm. I have followed various articles about configuring it through cliconfg.exe and it looks fine. I have rebooted server and all the services. When ...
0
votes
1answer
46 views

Using SharePoint WSS_Content database to find permissions changes?

I've noticed there are a few tables that may be able to help me put together an "Audit Log" of sorts for permissions changes in our SharePoint site. However, I'm unsure of how to join up the tables ...
0
votes
0answers
31 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
19 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
1answer
162 views

What versions of SQL Server does Sharepoint 2010 and 2007 support?

We have two SharePoint environments - 2010 and 2007. We are looking to upgrade our SQL Cluster to SQL Server 2014 and are looking to see if 2010 and 2007 support it. I could not find any ...
0
votes
1answer
128 views

Changing sql server service and sql server agent service startup account in SQL Server hosting SharePoint DB

i have a sharepoint deployment with one SQL Server (running on VM) hosting the config DB and another SQL Server (Physical Host because VM was running out of space) to host the huge Content DBs. I need ...
0
votes
0answers
28 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
1answer
40 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 ...
1
vote
0answers
23 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
43 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
3answers
376 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 ...
0
votes
1answer
21 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
18 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
2answers
60 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
18 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
61 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 ...
1
vote
1answer
64 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
1answer
37 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
42 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
312 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
22 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
112 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
40 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
56 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
65 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
670 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
44 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
0answers
119 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
160 views

Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013

What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
0
votes
1answer
363 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
266 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 ...
5
votes
1answer
242 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 ...