{"id":2176,"date":"2020-06-09T18:37:10","date_gmt":"2020-06-09T10:37:10","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2176"},"modified":"2026-01-12T11:30:21","modified_gmt":"2026-01-12T03:30:21","slug":"can-i-connect-to-ms-sql-2005-database-server-using-ms-sql-2000-enterprise-manager","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/can-i-connect-to-ms-sql-2005-database-server-using-ms-sql-2000-enterprise-manager","title":{"rendered":"Can I connect to MS SQL 2005 database server using MS SQL 2000 Enterprise Manager?"},"content":{"rendered":"<h3 dir=\"ltr\">You are not able to connect using the MS SQL 2000 Enterprise Manager connect to MS SQL 2005 database server using\u00a0MS SQL 2000\u00a0Enterprise Manager?<\/h3>\n<p dir=\"ltr\">to the MS SQL 2005 database from your local terminal. This is due to compatibility issue between MS SQL 2000 Enterprise Manager and the MS SQL 2005 database engine server.<\/p>\n<p dir=\"ltr\">If you try to connect using MS SQL 2000 Enterprise Manager to your MS SQL 2005 database, you will receive the error \u201cSQL-DMO You must use SQL 2005 management tools to connect to this server\u201d as shown in the following screen shot:<\/p>\n<p dir=\"ltr\">SQL 2000 Enterprise Manager error Click and drag to move<\/p>\n<p dir=\"ltr\">In order to connect it, you will need to install the Microsoft <a href=\"https:\/\/www.ibm.com\/think\/topics\/structured-query-language\" rel=\"nofollow noopener\" target=\"_blank\">SQL<\/a> Server Management Studio Express that is applicable to download for free from Microsoft website.<\/p>\n<p>If you found this guide useful during the setup of your additional address. Please share it with other users going through the same process.<\/p>\n<p>&nbsp;<\/p>\n<p><em>Please refer to the following article to know more.\u00a0<\/em><br \/>\n<strong>Knowledge Base: \u00a0<\/strong><a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/how-to-repair-database-table-with-phpmyadmin\/\">How to repair database table with phpMyadmin?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You are not able to connect using the MS SQL 2000 Enterprise Manager connect to MS SQL 2005 database server using\u00a0MS SQL 2000\u00a0Enterprise Manager? to the MS SQL 2005 database from your local terminal. This is due to compatibility issue between MS SQL 2000 Enterprise Manager and the MS SQL 2005 database engine server. If you try to connect using&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[52],"kbtag":[1299],"class_list":["post-2176","kb","type-kb","status-publish","hentry","kbtopic-microsoft-sql","kbtag-ms-sql-2005"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2176"}],"version-history":[{"count":6,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2176\/revisions"}],"predecessor-version":[{"id":5856,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2176\/revisions\/5856"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2176"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2176"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}