SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
0answers
18 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
748 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: ...
1
vote
2answers
104 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, ...
1
vote
1answer
91 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
474 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 ...
2
votes
2answers
456 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
390 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
85 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
3answers
137 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?
8
votes
9answers
6k views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
1
vote
4answers
3k 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 ...
0
votes
1answer
26 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
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 ...
3
votes
1answer
414 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 ...
0
votes
0answers
2k 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
50 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
1answer
86 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
1k 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
5k 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
648 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 ...
3
votes
2answers
10k 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: ...
2
votes
1answer
48 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 ...
2
votes
1answer
232 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
62 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
85 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
112 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
257 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 ...
1
vote
0answers
636 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
2
votes
0answers
67 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
1
vote
1answer
239 views

How to provide highly available, disaster recovery solution for SharePoint 2013 deployment?

We need to provide highly available, disaster recovery solution for SharePoint 2013 deployment. For this purpose, we've to build environments for two data-centres, one would be primary DC1 and another ...
0
votes
1answer
389 views

List item storage in SQL

So I'm having some performance issues with some large queries against SharePoint (yes, I'm already using CAML), so I decided to take a peek at the SharePoint database despite the dire warnings never ...
1
vote
1answer
546 views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
1
vote
0answers
206 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
0
votes
1answer
99 views

how to work with form based authentication in SharePoint 2010 three tier architecture?

I am working on SharePoint2010 site created on three tier architecture. I want to use the form based authentication method. I have prepared the form based authentication on web application but ...
1
vote
3answers
929 views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
0
votes
1answer
176 views

SQL Database Login Failed

The SharePoint logs, as well as in the event viewer keep popping up the following error: 'SQL database login for 'DBTable' on instance 'DatabaseServer' failed. Login failed for user ...
0
votes
1answer
270 views

Which versions of sharepoint support sqlserver read commited snapshot isolation?

I have been unable to find out if Sharepoint 2010 or 2013 (or even 2007) are able to take advantage of this MSSQL feature to improve the performance of the database operations invoked by Sharepoint ...
0
votes
2answers
506 views

Inserting new list items into SQL

When I add new item into the list, I have to insert the items into the SQL database. How can I do it? Any clue is good for me.
0
votes
1answer
3k views

Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”

My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition WF1 WF2 Both Web Fronts are NLB, and we have they following Application Servers APP1 - ...
1
vote
2answers
2k 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. ...
0
votes
1answer
5k views

There are no SQL Server instances or shared features that can be updated on this computer

I am trying to install SQL server 2008 r2 on Windows server 2008 r2, I have the SQL server installed in an ISO image and the windows server is on a VM workstation, but during the installation I got ...
1
vote
0answers
44 views

Which installation option I should use for SQL server 2008 to work with SharePoint 2013

I want to prepare a development environment for SharePoint 2013, so I want to know which SQL server option I should use from the SQL server 2008 installation center , the available options are:- 1.New ...
0
votes
5answers
2k 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
47 views

wss 3.0 content database has expanded exponentially without any data added in it

I am hosting wss 3.0 web application in windows 2003 server with sql 2005 express edition. we are leveraging lots of out of the box functionality, but we also have some custom features and web parts. ...
0
votes
1answer
49 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
4k 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
1answer
279 views

Development with SQL Data Source in Visual Studio

There is a sql database. I want to get datas and display them as a list. And I want to filter the datas too. But I can't find any basic tutorial to do it. I don't know where to begin. Where should I ...
0
votes
1answer
548 views

SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message - ...
1
vote
1answer
910 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
340 views

Change SQL Server service account

I need to change the Service Account for Sql Server (i.e. I need SQL Server to run under a different account). Can I just change the account or do I need to perform some Sharepoint configuration as ...