Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

Archives: December 2011

VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists

Virtualization is awesome! It really helps when you are a developer.  On my laptop I don’t even have SQL Server installed on the OS directly.  In fact the only thing I have installed on my host is Office, Skype and Chrome.  Everything else gets run on a VM.
SSIS package… Read more

10 comments, 4,397 reads

Posted in Bradley Schacht on 21 December 2011

Mark a Disk Partition as Inactive

If you are like me then you like to reinstall Windows on your laptop every few months to keep things fresh and running smoothly.  That or your even more like me and you download some beta version of software and install it on your laptop rather than a VM and… Read more

10 comments, 608 reads

Posted in Bradley Schacht on 20 December 2011

SharePoint Reports and Scorecards on Apple Devices

While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple devices, namely the iPad, for use in their organizations. In the last quarterly earnings call from Apple they revealed that more than 80% of fortune 100 companies and more than… Read more

0 comments, 524 reads

Posted in Bradley Schacht on 19 December 2011

The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine

If you have used SSIS to move data from something like Access or more commonly Excel, it is a good possibility you have seen this error at some point:

Error: The ‘Microsoft.Ace.OLEDB.12.0‘ provider is not registered on the local machine.

The reason this error shows up is because the… Read more

5 comments, 24,643 reads

Posted in Bradley Schacht on 16 December 2011

PowerPivot Data Connection Error

PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be delegated. The following connection failed to refresh: PowerPivot Data

When viewing a PowerPivot workbook in SharePoint 2010 the report is visualized using Excel Services since ultimately the report is… Read more

0 comments, 1,099 reads

Posted in Bradley Schacht on 15 December 2011

Installing SharePoint 2010 and SQL Server 2012 RC0

With SQL Server 2012 right around the corner and Release Candidate 0 already out there I’m sure you will all want to see the cool new stuff that SharePoint has to offer.

There are a number of changes coming to SharePoint with the SQL 2012 release including the much anticipated… Read more

1 comments, 4,656 reads

Posted in Bradley Schacht on 14 December 2011