SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
1answer
494 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
0answers
52 views

Upgrading default SQL server express of SharePoint 2010 for reporting services

I need to upgrade default SQL server express of SharePoint 2010 with SQL Server 2008 Express with Advanced Services. What are the things I should keep in mind before upgrading? Thanking you in ...
0
votes
1answer
953 views

Databases for Sharepoint Foundation 2013

I recently installed Sharepoint 2013 onto a test server to look at the possibilities of upgrading our 2010 instance. After the installation, I noticed that far more DBs were created on my SQL Server. ...
5
votes
1answer
223 views

Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm

I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups. Essentially we're running ...
0
votes
1answer
53 views

How to backup specific ListItems to database?

We are running a ticketsystem on Sharepoint 2010 which got alarmingly large over the last few months. The ListView Threshhold currently sits at 15k for this WebApplication. I am currently looking for ...
0
votes
0answers
79 views

After shrink the error still occurs

When I try to save the aspx page an error occures. It says "....It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web". At SQL Server Man. ...
0
votes
1answer
1k views

InvalidOperationException after promoting SharePoint server to domain controller

I installed SharePoint 2013 Standard on Windows Server 2012, and it was running fine until I decided to make the server a domain controller: Remove the ADCS role Remove then re-add the ADDS role ...
1
vote
1answer
60 views

Document storage in sharepoint

By default, Sharepoint stores the documents in Sql Server. It may give performance issue if we have large files(say 1 TB). So, how do we overcome this or do we have any other way of storing ...
1
vote
2answers
450 views

401 Unauthorized after database move to new SQL Server

I need some assistance trying to figure out what is going on. We have been running our test SharePoint and test SQL together on the same server and it has been doing ok, but we decided to move SQL to ...
1
vote
1answer
132 views

Sharepoint 2010 - Delete Picture Library

I had picture library on Sharepoint with 500MB of images. I have deleted it from site and farm level also. But data still rely on SQL DB. I have daily backups on server. Before uploading images daily ...
0
votes
1answer
216 views

User Profile Synchronisation from SQL Database

I am trying to update the Manager and Profile Picture properties for the UPS from SQL. The problem is that these two fields are stored as text in SQL but SharePoint expects a Person field and URL ...
1
vote
1answer
105 views

Sharepoint 2010 multilingual support and SQL Server 2008 Collation

I am wondering when I install my respective SQL Server 2008 R2 database for Sharepoint if I will need to set the collation to anything specific to support Sharepoint's multilingual capabilities?
0
votes
1answer
146 views

Connect SQL Server installed local machine with Sharepoint VM

I need to install SharePoint (Farm based installation) on VM and I have installed SQL Server 2008 R2 on my local machine. How can I connect both the machines so that I can use sql instance settings ...
0
votes
1answer
702 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 ...
0
votes
3answers
161 views

Installation of SQL database on local machine as opposed to Virtual machine

I have configured Virtual machine to install Sharepoint 2010. The virtual machine is configured as; a. OS: Windows Server 2008 b. Active Directory Configured (Domain Name as "DOMAINNAME" is ...
1
vote
1answer
747 views

SharePoint 2010 - Force to use non-1433 SQL Port

In my farm, I was using the standard 1433 port for SharePoint to communicate with SQL. Our project lead came down with the order to change the SQL port to a non-standard port from 1433. I went ...
0
votes
1answer
144 views

Auto-Update Statics On/Off

MS recommends disabling auto-create statistics on SP DBs (ref). What about auto-update statistics? Looking at our TFS installation, for the SP DBs, these two options are disabled for you when TFS is ...
1
vote
2answers
2k views

Content Database Is Not Listing In SQL Management Studio

I have created a new SP web application and the content database name which I have given is WSS_Content_Test. Application created successfully(I checked out and found IIS Website and App pool is ...
1
vote
0answers
120 views

BCS connection with SQL DB and Sharepoint list passing parameters

Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...
0
votes
1answer
45 views

list updation in list loadvent

I have a custom list that contains a row of data. The data in the list is created from the data in the table in the SQL table. I need to check the data in database table and the data in the list is ...
3
votes
1answer
87 views

SP2010: What happens when starting several Content deployment jobs at the same time?

what happens if I start several content deployment jobs synchronously in different site collections by ContentDeploymentJob.Run()? Are the jobs definitely executed one after another? Thanks!
0
votes
1answer
826 views

Does Sharepoint 2010 Enterprise work on SQL Standard version?

We are planning to get a backup server at Amazon EC2. As per my finding, Amazon supports only SQL Standard version. Can someone please help me with the above question. And, will any services be ...
0
votes
2answers
124 views

External list not implementing TimeSpan field

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
0
votes
1answer
151 views

SQL Server Agent in my Web Farm

Im trying to setup some scheduling in my SharePoint 2010 Farm, where I have 2 WFE's and 1 DB server. In attempting to setup a scheduled task, I received the error "The SQL Agent service is not ...
1
vote
1answer
206 views

All about SharePoint licences

My question is regarding the licensing of the SharePoint, basically there was already a topic done about it, but it had just bunch of references to website which i already saw and i still didnt get my ...
0
votes
2answers
435 views

Problem with connectivity and OWSTIMER.exe

Our stagging environment is on a single server with 3 virtual servers, Database Server K2 Workflow Server WebFrontEnd Server Now time to time I am getting this exception for a webpart in event ...
1
vote
2answers
92 views

How can i retreive data from Web Server to my Intranet SP site

Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site ...
0
votes
1answer
544 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) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint. The prerequisites clearly show that Sharepoint 2010 SP1 is needed, ...
2
votes
1answer
620 views

Problem with PowerShell script in Tasks Sheduler Windows Server 2008 R2 - SharePoint Shell Access?

I have a problem with PowerShell script in Tasks Sheduler in Windows Server 2008 R2. I try to run Sheduler Tasks which run batch file which run PowerShell script to Backup Farm and while I choose "Run ...
0
votes
1answer
1k views

How to Create Analysis service Data Source for SharePoint Dashboard designer?

We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source. So can anyone ...
0
votes
1answer
323 views

Does the membership seeder tool to add new FBA users, use the createuser method?

Does the membership seeder tool to add new FBA users, use the createuser method? Here is the link from where I downloaded it: http://cks.codeplex.com/releases/view/7450
0
votes
1answer
674 views

InfoPath 2010: Populating drowdown from SQL on load form

I have a data connection to SQL database already set and for the form to query the database on form load. In the dropdown list property I have it pulling from an external data source and in the ...
1
vote
2answers
1k views

Cloning a SharePoint Server 2010 (Virtual Machine) production box?

Here is the long and short: Goal: To clone a SharepointProd VM retaining all the webapps and sites in order to debug a custom solution. We have two virtual machines: spTest and spProd. spTest is ...
0
votes
2answers
69 views

VS2010 then SP2010

Goal: Using Sharepoint 2010 in my client computer with Windows server 2008 Problem: Should I install Visual Studio 2010 first then install Microsoft SharePoint Server 2010 64-bit and then install SQL ...
1
vote
2answers
438 views

Migrate Sharepoint 2007 to 2010

So right now there's a SharePoint 2007 site filled with data. I have to migrate EVERYTHING properly from the SharePoint 2007 site to a new server that has SharePoint 2010 and Windows Server 2008 ...
1
vote
1answer
84 views

SQL Server 2008 Installation on SP 2010

I'm installing SP 2010 on Virtual Machine Windows Server 2008 R2. My Question: Is it necessary to install SQL Server 2008 (or R2) before installing Sharepoint Server 2010? Plus, when installing SQL ...
1
vote
2answers
2k views

SharePoint Business Connectivity Services (BCS) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I am running SharePoint 2010 with SQL 2012, I am trying to get Business Connectivity Services (BCS) running but I am facing a double-hope authentication issue. Every time I try to connect to the ...
1
vote
1answer
650 views

DispForm.aspx taking 5+ minutes to load on SP2010 Server, high CPU utilization

We have one list that has about 55 columns. Most of these are very simple columns (number, text, choice), though there are four that are Lookups to another list. All four lookups columns lookup ...
0
votes
1answer
34 views

Upgrading from SQL 2005 to SQL 2008R2 with RBS support

I am looking at setting up Sharepoint 2010 in our local test environment and our current test SQL server is running SQL 2005. I am just wondering if it is possible to upgrade the database later to SQL ...
0
votes
1answer
274 views

Attaching and restoring document library files from a .mdf config database file?

We have a Symantec backup system that runs through all of the instances on a SQL2008 box and backsup data, I would like to restore a corrupted document library and am wondering as to how I would ...
0
votes
3answers
2k views

Populate Data From SharePoint List to a SQL Table

Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that ...
2
votes
1answer
419 views

File size too large with RBS and SharePoint 2013

since i set up my SP2013 Foundation Preview with SQL Server 2008 R2 Express i wanted to use the RemoteBlobStorage. It works seemingly fine just now. The only problem is if my files which im uploading ...
0
votes
1answer
671 views

Microsoft SQL Server 2008 R2 (RTM)upgrade query?

Will SharePoint Server 2010 SP1 be compatible for an upgrade to SQL Server 2008 R2 SP2 CU2 from Microsoft SQL Server 2008 R2 (RTM)? If we upgrade(from Microsoft SQL Server 2008 R2 (RTM)) Is there any ...
1
vote
2answers
58 views

Backing up all sharepoint web applications?

I have a sharepoint farm hooked to a named instance of SQL2008. I have a web application (it is also extended to another web app) that I would like to back up. Here is what I am trying to achieve: I ...
0
votes
1answer
376 views

Event Receiver Item Added for Multiple Files uploaded

I am trying to add few details for a item that is added to a list to SQL database table using a stored procedure, it works perfectly but when I upload multiple files it adds all of the items into the ...
-1
votes
1answer
45 views

powerpivot configration

i installed sql server 2008 and SharePoint 2010 and finished the installation of the pivot but when i clicked start - 1 all programs -sql server 2008 - configuration tools - (but the only thing exist ...
1
vote
1answer
861 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
2answers
53 views

SQL Server 2008 Install / Data Location

Am about to try and install SQL Server 2008 R2 for the second time. How and when during an install can I configure my data to be held on the D:/ drive as opposed to the default C:/ drive?
0
votes
2answers
2k views

Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?
1
vote
1answer
770 views

Change SQL Server Port for existing SharePoint 2010 environment - Howto

I have a SharePoint 2010 environment configured with SQL Server 2008R2. Currently SQL Server is running on 1433. I am willing to change the existing SQL server port from 1433 to some non standard ...