0
votes
0answers
33 views

Push an MS SQLServer database table to SharePoint 2010

I have a database table on my local MSSQL Server that I need to give my remote customers read only access to. They run SharePoint 2010 and would like to access the table using this, I have a login to ...
0
votes
0answers
45 views

What is a good set of performance counters to measure scalability bottlenecks

We're moving our enterprise product to the cloud (IAAS) and are determining how many users we can support on a single VM. Our product uses SQL Server, SharePoint and a bunch of WCF services. What ...
0
votes
2answers
770 views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
0
votes
1answer
58 views

SSRS 2012 SharePoint-Integrated mode

We have a 2-server (web and app server plus a database server) SharePoint 2013 farm. We would like to add SharePoint-integrated mode SSRS 2012 to it. We were thinking of installing SSRS SharePoint ...
0
votes
0answers
292 views

Event ID 5586 on SP Foundation and SQL Express

I have a brand new Hyper-V VM with Windows 2012, fully updated up to today (11 Sept 2013). I installed SharePoint Foundation 2013 and additionally MS SQL Express 2012 on the same instance. In my ...
0
votes
1answer
106 views

Seperate SQL databases for Web Applications? Or host both web apps on same SQL?

Ok, my Hyper-V Server 2012 looks like this: we currently have 2 VM's in production, one is running SharePoint 2010, and the other is hosting the SQL Server 2008 R2 for SharePoint. We're getting ...
0
votes
1answer
34 views

Project Server 2012 Setup Claims there is a Previous Version - it's not

I have set up a test environment with this software on the Server: Windows Server 2012 Standard SQL Server 2012 SharePoint Server 2012 Enterprise Language Pack for the SharePoint Server Team ...
1
vote
1answer
63 views

To backup sharepoint, do I just have to backup the SQL database?

Sharepoint is basically running SQL Server under the hood as I understand it. Is backing up sharepoint as simple as just backing up the underlying SQL Server databases? Or do I also need some files ...
0
votes
1answer
115 views

SharePoint 2010 - MSSQL 2008 connectivity

Our SharePoint server has some issues connecting over to the MSSQL instance (different server ). The error message is :Cannot generate SSPI context .(Microsoft SQL Server )-even when trying to ...
1
vote
1answer
96 views

Sharepoint 2010 server farm

Here is my current Sharepoint 2010 setup. I have 3 VM's running on the same server. The 3 VM's are as follows (all Windows 2008 R2) 1) Active Directory server 2) Sharepoint server 3) SQL Server ...
1
vote
2answers
480 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) and SQL Server 2012 PowerPivot for Sharepoint. The prerequisites clearly show that Sharepoint 2010 SP1 is needed, which we have ...
0
votes
2answers
255 views

Sharepoint 2007 - Transaction log full

So I have this SharePoint 2007 site that is basically trash. I'm supposed to just toss it, but I'm in need of copying all of the data in form of traditional files and folders from certain projects. ...
0
votes
1answer
452 views

SharePoint 2010 with Always-On SQL Server 2012 cluster

I am setting up a SharePoint 2010 on SQL 2012, and planning to use SQL 2012 Always-On cluster. The cluster is established with 3 nodes with standard installs of SQL 2012 using AD accounts for ...
1
vote
1answer
61 views

Bigger ProjectServer farm is performing worse

I am using Project Server 2007 sp3 with SharePoint 2007 sp3 and SQL Server 2008 r2. I have recently moved my farm from 2 servers (1 DB and 1 App/Web) to a very big farm having Many Servers, Clustered ...
0
votes
2answers
362 views

SQL Server 2008 - Backup Databases with more than 50 characters

I am using T-SQL to backup my MS SQL 2008 databases: BACKUP DATABASE @name TO DISK = @fileName The problem occurs when it comes to the databases with their name length greater than 50 characters ...
1
vote
1answer
715 views

SharePoint 2010 Server Configuration Error -> “Cannot connect to database master”

