Saturday, January 31, 2009

Error while setting reporting service and share point exclusion path

Encountered the error while installing SQL 2005 Reporting Service "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

Unicenter command to check the service is installed on running on a server

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)

http://go.microsoft.com/fwlink/?LinkId=135960

SQL Server 2005 Express Edition SP3

http://go.microsoft.com/fwlink/?LinkId=135970

SQL Server 2005 Express Advanced SP3

http://go.microsoft.com/fwlink/?LinkId=135973

SQL Server 2005 Express Toolkit SP3

http://go.microsoft.com/fwlink/?LinkId=135974

SQL Server 2005 Feature Pack Dec 2008

http://go.microsoft.com/fwlink/?LinkId=135971

SQL Server 2005 Management Studio Express SP3

http://go.microsoft.com/fwlink/?LinkId=135772

SQL Server 2005 SP3 Data Mining Add-ins Page

http://go.microsoft.com/fwlink/?LinkId=135959

SQL Server 2005 SP3 Reporting Services Add-in Page for Microsoft Sharepoint

http://go.microsoft.com/fwlink/?LinkId=135962

SQL Server 2005 Books Online Refresh - December 2008

http://go.microsoft.com/fwlink/?LinkId=130167

What's New in SQL Server 2005 SP3

http://go.microsoft.com/fwlink/?LinkId=131442

Readme files for SQL Server 2005 SP3  

http://go.microsoft.com/fwlink/?LinkId=130542

Release Notes for SQL Server 2005 SP3

http://go.microsoft.com/fwlink/?LinkId=12952

Cumulative update package 1 for SQL Server 2005 Service Pack 3

http://support.microsoft.com/kb/959195

An Incremental Servicing Model - ISM is available from the SQL Server team to deliver hotfixes for reported problems

http://support.microsoft.com/kb/935897