0
votes
0answers
23 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
2answers
31 views

Querying Published Access 2010 Web Database from SQL Server

I have a published Access 2010 Web Database on my SharePoint 2010 site. The forms and tables all work as expected, but I would like to query this database from SQL Server. Is this possible? ...
1
vote
0answers
27 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 ...
0
votes
1answer
238 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 ...
0
votes
1answer
45 views

How to connect a local database in a sandbox environment?

I have the following scenario: I am very new to Sharepoint 2010 development. In order to practice I had to create a sandbox. Therefore I was instructed to do the following steps: Get Windows 8 ...
1
vote
1answer
56 views

Restore farm backup and rename databases?

I'm using the Backup-SPFarm PowerShell cmdlet to backup our SP 2010 Server farm and all of its associated databases. We want to test our restore process, and I'm wondering if it's possible to restore ...
1
vote
1answer
24 views

Should I perform scheduled content DB SQL backups in addition to scheduled granular backups?

Currently we have a series of scheduled granular backups for the site collection level that use the PS "Backup-SPSite" command (e.g. https://myportal.com). I test these backups frequently, and have ...
0
votes
1answer
72 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
685 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: ...
1
vote
2answers
80 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
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
37 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
3k 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 ...
1
vote
1answer
592 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
105 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?
3
votes
1answer
87 views

SP2010: What happens when starting several Content deployment jobs at the same time?

what happens if I start several content deployment jobs synchronously in different site collections by ContentDeploymentJob.Run()? Are the jobs definitely executed one after another? Thanks!
0
votes
1answer
825 views

Does Sharepoint 2010 Enterprise work on SQL Standard version?

We are planning to get a backup server at Amazon EC2. As per my finding, Amazon supports only SQL Standard version. Can someone please help me with the above question. And, will any services be ...
0
votes
1answer
151 views

SQL Server Agent in my Web Farm

Im trying to setup some scheduling in my SharePoint 2010 Farm, where I have 2 WFE's and 1 DB server. In attempting to setup a scheduled task, I received the error "The SQL Agent service is not ...
1
vote
1answer
206 views

All about SharePoint licences

My question is regarding the licensing of the SharePoint, basically there was already a topic done about it, but it had just bunch of references to website which i already saw and i still didnt get my ...
0
votes
1answer
542 views

Cannot install SQL Server (2012) PowerPivot for SharePoint, always fails Sharepoint Version check

Trying to install a fresh install of Sharepoint 2010 (w/ SP1) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint. The prerequisites clearly show that Sharepoint 2010 SP1 is needed, ...
0
votes
1answer
34 views

Upgrading from SQL 2005 to SQL 2008R2 with RBS support

I am looking at setting up Sharepoint 2010 in our local test environment and our current test SQL server is running SQL 2005. I am just wondering if it is possible to upgrade the database later to SQL ...
0
votes
1answer
671 views

Microsoft SQL Server 2008 R2 (RTM)upgrade query?

Will SharePoint Server 2010 SP1 be compatible for an upgrade to SQL Server 2008 R2 SP2 CU2 from Microsoft SQL Server 2008 R2 (RTM)? If we upgrade(from Microsoft SQL Server 2008 R2 (RTM)) Is there any ...
1
vote
1answer
861 views

What benefits do I get by upgrading to SQL Server 2012 Enterprise?

With SharePoint Server 2010 Enterprise edition, what additional benefits do I get using SQL Server 2012 Enterprise edition as opposed to SQL Server 2008 R2 Enterprise edition?
2
votes
1answer
4k views

Create reports from SharePoint lists

We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
4
votes
4answers
11k views

Cannot connect to the configuration database

During usage yesterday my SharePoint services locked up the entire server and forced me to end process SharePoint tasks and stop SharePoint services. The problem was attributed to Office Web Apps, so ...
22
votes
6answers
9k views

Backup via SharePoint or backup via SQL Server?

How should I backup my 2010 SharePoint server? As I see it there are 3 choices: Full Farm backup Site collection backup SQL Server backup We're only doing backups using points 1 (occasionally) ...
1
vote
1answer
264 views

SharePoint 2010 new server farm with shared SQL Server

Here is the situation I'm planning an upgrade from MOSS 2007 to MOSS 2010. My goal is to provision the minimum amount of new hardware. My Thought was to just setup new WFE's and re-use the existing ...
0
votes
2answers
148 views

Does SharePoint need to be installed on the database server?

Or more specifically, how much of SharePoint needs to be installed on the database server? I have a SharePoint environment I'm getting ready to move into production but I'm a bit paranoid that the ...