I recieve the following error when I try to configure SharePoint 2010 Server: "Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current ...
2
votes
1answer
97 views

Using SharePoint to access and modify data in database

I have a situation where I currently have a huge spreadsheet that is used for tracking 40+ deliverables for projects. The spreadsheet solution is past cumbersome. I have been thinking about how I can ...
2
votes
1answer
1k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
1
vote
1answer
650 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
0
votes
1answer
117 views

Replication on system databases

Is it possible to replicate system databases? I only ask because I had an issue previously (described here) that appeared to be impossible but has come back up again this week. This time TempDB log ...
0
votes
2answers
196 views

Replication keeps popping up on SharePoint databases

My typical discovery scenario: We receive an alert that the transaction log is growing quickly. We are in Simple Recovery so I go to check it out. Log is already sized to 100GB and is at 80% ...
1
vote
1answer
127 views

Recover Sharepoint 2007

here is the scoop: have backups of all config and content databases do NOT have master and msdb backups Need to restore baseline functionality ASAP. What is the best way to approach this?
1
vote
1answer
158 views

SharePoint 2010 data storage location

Where exactly is SharePoint storing all of the data? I installed the server in the default location but I'd like it to have it save the data on a different drive. The setup did not prompt for any such ...
0
votes
1answer
7k views

How do I migrate a SharePoint 2010 site to a new server and new SQL instance

I have a SharePoint 2010 site on a test server and database. I would like to move my site to a production server and a new SQL instance. What is the best way to do this? Was really easy, here are the ...
0
votes
2answers
727 views

Emptying site collection recycle bin doesn’t make content DB smaller?

I deleted everything from a site collection recycle bin and remoted into the SQL server the content database is located on, went to view the WSS_Content and the sucker didn't get smaller. I had about ...
4
votes
3answers
3k views

Antivirus Configuration for dedicated SQL and dedicated IIS Servers

Our corporate standard is McAfee Enterprise, unfortunately this is non-negotiable. On two types of servers I'm responsible for, SQL & Web, we have noticed major performance issues with the ...
2
votes
3answers
11k views

WSS_Content contains?

WSS 3.0:Windows2003 I have a content database that keeps growing for the name of simply, "WSS_Content" This database is aside from all the other content databases that are linked to an web ...
1
vote
0answers
766 views

SharePoint threw “Unknown SQL Exception 206 occured.” Anyone familiar with this?

Our SharePoint instance threw the following errors when attempting to access data through a Content Query Tool: 04/02/2010 10:45:06.12 w3wp.exe (0x062C) 0x1734 Windows ...
1
vote
1answer
984 views

Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts) However after adding the cabinet file ...
1
vote
1answer
2k views

Getting rsSharePointError page when trying to access SQL Reporting server

I'm setting up SQL Reporting services with SharePoint integration. I've created my new reporting database, installed the SharePoint Web Front End Role on the reporting server, installed the reporting ...
3
votes
5answers
2k views

Sharepoint db issue after DB move to SQL 08

Recently we have moved our sharepoint 2007 db from sql 2000 server to 2008 x64 SQL server. All seems well, however there is a problem where the sql server stops running and the service has to be ...
1
vote
2answers
637 views

Renaming server breaks sql server and sharepoint

We have had to rename the machine name of a server that was running sql server and SharePoint MOSS. It seems to have broken both, is there a way to resolve this situation? All the best
3
votes
2answers
355 views

Potential issues with SharePoint 2007 and SQL Server default collation?

SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, ...
0
votes
3answers
287 views

SQL Server logging stops lengthy SharePoint operation

I've got a SQL Server 2008 Cluster that has a 10GB drive used for a particular databases log file. I have a site on SharePoint that had a good few gigabytes of files a document library. Deleting the ...
0
votes
1answer
951 views

How to change SharePoint database authentication

I created a web application and specified SQL authentication. How can I change it to NTLM? I tried under Central Administration > Application Management > Content Databases but that only changes the ...
1
vote
2answers
1k views

Are you required to use named instance for SharePoint DB?

