Data Import/export fails to start

While logged onto an SQL server through enterprise manager, when I select a
database, right click and select import or export nothing happens. No boxes
or errors appear.
If I try it through Tools|Data Transformation Services|Import - I get a MMC
error
Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
ModVer:2000.80.194.0 offset 002606e0
Clicking OK kills MMC
This functionality works if I connect using Remote Desktop.
Any Ideas?
Hi
Apply the same service pack on your client machine as you have on the
server, reboot and see if it still occurs. You don't have any SP's on the
client machine based on the build version of sqldmo.dll.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
> While logged onto an SQL server through enterprise manager, when I select
> a
> database, right click and select import or export nothing happens. No
> boxes
> or errors appear.
> If I try it through Tools|Data Transformation Services|Import - I get a
> MMC
> error
> Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
> ModVer:2000.80.194.0 offset 002606e0
> Clicking OK kills MMC
> This functionality works if I connect using Remote Desktop.
> Any Ideas?
>
|||Thanks Mike,
That did the trick.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Apply the same service pack on your client machine as you have on the
> server, reboot and see if it still occurs. You don't have any SP's on the
> client machine based on the build version of sqldmo.dll.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
> news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
>
>