{"id":22224,"date":"2020-12-05T09:55:20","date_gmt":"2020-12-05T01:55:20","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&#038;p=22224"},"modified":"2022-09-08T19:13:38","modified_gmt":"2022-09-08T11:13:38","slug":"connect-microsoft-sql-2000-database-by-using-enterprise-manager","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/connect-microsoft-sql-2000-database-by-using-enterprise-manager","title":{"rendered":"Connect Microsoft SQL 2000 Database by Using Enterprise Manager"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"22224\" class=\"elementor elementor-22224\" data-elementor-post-type=\"kb\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7af53db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7af53db\" 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<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e4e02b2\" data-id=\"e4e02b2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4200f57 elementor-widget elementor-widget-heading\" data-id=\"4200f57\" 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\">HOW TO: Connect Microsoft SQL 2000 Database with Enterprise Manager<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5439437 elementor-widget elementor-widget-text-editor\" data-id=\"5439437\" 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<p>This article will show you how to connect Microsoft SQL 2000 Database by using <a href=\"https:\/\/www.oracle.com\/enterprise-manager\/\" rel=\"noopener\">Enterprise Manager<\/a>. You can simply follow the guide below:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9706b6a elementor-widget elementor-widget-text-editor\" data-id=\"9706b6a\" 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<div class=\"mkb-article-text mkb-clearfix\"><p dir=\"ltr\">Step <strong>1\u00a0<\/strong>of 9<\/p><p dir=\"ltr\">Open the SQL Server Client Network Utility: <b>Start &gt; Programs &gt; Microsoft SQL Server &gt; Client Network Utility<\/b><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ec09b4 elementor-widget elementor-widget-text-editor\" data-id=\"4ec09b4\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>2 <\/strong>of 9<\/p><p>Click on the \u201cAlias\u201d tab<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03b222b elementor-widget elementor-widget-image\" data-id=\"03b222b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"536\" height=\"348\" src=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager1.jpg\" class=\"attachment-large size-large wp-image-37763\" alt=\"Connect Microsoft SQL 2000 Database with Enterprise Manager\" srcset=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager1.jpg 536w, https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager1-300x195.jpg 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6c2274 elementor-widget elementor-widget-text-editor\" data-id=\"e6c2274\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>3 <\/strong>of 9<\/p><p>Click \u201cAdd\u201d and enter the following information:<\/p><p>Server Alias \u2013 Galaxy (Your SQL Server Hostname)<br \/>Network Library \u2013 TCP\/IP<br \/>Computer Name \u2013 192.168.1.11 (Your SQL server IP, see\u00a0\u00a0<b>Notes<\/b>\u00a0below)<br \/>Port Number \u2013 1533<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b59c92 elementor-widget elementor-widget-image\" data-id=\"0b59c92\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"590\" height=\"313\" src=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager2.jpg\" class=\"attachment-large size-large wp-image-37764\" alt=\"Connect Microsoft SQL 2000 Database with Enterprise Manager\" srcset=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager2.jpg 590w, https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager2-300x159.jpg 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60cab39 elementor-widget elementor-widget-text-editor\" data-id=\"60cab39\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>4\u00a0<\/strong><strong>\u00a0<\/strong>of 9<\/p><p>Click OK<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7284e39 elementor-widget elementor-widget-text-editor\" data-id=\"7284e39\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>5\u00a0<\/strong><strong>\u00a0<\/strong>of 9<\/p><p>Click OK \u2013 This will close out the Client Network Utility<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f74988 elementor-widget elementor-widget-text-editor\" data-id=\"5f74988\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>6<\/strong> <strong>\u00a0<\/strong>of 9<\/p><p>Open Enterprise Manager. Right Click \u201cMicrosoft SQL Servers\u201d and select \u201cNew SQL Server Registration\u201d This will open a wizard. Click Next.<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06bcaa7 elementor-widget elementor-widget-image\" data-id=\"06bcaa7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"424\" height=\"293\" src=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager3.jpg\" class=\"attachment-large size-large wp-image-37765\" alt=\"Connect Microsoft SQL 2000 Database with Enterprise Manager\" srcset=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager3.jpg 424w, https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager3-300x207.jpg 300w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ea836c elementor-widget elementor-widget-image\" data-id=\"9ea836c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"391\" src=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager4.jpg\" class=\"attachment-large size-large wp-image-37766\" alt=\"Connect Microsoft SQL 2000 Database with Enterprise Manager\" srcset=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager4.jpg 502w, https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager4-300x234.jpg 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e071f6 elementor-widget elementor-widget-text-editor\" data-id=\"3e071f6\" 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<div class=\"mkb-article-text mkb-clearfix\"><p dir=\"ltr\">Step <strong>7\u00a0<\/strong><strong>\u00a0<\/strong>of 9<\/p><p dir=\"ltr\">Select \u201cGalaxy\u201d (SQL Server Hostname) from the list of available servers and \u201cAdd\u201d it. Click Next.<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5d3876a elementor-widget elementor-widget-image\" data-id=\"5d3876a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"391\" src=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager5.jpg\" class=\"attachment-large size-large wp-image-37767\" alt=\"\" srcset=\"https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager5.jpg 502w, https:\/\/www.casbay.com\/guide\/wp-content\/uploads\/2020\/12\/SQL-Enterprise-Manager5-300x234.jpg 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9df9062 elementor-widget elementor-widget-text-editor\" data-id=\"9df9062\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>8\u00a0<\/strong>of 9<\/p><p>Choose to connect using SQL Server Authentication<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db1ce55 elementor-widget elementor-widget-text-editor\" data-id=\"db1ce55\" 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<div class=\"mkb-article-text mkb-clearfix\"><p>Step <strong>9\u00a0<\/strong><strong>\u00a0<\/strong>of 9<\/p><p>Enter your assigned username and password. Keep on clicking next until the wizard is completed.<\/p><p><b>Notes :\u00a0<\/b><\/p><p>\u2013 You may obtain your\u00a0SQL server IP\u00a0after you have created your MSSQL database inside your HELM\/DNP control panel.<br \/>\u2013 Please make sure you have SQL Service Pack 3 installed on your terminal.<br \/>\u2013 Please make sure your local firewall is not blocking Port 1533<br \/>\u2013 This article only applies to Windows 2003 hosting packages with MSSQL database support.<\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>HOW TO: Connect Microsoft SQL 2000 Database with Enterprise Manager This article will show you how to connect Microsoft SQL 2000 Database by using Enterprise Manager. You can simply follow the guide below: Step 1\u00a0of 9 Open the SQL Server Client Network Utility: Start &gt; Programs &gt; Microsoft SQL Server &gt; Client Network Utility Step [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","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":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","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":"default","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":[60],"kbtag":[106],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/22224"}],"collection":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/comments?post=22224"}],"version-history":[{"count":43,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/22224\/revisions"}],"predecessor-version":[{"id":37776,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/22224\/revisions\/37776"}],"wp:attachment":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/media?parent=22224"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=22224"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtag?post=22224"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=22224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}