SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
15 views

SQL Write Access when using SPExport API

We have developped a tool in C# which use the SharePoint SPExport API. We discover that when we EXPORT some Sharepoint websites, SQL read transactions are growing (normal) but also WRITE ...
3
votes
2answers
46 views

Migrated 2010 Databases, but some DBs can no longer be pointed to due to alias

Here's our scenario. We successfully migrated our SharePoint 2010 Foundation databases to another server using this method and this article. The key point is that we set up an alias from our existing ...
0
votes
1answer
60 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
0
votes
1answer
557 views

Orphan Site Reported After Running Test-SPContentDatabase

I'm upgrading from 2010 to 2013 and when I ran the Test-SPContentDatabase (on destination WFE server pointing at original content DB) command I got the following error relating to an orphan site: ...
3
votes
1answer
2k views

Sharepoint 2013 - SQL Server connection stopped working shortly after database server rename

We have an issue that has been solved, but I am trying to find an explanation. Our Sharepoint 2013 was working fine connected to a SQL 2012/Windows 2012 machine via a SQL Server Alias. We had to ...
1
vote
1answer
320 views

Project Web App is stuck on: Waiting for resources

While trying to unprovision a PWA in order to move the DB to a new SQL Server. I followed the following article: http://technet.microsoft.com/en-us/library/ff961887(v=office.14).aspx After the ...
3
votes
2answers
4k 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: ...
2
votes
1answer
45 views

What exactly does it mean that storing “large blobs in the database reduces performance”?

To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
2
votes
1answer
163 views

Installing SharePoint 2013 on local Domain

I'm trying to install SharePoint 2013 for our company. We already have a Domain Controller running on a separate Windows Server 2003. I am creating a separate server (Windows Server 2008 R2 x64) to ...
0
votes
1answer
36 views

Sharepoint server farm across WAN

I have a general question regarding Sharepoint setup. Currently, my company's setup is as follows: Active Directory domain controller SQL Server Sharepoint 2010 server Secondary AD Domain ...
1
vote
2answers
75 views

Best practice for taking SharePoint data and putting it into an SQL database?

I need to do some reporting across site collections. In order to do this I intend on writing a service layer that crawls SharePoint and puts information about document libraries and files into an SQL ...
0
votes
2answers
70 views

Which database my current SharePoint server is using

I was told by the DB adminsitrator that the current SharePoint server on staging is connected to database named SV002\SPS, but when i create a new application the database server name will ...
1
vote
2answers
126 views

SP_Admin SQL Permissions

I'm trying to create a web application using powershell and I'm getting a log in error with the SP_Admin account. I'm not sure if I've made a mistake when I was setting up the environment, I might ...
1
vote
0answers
337 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 ...
2
votes
0answers
56 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
1answer
150 views

How to provide highly available, disaster recovery solution for SharePoint 2013 deployment?

We need to provide highly available, disaster recovery solution for SharePoint 2013 deployment. For this purpose, we've to build environments for two data-centres, one would be primary DC1 and another ...
0
votes
1answer
222 views

List item storage in SQL

So I'm having some performance issues with some large queries against SharePoint (yes, I'm already using CAML), so I decided to take a peek at the SharePoint database despite the dire warnings never ...
0
votes
1answer
346 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
0answers
163 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 ...
0
votes
1answer
88 views

how to work with form based authentication in SharePoint 2010 three tier architecture?

I am working on SharePoint2010 site created on three tier architecture. I want to use the form based authentication method. I have prepared the form based authentication on web application but ...
0
votes
3answers
434 views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
0
votes
1answer
93 views

SQL Database Login Failed

The SharePoint logs, as well as in the event viewer keep popping up the following error: 'SQL database login for 'DBTable' on instance 'DatabaseServer' failed. Login failed for user ...
0
votes
1answer
132 views

Which versions of sharepoint support sqlserver read commited snapshot isolation?

I have been unable to find out if Sharepoint 2010 or 2013 (or even 2007) are able to take advantage of this MSSQL feature to improve the performance of the database operations invoked by Sharepoint ...
0
votes
2answers
306 views

Inserting new list items into SQL

When I add new item into the list, I have to insert the items into the SQL database. How can I do it? Any clue is good for me.
0
votes
1answer
1k views

Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”

