SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

2
votes
2answers
265 views

Should we have thousands of sleeping database connections from the Crawler server?

Our IT Manager has brought up a situation where it looks like we have about 5000+ sleeping connections from the Crawl Server to our SQL Server. This seems like quite a bit and it's been slowly ...
2
votes
1answer
2k views

Tutorial to move WSS 3.0 DBs from Windows Internal to SQL 2005 Instance

I have found or have been told about a few ways to move WSS 3.0 databases from the Windows Internal Database to SQL Server 2005. As I read them, however, I find I have more questions. Two I found ...
0
votes
1answer
416 views

How to get real file path from a BLOB

I have a situation in which data (mostly images) is stored in a BLOB. As you know data in BLOB are guid like which I cannot relate to any file. My question is, is there a way by which I can extract ...
0
votes
1answer
647 views

SharePoint Farm SQL Server tempdb/Crawl DB disk configuration

We've identified I/O latency on SQL Server portion of our farm. We see tempdb and CrawlDB are biggest offenders. We have 2 extra Raid 1 disks available to us. Let's call them X: and Z:. The ...
1
vote
2answers
7k 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 ...
1
vote
2answers
5k views

Can't Create External Content Type linked to SQL Server

In Sharepoint 2010, I am trying to create an External Content Type, and use a connection to a SQL Server. But, in Sharepoint Designer, when I am in the wizard to create an ECT, I'm having trouble ...
3
votes
1answer
239 views

Which version of SQL Server Express gets installed with Search Server Express 2010?

What exact version of SQL Server Express 2008 gets automatically installed via the standalone setup of SSE 2010? Is it just SQL Server Express 2008, SQL Server Express 2008 R2 or a special kind of ...
4
votes
4answers
3k views

Why is SharePoint_Shell_Access permission required to run SharePoint powershell?

So we're setting up a SharePoint farm and it seems our admin accounts require access SharePoint_Shell_Access role on SQL. http://technet.microsoft.com/en-us/library/ee806878.aspx ...
6
votes
4answers
1k views

Reusing and parameterising BCS External Content Types

I recently posted a query here that asked about the best way of connecting to an external SQL store. I got some great responses back but need a little more info, specifically around External Content ...
2
votes
2answers
727 views

Cannot update DB record from SP timer job

I am trying to create a timer job that will read a list of new customers from a SQL server db, create a site for the customer and then update the table with the site's id. I have no trouble reading ...
11
votes
3answers
407 views

SharePoint database maintenance for the non-DBA

Question ported from Serverfault as it is specific to database maintenance for SharePoint administrators: For SharePoint administrators, SQL Server is often a black box that is installed as a ...
0
votes
2answers
3k views

SSIS Import Sharepoint 2010 List to SQL Server

Is there a way to do this via code? How so? I simply want to import data from a list in SharePoint 2010 to a SQL 2005 or 2008 server. I know there are several 3rd party plug-ins that work, but I ...
1
vote
1answer
190 views

Remote Blob Store implementation. How to get current SQL Server DB name?

We are trying to develop Remote Blob Store (next RBS) provider for SharePoint 2010 (SQL Server 2008). In EBS (External Blob Store which is deprecated now) there is possibility to take site collection ...
2
votes
1answer
838 views

Restore Content Database to a different farm (Prod -> Beta -> Dev Servers)

My end goal is to have some code that automatically takes the Content Database backup from Production and automatically nightly restores it on Beta. Can I just do backup and restore sql commands? Or ...
1
vote
1answer
542 views

Is it possible running SharePoint Foundation 2010 on the following environment?

I would like to know if the following environment is supported by SharePoint Foundation 2010: OS: Windows Server 2003 R2 DB: SQL Server 2005 Standard Edition (with license model for CPU) If not ...
2
votes
1answer
447 views

What permission does my search service account need for external database searches?

The farm admin for my SharePoint site has a different Default Search Service Account login than the one I am using to create my external content types (which is my personal log in). When I am trying ...
1
vote
1answer
3k views

Thread was being aborted with Sharepoint 2010

I have recently upgraded a custom app to sharepoint 2010. The same code worked fine with sharepoint 2007. The error that is being thrown is "Thread was being aborted". The stack trace is at ...
1
vote
2answers
126 views

Allocation of RAM to use in server virtualization

I'd like to create three or four virtual machines on my Windows Server 2008 R2 OS (single server farm for now), and I'm wondering how much RAM to allocate to each virtual if the host has a total of ...
0
votes
2answers
852 views

Configuration for timer job Sharepoint 2010

