Since last few months SQL Server Denali (code name) is going under testing and recently during SQL Pass Summit 2011 Microsoft announced the name of upcoming SQL server as SQL Server 2012 (Source: http://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-name-upcoming-sql-server-release-140882), it will be released in first half of next year and below are few significant features of SQL server 2012, Source: http://www.sqlmag.com/content1/tabid/461/catpath/sqlserverdenali/topic/sql-server-denali-new-features-140115 The next release of Microsoft SQL Server, code-named Denali, is right around the corner. Microsoft has just released Denali […]

Today while configuring maintenance plan on one of SQLServer 2005 SP1, I recieved following error, “Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}’ failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)” Resolution was pretty straight, found at following fourm link Resolution: 1. Find the path where DTS.dll is […]

I was trying to find out which version of SQL Servers are supported by Veritas Cluster Services in order to prepare an upgrade plan, I got a useful link from Symantec site, it was last updated on 07-Feb-2011. Link: http://www.symantec.com/business/support/index?page=content&id=TECH142798 SQL Server Compatibilty in short, Software Compatibility List (SCL)Veritas Cluster Server 5.1 Service Pack 2 for Windows Microsoft Microsoft SQL Server 2000 SP4 S x86 Microsoft Microsoft SQL Server 2000 SP4 C IA64, x64 Microsoft […]

While connecting to SQL Server 2005 via tdp you may recieve following error: ACO5424E Could not connect to SQL server To fix it, go to following IBM technote, https://www-304.ibm.com/support/docview.wss?uid=swg21445251 Please find excerpt below, Problem(Abstract): There are several possible reasons why the ACO5424E error may be observed when using MS SQL Server 2005 Cause: The connection to the SQL server methodology changed with SQL Server 2005 and some administration is required to ensure remote connections are […]

While configuring TDP for SQL Server (v5.5.1) on a SQL Server 2008 R2, received following error: Error: While opening SQL Server using TDPSQL GUI (V5.5.1) ACO5422E Received the following from the MS SQL server:Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified. To Resolve the Issue found following IBM article, https://www-304.ibm.com/support/docview.wss?uid=swg21455220 One more user article available at: http://www.sqldbadiaries.com/2010/12/20/could-not-load-file-or-assembly-error-while-using-tdp-makes-a-come-back/ Problem is: Tivoli Data […]