My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition WF1 WF2 Both Web Fronts are NLB, and we have they following Application Servers APP1 - ...
1
vote
2answers
1k views

Workflows and SQL Server Databases

Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint? Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
1answer
3k views

There are no SQL Server instances or shared features that can be updated on this computer

I am trying to install SQL server 2008 r2 on Windows server 2008 r2, I have the SQL server installed in an ISO image and the windows server is on a VM workstation, but during the installation I got ...
1
vote
0answers
39 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 ...
0
votes
5answers
1k views

Sharepoint 2010 products configuration wizard giving error

Small disclaimer: I am a n00b at Sharepoint. I am actually a developer and have just been given Sharepoint platform saying that I have to get it running properly =/ Have had no training, all my ...
0
votes
1answer
41 views

wss 3.0 content database has expanded exponentially without any data added in it

I am hosting wss 3.0 web application in windows 2003 server with sql 2005 express edition. we are leveraging lots of out of the box functionality, but we also have some custom features and web parts. ...
0
votes
1answer
35 views

SharePoint 2010: How to determine in what mode SQL Server Reporting Services is installed

SharePoint 2010 Standard farm. How can I determine in what mode the SQL Server Reporting Services is installed? When installing SQL Server Reporting Services (SSRS), you must choose the mode in ...
0
votes
1answer
2k views

SQL Server Reporting Services: The remote server returned an error: (500) Internal Server Error

I'm running a SharePoint 2010 Standard farm. I have 2 Web Front-end Servers, an application server running SSRS and 2 Database servers. SSRS is installed using the Microsoft SQL Server 2012 RS Add-In ...
0
votes
1answer
165 views

Development with SQL Data Source in Visual Studio

There is a sql database. I want to get datas and display them as a list. And I want to filter the datas too. But I can't find any basic tutorial to do it. I don't know where to begin. Where should I ...
0
votes
1answer
309 views

SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message - ...
1
vote
1answer
500 views

SQL Log file repeating error :error code 0x6fd

SQL Server 2008 R2 Currently the log folder is taking upto 109GB's of space! It keeps repeating the following error: “An exception occurred while enqueueing a message in the target queue. ...
1
vote
1answer
216 views

Change SQL Server service account

I need to change the Service Account for Sql Server (i.e. I need SQL Server to run under a different account). Can I just change the account or do I need to perform some Sharepoint configuration as ...
0
votes
0answers
332 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
1answer
412 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
0answers
50 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
1answer
829 views

Databases for Sharepoint Foundation 2013

I recently installed Sharepoint 2013 onto a test server to look at the possibilities of upgrading our 2010 instance. After the installation, I noticed that far more DBs were created on my SQL Server. ...
5
votes
1answer
208 views

Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm

I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups. Essentially we're running ...
0
votes
1answer
50 views

How to backup specific ListItems to database?

We are running a ticketsystem on Sharepoint 2010 which got alarmingly large over the last few months. The ListView Threshhold currently sits at 15k for this WebApplication. I am currently looking for ...
0
votes
0answers
76 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
1answer
1k views

InvalidOperationException after promoting SharePoint server to domain controller

I installed SharePoint 2013 Standard on Windows Server 2012, and it was running fine until I decided to make the server a domain controller: Remove the ADCS role Remove then re-add the ADDS role ...
1
vote
1answer
60 views

Document storage in sharepoint

By default, Sharepoint stores the documents in Sql Server. It may give performance issue if we have large files(say 1 TB). So, how do we overcome this or do we have any other way of storing ...
1
vote
2answers
403 views

401 Unauthorized after database move to new SQL Server

I need some assistance trying to figure out what is going on. We have been running our test SharePoint and test SQL together on the same server and it has been doing ok, but we decided to move SQL to ...
1
vote
1answer
126 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 ...
0
votes
1answer
202 views

User Profile Synchronisation from SQL Database

I am trying to update the Manager and Profile Picture properties for the UPS from SQL. The problem is that these two fields are stored as text in SQL but SharePoint expects a Person field and URL ...
1
vote
1answer
100 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?
0
votes
1answer
144 views

Connect SQL Server installed local machine with Sharepoint VM

I need to install SharePoint (Farm based installation) on VM and I have installed SQL Server 2008 R2 on my local machine. How can I connect both the machines so that I can use sql instance settings ...