SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
240 views

SharePoint 2010 Farm Setup : Virtualize the SQL Server 2008 or NOT?

2 years back when I was working on SharePoint 2007 , virtualization of SQL Server was not recommend due to performance and clustering issues. When it comes to SharePoint 2010 , I see most of the MVPs ...
2
votes
2answers
1k views

Import a SQL Server table into a SharePoint list to use in InfoPath

I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.
1
vote
3answers
3k views

Content Database showing 0 (zero) site collection after content database attach

I have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server ...
1
vote
1answer
169 views

Which identity is being used and authenticated while connection to SQL Server with Windows Authentication?

SQL Server Windows authentication uses application's process identity or thread identity to connect. So, for a solution deployed to a SharePoint farm which identity will be used to connect Current ...
1
vote
1answer
826 views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
1
vote
3answers
727 views

SharePoint 2010 - Generate reports from SharePoint Database?

It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ? I heard maybe it is possible with the WSS-Logging Database. Are there ...
1
vote
2answers
2k views

Moving Sharepoint Foundation 2010 from SQL Express 2008 R2 to SQL Server 2008 R2

We have a very small Sharepoint Foundation 2010 farm with a library and some workflows. We want to build this originally on one server using SQL Server Express 2008 R2. However, there is a chance ...
0
votes
2answers
73 views

SharePoint 2010 installation - sql server

Simple question... Is it a requirement that SQL SERVER be installed on the same machine SharePoint is on? This is for a development installation... I.e. could I have SharePoint setup on one VM and ...
0
votes
1answer
50 views

Backup Plan for a VM based sharepoint website

I developed a doc sharing website for my company using Sharepoint2010 and SQLServer 2008 R2. The website is on a virtual machine powered by Hyper-V Now, I am thinking the disaster recovery plan. ...
0
votes
1answer
133 views

Not able to configure ssp on MOSS 2007 server

I am not able to configure ssp on MOSS 2007 server. I found that OFFICESERVERS service was not running. I checked system event log I got this error: The SQL Server (OFFICESERVERS) service terminated ...
1
vote
2answers
1k views

SQL Hardening, BCS, and ECT (SharePoint 2010)

Currently running into some errors when trying to setup External Content Types with SharePoint 2010. The goal is simple which is to connect to a SQL Server and pull information into SharePoint to an ...
4
votes
1answer
3k views

Form for user to input data and submit to run sql command

We're looking for an quick and easy way for an HR person to enter data into a couple fields and then have them click submit and have it execute some SQL Update query on the database. We don't need to ...
0
votes
1answer
84 views

SP2010 Install on virtual [closed]

I started to work on a home based play project where I wanted to created at least 2 VM (using vmware). Server 2k8 went good. then I moved on to setup AD (DC) and completed this piece. next step was to ...
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 ...
0
votes
1answer
89 views

Always Sync Form Library Columns data with SQL Server 2008

How do I set a "always-sync" connection between a Form Library and a Database (in SQL server 2008)? Scenario: I have a Form library that use InfoPath form. In the form library, there are multiple ...
1
vote
1answer
1k views

How to design for large content databases?

Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...
1
vote
1answer
151 views

Advantage of SharePoint aware mirroring compared to normal SQL mirroring?

We are going to implement mirroring for our databases in order to increase the data redundancy. Our understanding is that SQL clustering won't help for this. Can someone please explain for me why we ...
1
vote
2answers
2k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
1
vote
1answer
280 views

Finding the location of the SharePoint Configuration Database in API

I'm building a .NET Health Analyzer Custom Rule which checks a few vital signs of another custom application I have built, however if the application is also deployed on a server that is also hosting ...
0
votes
1answer
5k views

Add login account to access “WSS_Content”

I need to run the SharePoint Content Deployment Wizard (2.8) on SP 2010. It tries to read the database "WSS_Content" using my login account but keeps blowing up with this error when it tries to do the ...
3
votes
4answers
1k views

What is the recommended way to query data on a Sharepoint site?

Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
2
votes
2answers
282 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
436 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
680 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
8k 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
242 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
4k 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
754 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
416 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
194 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
861 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
559 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
496 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
4k 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
862 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
428 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
848 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
191 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
12k 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
505 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
12k 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 ...