Figure: Error ""[Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)."" on Refreshing Schema on SQL Server 2005 (SP1)
Microsoft® SQL Server™ 2000 supports a COM-based object model, called SQL-DMO, which can be used to programmatically manage the SQL Servers. Enterprise Manager uses this API to manage SQL Server. SQL Server 2005 replaces SQL-DMO with two .NET based object libraries: SQL Server Management Objects (SMO) & Replication Management Objects (RMO). And for backwards compatibility it is installed by SQL Express so that existing DMO apps should just work.
If you didn't install or uninstalled SQL Server 2005 Express, you need to download and setup SQL-DMO Backwards Compatibility. Download SQL-DMO Backwards Compatibility
If you have got backwards compatibility installed, it may cause by SQLDMO didn't register correctly or crashed on your machine, you need re-register SQLDMO to make this work, just follow the steps:
- Go to 'Start -> Run', type 'cmd' and Enter to open the command line console in your Windows.
- At the command line, go to the directory where the sqldmo.dll located in.
- Type 'regsvr32 sqldmo.dll' and press Enter.