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