SQL Server 2005 Reporting Services doesn’t work in integrated mode with SharePoint 2010

When my company made the decision to upgrade our intranet from SharePoint 2007 to SharePoint 2010 version, I was over the moon, but immediately I was told that we wouldn’t be upgrading to SQL Server 2008, it was still fine, because Microsoft states that SharePoint 2010 works with SQL Server 2005 SP2 with cumulative updates. It’s only later when we found out that SQL Server Reporting Services 2005 would not work with SharePoint 2010 in integrated mode.

This is not all, we were lucky enough to get our hands on Visual Studio 2010, but guess what? You can’t develop or even open SSRS 2005 reports in Visual Studio 2010.

Happy coding J

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: