1
vote
2answers
34 views

Who has permission to see what?

We just encountered a problem in our site - 95% of the security permission settings that we had in place were lost. We have added them back manually and suspect we have added them back 95% correctly ...
0
votes
0answers
9 views

How to browse a multidimensional OLAP cube in SharePoint 2013?

I have an instance of SQL Server 2012 analysis services (multidimensional not tabular) with a couple of cubes. I want to browse the cubes from a SharePoint 2013 enterprise edition site. I tried using ...
0
votes
0answers
16 views

Migration from SQL server 2008 to 2012

I am upgrading MSSQL 2008 to MSSQL 2012. This box contains all of the DBs for our Sharepoint installation. We have identified that we can run the setup wizard to change the database and basically ...
0
votes
0answers
28 views

Downgrade SQL Server edition from Enterpise to Standart

Maybe somebody faced with the same task and have solved it successfully. If so then, Is there any way to save Web Analytics service application data? Will Search Service Application normally recover ...
0
votes
0answers
22 views

SharePoint remote blob storage confusion

We are considering using RBS with SharePoint 2010. I have researched it but I am still confused about one scenario. We want to store our BLOB's (mainly videos as files) on a NAS. I have read it is ...
0
votes
1answer
62 views

How to install SharePoint 2013 Installation with SQL Server Authentication

I'm just curious about the steps required to install Sharepoint 2013 using SQL Server Authentication. Also if there are any drawbacks that i might not be aware of. Here are some steps i currently ...
0
votes
0answers
27 views

PerformancePoint services 2013 with SQL Server 2008

I am trying to use performancepoint 2013 services to create a report that simple displays a set of columns from SQL Server Table. Apparently, PerformancePoint services can only display data from ...
0
votes
1answer
52 views

SQL Server Standalone and Sharepoint connected to a domain

I am currently in the process of setting up a client that wishes to use SharePoint. They currently have a Enterprise version of SQL Server 2012 running in a standalone environment and is not connected ...
0
votes
2answers
56 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
20 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
63 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, ...
2
votes
2answers
147 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
89 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
2k 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
72 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
1answer
2k 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
4k 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
39 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
1answer
36 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
3k 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
453 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
435 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
130 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
159 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
730 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
119 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
527 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
320 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
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 ...
0
votes
1answer
272 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
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 ...
1
vote
1answer
854 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
758 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
673 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
957 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
361 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
56 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
961 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
45 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
240 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 ...
1
vote
3answers
3k 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 ...