SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

SQL Server 2008 R2

New Version of SSRS add-in released for SharePoint 2010

Today a new download showed up on my RSS feeds and I wanted to take a minute to compare this new MSI file against the trusty old MSI I’ve used for so long now.   As you know, the SharePoint 2010 Prerequisites installer requires “rsSharePoint.msi” to be loaded before you can install SharePoint 2010.   Below is the OLD link for SSRS which most people use today for cool stuff like a PowerShell script to download all Prerequisites for offline install. as well as the NEW link.   The release of Service Pack 2 for SQL 2008 R2 seems to be triggering lots of new downloads so it might be worthwhile to make sure you’re SharePoint front end binaries match the backend SQL server version.   If patching SQL to SP2, then it’s probably a good idea to update the web front end components and look for the “4000” version number.

 

NEW –
SP2
http://www.microsoft.com/en-us/download/details.aspx?id=622 10.50.4000.0 7/27/2012 36.9 MB
OLD –
SP1
http://www.microsoft.com/en-us/download/details.aspx?id=28132 10.50.2500.00 11/3/2011 36.9 MB

 

It might be a good idea to download the most recent add-in for any new server installs.  There appear to be updates to most all files, but “sqlserverspatial.dll” grew more than most possibly hinting at better geographic data support.

 

image

 

Old Package – File Version Detail

image

 

New Package – File Version Detail

image

 

FIXED – Rule “User account requirement for Farm administrator” failed

When installing PowerPivot on SharePoint 2010 you might see the below error.   Behind the scenes several permissions are being verified, not just Farm Admin.   In my case I also needed to grant SQL SYSADMIN permission to the user account performing the install.  This error message is confusing because it can occur even if you are listed on Central Administration as a Farm Admin.  So before you run “setup.exe” on the SQL CD, be sure to double check your permissions.

 

PowerPivot install account needs:

  • Local Administrator 
  • Farm Administrator 
  • SQL sysadmin fixed role 

Rule "User account requirement for Farm administrator " failed.  The user is not a farm administrator.

image

 

image
image

 

image

SQL Azure – How to connect SQL Management Studio and import Northwind database

Taking my cloud education further … I wanted to explore the SQL Server relational database offering.   The first trick was to create a new “server” from the Azure portal.  After that I opened the web based SQL Azure portal to confirm it was online and healthy.

I was surprised by how easy it was to create a connection.  Simply create a firewall exclusion to your current IP address … and boom … you can open the SQL Azure with SQL Management Studio locally.  Pretty cool! 

Hot

The Azure Management Portal is proving very capable.  It even has a handy popup dialog with connection strings for convenient copy/paste.  Here is the process I used to import sample Northwind data:

  • Open both instances with SQL Management Studio
  • Right click local tables to build “CREATE TABLE” statements.  Copy/paste those from local to Azure and execute.  This creates the schema.  There are some limitations of Azure so you may have to double check your TSQL syntax (http://www.tewari.info/2009/09/10/sql-azure-notes/)
  • Use the SQL Import wizard to migrate data.   For Azure be sure to select “.Net Framework Data Provider for SqlServer”  destination.
  • To resolve red errors, ignore [ntext] or [image] data types during migration.  SQL Azure does NOT support [ntext] or [image] so I just removed those columns.   Not sure of the best way to migrate this type of data yet.  [ntext] should probably cast to VARCHAR(8000) and truncate anything longer.  [image] should probably be saved to the filesystem (JPG/PNG/etc.) and then a URL string pointer to the image file kept in SQL.
  • Click next and finish. Congratulations!   You now now have sample data in SQL Azure.

 

image
image
image
image
image
image
image

 

image
image
image

 

image

 

image

 

image
image

 

image
image
image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