I have a timer job that needs to connect to a SQL Database. Where would one typically store this connection string. In normal app development, one has app.config. Clearly using app.config in this ...
1
vote
1answer
1k views

Aliasing the SQL Server name

I'm creating a new SP 2010 farm that will replace our existing 2007 farm (using the db attach method), and decided I should probably use SQL aliasing with this install. So 2 questions relating to ...
4
votes
3answers
7k views

How do I populate a SharePoint list from a SQL table?

I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.
0
votes
1answer
427 views

How can I update an external list connected to SQL?

I am working with Project Server 2010 and SQL Server 2008. I would like to create a multiple item form that connects to SQL Server. I tried using an external list in SharePoint that connects to SQL. ...
0
votes
1answer
807 views

How do I link (join) a sharepoint list and an external data source in a DVWP?

I've got an external data source (SQL Server) and a Sharepoint Custom List that I want to join in a single view using the data view web part. In theory this shouldn't be too hard, but I can't get it ...
0
votes
1answer
189 views

How do I get sorting to work in the DVWP when using custom SQL query to linked server?

WSS 3.0 I have a non-SQL database linked to a SQL database. I've created a datasource in SPD using a custom query to this database. select * from LINKEDDB...sometable I then created a data view ...
4
votes
2answers
2k views

Execution of code as Application Pool account

Here is what I'm currently trying to do - 1.Create a new instance of a timer job from a web part 2.Add a new site collection to the current web application again from a web part Each time the code ...
1
vote
3answers
11k views

Can I use a SQL Express database for sharepoint 2010?

I'm setting up a dev system with only 2 site collections, is it possible to run an express version of SQL 2008 R2? I'm not too worried about performance, mainly that it will install and run for dev ...
1
vote
1answer
1k views

Upgrade SQL 2008 R2 Standard to Enterprise Edition in SharePoint 2010

We are using SQL 2008 R2 Standard edition with SharePoint 2010. If we decide later on to upgrade to the SQL 2008 Enterprise edition, what is the process and the impact on the SharePoint environment?
1
vote
1answer
496 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...
1
vote
2answers
11k views

database size would exceed your licensed limit of 4096 MB per database

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some ...
1
vote
1answer
621 views

MOSS 2007 SP2 DB index maintanance

I've read in the "About Service Pack 2 for SharePoint Products and Technologies" paper that SP2 includes an update for the Update Statistics Timer Job that causes SharePoint to run SQL Server's online ...
0
votes
1answer
2k views

config wizard fails at step 2 after creating database

I have been having a lot of trouble installing WSS 3.0 on windows server 2008, usign SQL 2008. I have found often the solution where it asks to create the db usign the psconfig command line but ...
0
votes
2answers
500 views

Trimming audit events

We'd enabled all types of audit events for our production web-application and ended up with an issue with DB as auditData table grown to 50GB. Now, we want to reduce the size of the AuditData table. ...
2
votes
2answers
253 views

Database migration problem

We have recently migrated our MOSS databases from MS SQL Express 2005 to MS SQL 2008 both intances running on the same Windows 2003 server. After "successful" migration we switched the 2005 server ...
2
votes
2answers
671 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
1
vote
1answer
434 views

SharePoint Learning Kit database error

I have installed the Microsoft SharePoint Learning Kit but when I'm configuring the SLK it gives the following error: 'CREATE DATABASE permission denied in database 'master'.' Does anybody know what ...
2
votes
1answer
444 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...
1
vote
1answer
425 views

Get/Connect to Local Sharepoint SQL Instance

How does one find the name of, or connect to the SQL instance, that SharePoint uses when you perform a basic/local install?
1
vote
2answers
115 views

Extra database server in farm

Recently I was looking at Central Admin > Operations > Servers in Farm and noticed an extra database server. It is the same name as the actual database server with "-Common" appended to the end. This ...
7
votes
5answers
5k views

SQL Server 2005 vs SQL Server 2008 on SharePoint 2010

I'm writing a recommendation for an upgrade scenario from SharePoint 2007 to SP2010. Customer is currently running x64 SQL Server 2005 SP3 on Windows 2003 Server. Does anyone have pros/cons for ...
2
votes
2answers
1k views

Changing to SQL alias after installing MOSS

Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but ...
2
votes
2answers
566 views

What MOSS issues can I expect with default SQL Server 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
593 views

SharePoint 2010 Beta 2 with SQL 2008 R2

Are there instructions for installing SharePoint 2010 Beta 2 with SQL 2008 R2? I notice that none of the installation resources thus far describe using R2. (At the time of writing R2 is at November ...