Server registration through enterprise manager

  • I have intalled Enterprise manager on Win2k pro machine. When i try to add any server to it i get the following message

    SQL Server registraion failed becuase of the connection failure displayed below.

    Invalid attribute/option identifier

    But i still can use Query Analyzer to connect to any server and run queries.

    Any ideas how can i fix this error and user EM to manage my server. Server is not running on the same machine but on the netwrok.

    Thanks

  • Reinstall the client tools. You likely have a bad install.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Might also try installing the last MDAC again. If all else fails I did read a thread on another site where the statement was made that they copied all files sql*.* from a machine with a good install in the C:\WINNT\System32 folder to that on the failed install and it corrected. Furthermore, this person was unable to reinstall the MDAC or client tools successfully but they did not state weather or not they rebooted and tried reinstall, you may want to try that if a reinstall fails.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply