SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
0answers
16 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
2answers
10 views

SharePoint 2010 Install with SQL Server 2008 Express which is missing agent service, SharePoint will work?

I am installing SharePoint 2010 with SQL Server 2008 R2 Express on Windows Server 2008 R2. During installation of SQL Server, I have noticed Agent service is not in the service list, I goggled and ...
0
votes
1answer
26 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
22 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
31 views

Stuck backup process - Backup or restore is already running

From a few days I'm not able to performe backup. Backup always stuck on the same level - eg backup files have 10GB in jobs I see running backup proces and that it, backup stuck. When I delete that job ...
1
vote
2answers
780 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. ...
1
vote
1answer
664 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. ...
0
votes
1answer
18 views

Sharepoint data base management

Dose anyone know a tools for SharePoint content data base management (add/remove,attach ... the content database )
0
votes
2answers
40 views

Error in User Profile Service connection (it was working fine before)

I noticed the following error on that page where you define connection for User Profile Service Synchronization. An error has occurred while accessing the SQL Server database or the SharePoint Server ...
1
vote
1answer
2k 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: ...
0
votes
1answer
243 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
1answer
449 views

SQL Server 2012 - service account error

I am getting the following 2 errors when trying to install SQL server 2012 on Windows Server 2012. These occur at the server configuration page. Access is denied. The SQL Server service account ...
1
vote
1answer
27 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
0answers
11 views

Submitting list data to SQL

I'd like to submit data from a Sharepoint List to my SQL Database. I want the user to be able to create a new list item, attach a file and then once added it will write to an SQL Database. How would ...
2
votes
2answers
61 views

Is it suggested to restart SQL servers regularly?

In my experience, all Microsoft products need to be restarted regularly to keep the memory allocation healthy. But I always think it is an unofficial practice until I see this article: ...
0
votes
0answers
19 views

Expand SharePoint Calendar Recurring Event in SSIS Project using CAML

Is it possible to expand recurring SharePoint calendar events using a CAML query in a SharePoint List Source using the SharePoint adapter off of Codeplex? I have been searching all day and found many ...
0
votes
0answers
9 views

Creating a BCS conectivity with Sharepoint Designer 2010 with MS SQL server 2005 (Externall Table)

When I tryied this Link and Connect with server 2005 : http://kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/ Get a lot of errors with tables(No One ...
1
vote
2answers
30 views

How to use SQL tables as SharePoint lists?

We are creating a new SharePoint site for an existing application (.NET & SQL). Now, we need to create few lists and use existing SQL tables as SharePoint lists. Is this possible, how to do it, ...
0
votes
0answers
26 views

Row-Wrapping… What limit?

Currently at site collection level on this instance of which is single on both counts, row-wrapping is set to 6. I want to increase this to 7. Traffic is based on 300 or so office employees of which ...
1
vote
1answer
15 views

Can multiple MS-Access 2007 front ends be linked to an SQL Server 2008 backend on Sharepoint?

I have several computers at different locations, each with their own copy of an MS-Access 2007 front end. Each copy links to an SQL-Server 2008 back end on a server. I would like to migrate the back ...
2
votes
1answer
40 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
1
vote
2answers
55 views

Should we run SharePoint 2013 on Windows Server 2012 or 2008 R2

We are getting ready to start a project to bring up a brand new SharePoint 2013 Intranet/Extranet site and was wondering if we should be using Windows Server 2008 R2 SP1 or Windows Server 2012. I know ...
2
votes
1answer
61 views

Claim Based authentication on SharePoint 2013 and “Integrated Security”

I have a problem with a SharePoint 2010 application that now runs on SharePoint 2013. The application has been converted and seems to have no problem "from a code" point of view. The problem comes ...
0
votes
1answer
28 views

Backup/Restore which content database?

I have seen a few posts about backing and restoring SharePoint content databases from both Central Admin and using PowerShell. My question is relatively simple I hope..... There are a number of ...
1
vote
2answers
2k views

How can I tell SP installation of an existing SQL server

I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same ...
1
vote
0answers
262 views

Office Web Apps can't read/edit Powerpoint or read Word, but Excel reads/edits fine

A brief overview: I have a Sharepoint 2010 installation on Windows Server 2008 R2, with Office Web Apps installed. The Central Admin SQL Database in on the local server, but the SQL database that ...
1
vote
3answers
50 views

How can I archiving gmail hosted emails on SharePoint Server

I have my email hosted on gmail cloud server, and I am about to get SharePoint 2013. I would like to use SharePoint to archive my gmail email on-premise. Can you advise on what I should do?
1
vote
3answers
10k 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 ...
2
votes
1answer
43 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 ...
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 ...
0
votes
1answer
20 views

Is the IIS role necessary on a dedicated SQL server?

I haven't been able to find anything on this. I'm looking into only the bare necessities for a dedicated SQL server being used by a SharePoint farm. Is the Web Server (IIS) role necessary for a ...
1
vote
1answer
22 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 ...
3
votes
1answer
175 views

Extracting browser-compatible InfoPath 2013 form submission data into a SQL Server 2008 Database as well as a SharePoint 2013 list

We are looking at using InfoPath 2013 to capture simple sets of data without the need the need for writing custom applications. However, we still need the information to be stored in a SQL Server 2008 ...
1
vote
1answer
117 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 ...
4
votes
1answer
2k 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 ...
1
vote
2answers
6k 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 ...
0
votes
0answers
414 views

Critical error in event log after installation: Login failed for user

The following error will occur in the event log after starting my Windows Server 2012 server with SharePoint 2013 (Farm installation, not stand-alone): SQL Database 'SharePoint_Config' on SQL ...
3
votes
2answers
44 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
0answers
12 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 ...
0
votes
1answer
48 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
262 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
847 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
813 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?
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
2answers
2k 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 ...
2
votes
1answer
135 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
26 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
61 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
51 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
72 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 ...