SQL Server 2008 R2 Upgrade and SharePoint Reporting Services Integration

We recently upgraded our test environment from SQL Server 2005 SP3 to SQL Server 2008 R2 SP1 to take advantage of remote blob storage and additional reporting capabilities offered by the newer version (report builder 3.0). The upgrade went without a hitch so I decided to document the steps I took to get it working. Procedure Here […]

Continue Reading...

Event 3760 – SQL Database on SQL Server Instance not found

Problem The event log on my WFE is filled with errors every hour complaining that a database on my SharePoint SQL instance is not found. Cause This was caused by me creating and deleting a service application, and then going into SQL Management Studio and manually deleting the associated service application database. SharePoint still had […]

Continue Reading...