Saturday, January 31, 2009
Error while setting reporting service and share point exclusion path
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.
Resolution:
KB ID # 920803
Thursday, January 22, 2009
Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.)
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
2) SQL
Monday, January 19, 2009
Unicenter command to check the service
awservices status
Tuesday, January 13, 2009
Multiple SQL Server Integration Services (SSIS) database instances on one machine
The registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile specifies
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
SQL Server 2005 Service Pack 3 released
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 |