Skip to main content

Enable Remote Errors in SQL Server Reporting Services 2005

Enabling remote errors in SQL Server Reporting Services 2005 (SSRS) By default, reporting services returns the following error message when a report produces an error: An error has occurred during report processing. Cannot create a connection to data source ‘AdventureWorks’. For more information about this error navigate to the report server on the local server […]

Optimising SQL Server 2005 TempDB

Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]

Error: SQL Server Replication Requires The Actual Server Name

If while trying to setup a new subscription for SQL Server 2005 Replication using Management Studio you receive this error: TITLE: New Subscription Wizard —————————— Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic […]