CategorySharePoint

Rename SharePoint Central Administration Database

SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that has been created. The Central Administration site is no different and has its own content database that is created when running the SharePoint configuration wizard. Unfortunately, unlike when creating service applications, you do not get to choose the name of this...

SharePoint 2013 – Failed to install the product: D:globaloserver.msi ErrorCode: 1603(0x643)

I often do my SharePoint setups on virtual machines since I need to build them up and tear them down frequently. Hyper-V is a beauty when it comes to demo environments. A few weeks ago I was doing an install and got an error that was absolutely no help. [error]Microsoft SharePoint Server 2013 encountered an error during setup.[/error] Well thanks. That’s completely unhelpful. To the...

Setting the Default View on a SharePoint Library

There could be a number of reasons why you would want to change the default view on a SharePoint library. Perhaps you created a new view and want to make it the default. Maybe you created a PowerPivot library and don’t have Silverlight installed. The list could go on. Luckily setting the default view is really simple. Navigate to the library which you would like to change the default view...

SharePoint Reporting Services Content Types Missing

Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the necessary content types are those associated with SQL Server Reporting Services (SSRS). If you create a new document library and want to add the ability to create data sources, reports or even just launch report builder you will need to add new the reporting services content types to...

SharePoint SSRS “The permissions granted to user 'DomainUser' are insufficient for performing this operation”

Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with my SharePoint environment after a restore did go wrong. I was planning on blogging a bunch of it and thanks to time constraints I had to just get it backup and running and couldn’t take down notes about most of it. After getting everything back up and running I thought I was good to go...

Installing Power View for Multidimensional Models

  Power View was a new reporting option added in the SQL Server 2012 release as part of the SharePoint integrated mode of Reporting Services. From the beginning it was limited to only reporting off tabular models (and therefore PowerPivot models as well). Power View later made its way into Excel 2013, still maintaining support only for Tabular. That all changed when Microsoft announced at...

SharePoint 2010 on SQL 2012 Configuration Failed

Recently while doing an installation of SharePoint 2010 on a Windows Server 2008 R2 server with a SQL Server 2012 back end I ran into a small roadblock. The following error popped up as I was running the product configuration wizard.   [error] Failed to create the configuration database. An exceptin of type System.Data.SqlClient.SqlException was thrown. Additional exception information:...

Browse SharePoint in Windows Explorer

Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please upgrade to something a little more modern. In all seriousness, in SharePoint 2007 you could click on the Actions menu and then select Open With Windows Explorer. Simple. Easy. Fast forward to SharePoint 2010. The button is gone, but it’s not really gone. There are many reasons...

Office 2013 and SharePoint 2013 Beta

If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly SharePoint. The two follow the same release cycle and as of today (July 16th actually) they have released a public beta for Office and more importantly SharePoint 2013! If you are interested in the SharePoint 2013 preview you can head over here () and grab a copy of it. The...

Unsupported Features in Excel Services SharePoint 2010

Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced.  There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments. In Excel Services 2007 many unsupported features would cause the workbook to not load at all and have since had the behavior changed in 2010.  The...

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me