I've setup a few SharePoint systems (both WSS 3.0 and MOSS 2007) and have always created named instances on the SQL server for the databases. But, I'm wondering if this was truly necessary. It's ...
4
votes
3answers
736 views

Sharepoint - one way sync to a second SP server for standby/backup

Using MOSS 2007 on SQL server 2005 is there any way to do a "one-way" synch of data from a production server to a standby server? This would be a one-way process only, and can happen daily rather ...
0
votes
1answer
1k views

403 FORBIDDEN Error in SharePoint with SQL Server datasource

I have created some custom WebParts on my SharePoint site through the use of SmartParts. My custom web parts look at 2 diff. SQL Server Datasources. When i run my code from Visual Studio 2008 is ...
1
vote
1answer
1k views

Moving Sharepoint 2003 databases to a new SQL Server

Recently we completed a new MSSQL cluster that we are planning on migrating all existing SQL databases to. This includes our Sharepoint databases, while looking into moving the databases I found the ...
1
vote
1answer
8k views

SQL Server Error: 18456, Severity: 14, State: 16 creating SharePoint SSO database

I'm using a web application (SharePoint) to create a database for Microsoft Single Sign On. Every attempt to create the database is giving a 'login failed' style error. For testing purposes I am using ...
2
votes
2answers
701 views

Problem running “Central Administration” website after windows update at Windows 2003 Server Standard Edition

I was have WSS 2.0 and then I upgraded to WSS 3.0 and the old instalation database was SQL 2000, now I have another SQL Server instance called:server_name\MICROSOFT##SSEE . After upgrade every thing ...
2
votes
3answers
820 views

Upgrading Sharepoint Database from SQL Server 2000 to 2005

We are preparing to upgrade our database server from SQL Server 2000 to 2005. I'm planning on doing an in-place upgrade to maintain accounts, privileges, etc., and I'm hoping it will be pretty ...
3
votes
3answers
3k views

Correct settings for tempdb to avoid significant changes in free space

Every two to three days we are getting the following SCOM error: The database tempdb in SQL instance MSSQLSERVER on computer sqlserver has experienced a significant change in free space ...
5
votes
4answers
5k views

How can I get alerted when auto-growth occurs on a SQL Server database?

Our SharePoint databases are set to the (nonsensical) 1MB default autogrow out-of-the-box, and I need to "convince" our application owner that this is wrong. Is there a means to monitor the autogrow ...
2
votes
3answers
2k views

What RAID level do you use on SharePoint databases?

When configuring the storage for your SharePoint databases what RAID level do you use? The scenario I'm looking for is for a medium to large farm. What I'm interested in is how the different ...
2
votes
4answers
2k views

SharePoint - Do DPM and SQL backups affect each other?

I am trying to clear up an ugly maintenance plan on SharePoint databases that happen to also be backed up by Data Protection Manager (which is setup to take snapshots at 15-minute intervals). The ...
0
votes
3answers
749 views

Configuring MOSS and Reporting Services on a Domain Controller

I'm working on a pretty standard MOSS virtual development environment. I have MOSS, sql 2005 and the machine is also the Domain Controller. I'm now doing some work with Reporting Services (SSRS) and ...
4
votes
3answers
3k views

How long should I expect CheckDB with REPAIR_ALLOW_DATA_LOSS to run

I am running CheckDB with REPAIR_ALLOW_DATA_LOSS on a Shairpoint search DB that is 47mb It has been running for > 30min. Is that normal? How long should it take?
3
votes
4answers
45k views

How do I populate a SharePoint list with data from an external SQL database?

This is a tossup between whether it belongs on Stack Overflow or Server Fault (but since I am not a developer, and am looking for a no-code solution, I'm starting with SF). Is there an easy way to ...
6
votes
4answers
13k views

What's your best practice Recovery Model for SharePoint databases

Paul Randal asked some really nice questions about best practices for SharePoint SQL databases. Today, while helping a customer to maintain SharePoint installation he asked me a question about best ...