0
votes
2answers
11 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
18 views

Sharepoint data base management

Dose anyone know a tools for SharePoint content data base management (add/remove,attach ... the content database )
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, ...
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 ...
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?
3
votes
1answer
849 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 ...
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 ...
0
votes
0answers
81 views

Performance Point Time Intelligence Filter is Interpreting the Time Dimension Wrongly

I have a SQL Server with the Submit Date field having dates in the format YYYY-MM-DDThh:mm:ss. Similarly, I configured SSAS to connect to the SQL Server Table and created a cube on top of it. Then, ...
0
votes
0answers
22 views

Become a SharePoint Developer

I'm a BI developer with SQL server as a primary tool and I started learning to become SharePoint developer. What benefit from BI developer's perspective can it provide business value as a ...
0
votes
1answer
865 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
2k 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
36 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
91 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
29 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
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
1answer
244 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
278 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
108 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
140 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
537 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
110 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
370 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
270 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
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 ...
1
vote
1answer
81 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
237 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
55 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
814 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
618 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 ...
2
votes
2answers
554 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
856 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
316 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
55 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
915 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
42 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
237 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
2k 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
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 ...