Tagged Questions

0
votes
1answer
22 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 - ...
0
votes
1answer
62 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
24 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
0answers
21 views

instalation media for sql server 2008 r2 to be used with sharepoint 2013

I want to install an SQL server r2 2008 from and ISO imagE to my VM windows server 2008. but when i try to create a new NON-CLUSTERED SQL server i was asked to specify the installation media for SQL ...
0
votes
0answers
22 views

Deploying SSRS report from BIDS to SharePoint 2010

I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
1answer
12 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
0answers
132 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
0answers
8 views

Find Data for Microsoft Project in SharePoint enterprise

Goal: To view the table's data of the database for Microsoft Project from SharePoint 2010 and/or 2013 enterprise. Problem: Where can I find the raw data for Microsoft Project in the database? I would ...
0
votes
0answers
39 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 ...
1
vote
2answers
71 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
43 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
3answers
92 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 ...
0
votes
1answer
194 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 ...
1
vote
0answers
81 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
0answers
54 views

Have problem to display the SOAP data connection to a our Sharepoint site

I am using the SOAP data connection and i retreive data from my Web server but when i insert the SOAP data connection in the new page zone it's give me the display as HTML Code not as Text content : ...
0
votes
1answer
213 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, ...
0
votes
1answer
149 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
1
vote
2answers
427 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 ...
1
vote
1answer
70 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 ...
0
votes
1answer
187 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 ...
1
vote
2answers
51 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 ...
1
vote
1answer
644 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?
1
vote
1answer
397 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 ...
0
votes
0answers
165 views

How create an infopath form for sharepoint that receive and submit data to sql server database?

I want to create an infopath form for sharepoint, this form will submit and receive data from SQL Server Database. What I've done this far: I've created an infopath form with data source from sql ...
2
votes
2answers
445 views

Migrating Windows Sharepoint Services 3.0 from Windows 2003 x86 / MSEE to Windows 2008 R2 x64 / SQL Server 2008

I am having a helluva time with this one. I am attempting to migrate a 5 year old VM running Windows 2003 Windows Sharepoint Services 3.0 that was deployed as a standalone (thus to MSEE) to a ...
1
vote
2answers
594 views

Installing SSRS on the Sharepoint Box as opposed to the SQL Box?

We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases. We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
0
votes
1answer
244 views

Migrate Access to SQL Server for SharePoint Integration & Reporting

I'm hoping to get some feedback on this multi-parted problem. The end goal with this problem is to create reports within SharePoint from data contained in some db. Currently, an Excel report exists ...
0
votes
2answers
53 views

Reporting Server Integration with Sharepoint Server 2010

I have a Sharepoint server 2010 Enterprise in a public domain and a SQL2008 standard in a local domain (with an installation of sharepoint 2010 to support report integration). Does Microsoft support ...
0
votes
2answers
666 views

SharePoint 2010 Licensing with 10k employees

I am doing my homework and I need to get rough costs for licensing SharePoint 2010 for company with 10,000 employees. I made an assumption that a company runs on Windows Server R2. The SharePoint 2010 ...
0
votes
1answer
40 views

SQL Server New or Existing for a Sharepoint Installation

We have a Sharepoint farm that uses a SQL Server. I need to create another Sharepoint farm. Can i reuse the same SQL Server or do i need a new one?
1
vote
1answer
212 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 ...
0
votes
3answers
1k 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
2answers
839 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 ...