{"id":1909,"date":"2019-10-03T17:20:53","date_gmt":"2019-10-03T09:20:53","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&#038;p=1909"},"modified":"2022-10-07T07:48:03","modified_gmt":"2022-10-06T23:48:03","slug":"can-i-connect-to-ms-sql-2005-database-server-using-ms-sql-2000-enterprise-manager","status":"publish","type":"kb","link":"https:\/\/www.mondoze.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":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1909\" class=\"elementor elementor-1909\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1b507e33 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b507e33\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-50acee55\" data-id=\"50acee55\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b124a8 elementor-widget elementor-widget-heading\" data-id=\"0b124a8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Can I Connect to MS SQL 2005 Database Server using MS SQL 2000 Enterprise Manager?<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4dad1a0b elementor-widget elementor-widget-text-editor\" data-id=\"4dad1a0b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\">You are not able to connect using the MS SQL 2000 Enterprise Manager connect to MS SQL 2005 database server using <a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_SQL_Server\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">MS SQL 2000<\/a> Enterprise 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.<\/p><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 &#8220;SQL-DMO You must use SQL 2005 management tools to connect to this server&#8221; as shown in the following screen shot:<\/p><p dir=\"ltr\">SQL 2000 Enterprise Manager error<\/p><p dir=\"ltr\">Click and drag to move<\/p><p dir=\"ltr\">In order to connect to the MS SQL 2005 database, you will need to install the Microsoft SQL Server Management Studio Express that is applicable to download for free from Microsoft website.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Can I Connect to MS SQL 2005 Database Server using MS SQL 2000 Enterprise Manager? You are not able to connect using the MS SQL 2000 Enterprise Manager connect to MS SQL 2005 database server using MS SQL 2000 Enterprise Manager? to the MS SQL 2005 database from your local terminal. This is due to &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mondoze.com\/guide\/kb\/can-i-connect-to-ms-sql-2005-database-server-using-ms-sql-2000-enterprise-manager\"> <span class=\"screen-reader-text\">Can I connect to MS SQL 2005 database server using MS SQL 2000 Enterprise Manager?<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[124],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1909"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=1909"}],"version-history":[{"count":6,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1909\/revisions"}],"predecessor-version":[{"id":18584,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1909\/revisions\/18584"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=1909"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=1909"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=1909"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=1909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}