Is there a way to configure the DB conenctions in SSRS, like the way we do in SSIS. I am asking this, to take care of moving the code from development to production server,without manually changing the connection.
View Complete Post
By default connections to SQL Server are made Read Committed. However in a lot of situation this can result on locking of other users when a big SSRS report is executing. Is there a way to configure my SSRS server that it will connect by default with isolation
level Read Uncommited to the database.
At this moment you need to specify the transaction isolation level in every dataset of the report. This will result in problems of somebody forget to specify. By configuring this on server or connection level, you know for sure that all reports are executing
with Read Uncommitted.
More information about this topic canbe found on my blog:
Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint
The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error
The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.
However, report rendering is a problem from the internet (external site), the following error is displayed:
Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.