SSAS: Access Denied – The file specified in the restore command is damaged or is not an AS backup file

You have attempted a database restore in Analysis Services from a .abf file and get the error : “The file specified in the restore command is damaged or is not an AS backup file.  The following system error occurred : Access is denied”.   The key clue in the error is the last part.

accessdenied

Go to the actual file, i.e. not the folder, right click, select properties, the click the Security tab.  Edit the file’s security so that the Analysis Services service account has sufficient permissions i.e. full permissions will work.  If you don’t know the Analysis Services Services account, go to SQL Server Configuration Manager and find your Analysis Services service where you will see the service account.

Windows 8.1 – No Upgrade Apps Option From Windows 7

Looking forward to the new features in Windows 8 ?   Taking a flying leap but make you flinch at first.  If you have no Upgrade Apps option chances are you are Installing the Windows 8.1 Enterprise media which doesn’t support upgrade apps – try the Professional edition media instead.   If you are chasing the Hyper V host this is available in both Professional and Enterprise but otherwise you will notice Professional doesn’t get a handful of “Enterprisey” things.  Get along to the Features v Editions page to see what you are missing between Enterprise and Professional http://www.microsoft.com/en-us/windows/enterprise/products-and-technologies/windows-8-1/compare/default.aspx.

Even if you are happy to punch out a clean install there is a Windows 8.1 Upgrade Assistant, which will give you an assessment on what is compatible and what isn’t.

http://windows.microsoft.com/en-US/windows-8/upgrade-to-windows-8

Note, if you want the upgrade option, there are several options here, summarised down, these are essentially,

1. Keep Nothing (clean install)

2. Keep Personal Files (make sure your files are in your Desktop or Documents folder)

3. Keep Apps (if you don’t see this try the Professional edition media)

If you get along to here you will find more details about the upgrade process http://windows.microsoft.com/en-au/windows-8/upgrade-from-windows-7-tutorial.

 

 

SSIS: VS 2012 One or more projects in the solution were not loaded correctly

The following workaround http://up10it.blogspot.com.au/2013/07/VS2012-projects-not-loading.html was tested successfully for SQL Server Data Tools for Visual Studio 2012.   You come across the error “One or more projects in the solution were not loaded correctly” on opening a SSIS solution file in SQL Server Data Tools for Visual Studio 2012 and then encounter a head scratching moment.

OneorMoreProjects

 

Steps taken to work around :

1. Close SQL Server Data Tools for Visual Studio 2012

2. Navigate to the C:\Users\<Your UserName>\AppData\Local\Microsoft\VisualStudio\11.0

3. Rename folder ComponentModelCache to ComponentModelCache.old

4. Re-open SQL Server Data Tools for Visual Studio 2012

5. Open the Solution again