Saturday, January 31, 2009
Product : SQL Server 2005 Reporting Services
Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
KB ID # 920803
Thursday, January 22, 2009
System.Data.SqlClient.SqlError: Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)
Then, I did a Check Name for "SQL" and added the following two SQL accounts from the list:
1) SQLServer2005MSSQLUser$<machine name>$MSSQLSERVER
Monday, January 19, 2009
Tuesday, January 13, 2009
The registry key
the location and name for the configuration file that Integration
Services service uses. The default value of the registry key is
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ MsDtsSrvr.ini.xml.
You can update the value of the registry key to use a different name
and location for the configuration file.
Reference: Multiple SQL Server Integration Services (SSIS) database instances on one machine - Mike's Blog
Saturday, January 10, 2009
On Dec 15th 2008, Microsoft released the latest Service Pack 3 on SQL Server 2005. On the same day SP3 Cumulative Update 1 and Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2) are also released.
- For SQL users not opting for SP3, Microsoft released Cumulative Update 11 for SQL Server 2005 SP2, which contains all of the hot fixes for SP2, without the new features in SP3.
- For SQL users upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, they must apply a post-SP3 cumulative update after upgrade to SP3 to obtain all the fixes
This Service Pack is available for download from Microsoft Download Center. Along with the Service Pack, refreshed the Feature Pack for 2005 that can be downloaded separately. The following are all the download links for SQL Server 2005 Service Pack 3 and related downloads.
SQL Server 2005 SP3 (Eval, Std, Dev, Ent Editions)
SQL Server 2005 Express Edition SP3
SQL Server 2005 Express Advanced SP3
SQL Server 2005 Express Toolkit SP3
SQL Server 2005 Feature Pack Dec 2008
SQL Server 2005 Management Studio Express SP3
SQL Server 2005 SP3 Data Mining Add-ins Page
SQL Server 2005 SP3 Reporting Services Add-in Page for Microsoft Sharepoint
SQL Server 2005 Books Online Refresh - December 2008
What's New in SQL Server 2005 SP3
Readme files for SQL Server 2005 SP3
Release Notes for SQL Server 2005 SP3
Cumulative update package 1 for SQL Server 2005 Service Pack 3
An Incremental Servicing Model - ISM is available from the SQL Server team to deliver hotfixes for reported problems