Browsing articles from "October, 2011"
Oct
31
2011

SQL Server Upcoming version (code name ‘Denali’) announced: SQL Server 2012!

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 […]

Oct
28
2011

SQL Server 2005 Maintenance plan error: Unable to cast COM object

SQL2005_maint_plan_fixmsg_28oct11.jpg

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 […]

Oct
27
2011

SQL Server Compatibility List (SCL) for Veritas Cluster Server 5.1 Service Pack 2 (SP2) for Windows

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 […]

Oct
27
2011

ACO5424E Could not connect to SQL server 2005

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 […]

Oct
26
2011

ACO5422E SMO error when connecting to SQL Server 2008 – tdpsql 5.5.1

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 […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 446 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2011
M T W T F S S
« Sep   Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: