SQL 2008 client

[wanman]

Does the TDP for SQL client 5.5.1.0 work with SQL 2008?

I have it installed like I do with my SQL 2005 and SQL 2000 servers but get the following error when I attempt to do a backup (either scheduled or manual Gui or command line)

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.

Thanks for any help!

 

[nikki]

Have you installed in windows 2000 server or 2003..? if yes these 2 services add automatically in windows services:-
check the services a)mssqlserver b)mssqlserveradhelper
then start the services from sql services manager from startmenu.
#go to start-Pgm-sql2000-sql service manager

check restarting the services

 

[wanman]

Have you installed in windows 2000 server or 2003..? if yes these 2 services add automatically in windows services:-
check the services a)mssqlserver b)mssqlserveradhelper
then start the services from sql services manager from startmenu.
#go to start-Pgm-sql2000-sql service manager

check restarting the services

Thanks for the reply.

We installed this on a WIndows 2008 server. Will it be the same?

 

[speterson]

Were you able to find a solution to this problem? I am having the same issue of SQL 2008 on a Windows 2003 x64 server.

 

[Leigh]

For SQL Server 2008 you MUST use SQL TDP 5.5.2.0 which was only released 2 nights ago.

You will also need to make sure you use 5.5.x TSM B/A Client with it.

 

[speterson]

Thank you, that did the trick.

 

[mlschlot]

New Twist to an Old Problem

I'm experiencing the same error. However, my environment is Windows 2008 Enterprise Server (x64) with SQL Server 2008 (x64). I'm running the 64 bit 5.5.2.4 Windows client with the 5.5.1 SQL Agent.

 

[mlschlot]

ACO5422E - New Twist on an Old Problem

I just found the 5.5.2 SQL Agent. Man! Big Blue managed to bury that pretty good. The new agent cleared my original ACO5422E error. Now I have to deal with ACO5422E with an indication that FULL TEXT MODE IS NOT SUPPORTED. This only shows up on the MASTER, MODEL, and MSDB databases. Anyone else run across this???