{"id":20688,"date":"2020-11-30T05:03:32","date_gmt":"2020-11-29T21:03:32","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&#038;p=20688"},"modified":"2022-09-08T19:13:25","modified_gmt":"2022-09-08T11:13:25","slug":"how-can-i-access-ms-sql-2000","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/how-can-i-access-ms-sql-2000","title":{"rendered":"How can I access MS SQL 2000?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"20688\" class=\"elementor elementor-20688\" 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-151dbe7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"151dbe7\" 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-93d6a9b\" data-id=\"93d6a9b\" 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-d601371 elementor-widget elementor-widget-heading\" data-id=\"d601371\" 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 can I access MS SQL 2000?\n<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a3e278 elementor-widget elementor-widget-text-editor\" data-id=\"0a3e278\" 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>\u00a0There are 2 ways to access the MS SQL 2000 database:<\/p><ul><li>Access MS SQL 2000 <strong>ASP.net<\/strong> of <strong>Enterprise Manager web client<\/strong>.<\/li><li>Microsoft SQL Server Management Studio Express (<strong style=\"font-size: 16px;\">MSSQLMSE<\/strong><span style=\"font-size: 16px;\">).<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68ed4fa elementor-widget elementor-widget-heading\" data-id=\"68ed4fa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How To access MS SQL 2000 via Microsoft SQL Management Studio Express (MSSQLMSE)<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b5d63a elementor-widget elementor-widget-text-editor\" data-id=\"2b5d63a\" 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>Note: You need to download the application at Microsoft Download Center before we start. Once you have the application installed, please follow the steps 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-94739db elementor-widget elementor-widget-text-editor\" data-id=\"94739db\" 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>Step <strong>1<\/strong> of 5<br \/>Firstly, download\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=14630\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" data-wpel-link=\"external\">Microsoft SQL Server Management Studio Express<\/a><\/p><p>Step <strong>2<\/strong> of 5<br \/>Secondly,\u00a0<span class=\"word\">Install\u00a0<\/span><span class=\"word\">the\u00a0<\/span><span class=\"word\">application\u00a0<\/span><span class=\"word\">by\u00a0<\/span><span class=\"word\">following\u00a0<\/span><span class=\"word\">the\u00a0<\/span><span class=\"word\">wizard\u00a0<\/span><span class=\"word\">on <\/span><span class=\"word\">your\u00a0<\/span><span class=\"word\">local\u00a0<\/span><span class=\"word\">PC\u00a0<\/span><span class=\"word\">\/\u00a0<\/span><span class=\"word\">laptop.<\/span><\/p><p>Step <strong>3<\/strong> of 5<br \/>After that, once the installation is complete, open the application and choose<\/p><p><strong>Start<\/strong>\u00a0&gt;\u00a0<strong>Programs<\/strong>\u00a0&gt;\u00a0<strong>Microsoft SQL Server 2000<\/strong>\u00a0&gt;\u00a0<strong>SQL Server Management Studio Express<\/strong><\/p><p>Step <strong>4<\/strong> of 5<br \/>Then, enter details as below:<\/p><p>Server type: Database Engine<br \/>Server name: (IP address of MSSQL server \u2013 please see activation form)<br \/>Authentication: SQL Server Authentication<br \/>Username: (MSSQL username \u2013 please see activation form)<br \/>Password: (MSSQL user password \u2013 please see activation form)<\/p><p>Step <strong>5<\/strong> of 5<br \/>Then click \u2018Connect\u2019.<\/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-947163b elementor-widget elementor-widget-text-editor\" data-id=\"947163b\" 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>However, if you are now connected to the database which you can use it to manage tables, queries, settings, and much more by using this client\u2019s tools. You can also read the article:<em> <a href=\"https:\/\/www.casbay.com\/guide\/kb\/connect-microsoft-sql-2000-database-by-using-enterprise-manager\">Connect Microsoft SQL 2000 Database by Using Enterprise Manager<\/a><\/em><\/p>\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 can I access MS SQL 2000? \u00a0There are 2 ways to access the MS SQL 2000 database: Access MS SQL 2000 ASP.net of Enterprise Manager web client. Microsoft SQL Server Management Studio Express (MSSQLMSE). How To access MS SQL 2000 via Microsoft SQL Management Studio Express (MSSQLMSE) Note: You need to download the application [&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\/20688"}],"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=20688"}],"version-history":[{"count":5,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/20688\/revisions"}],"predecessor-version":[{"id":36896,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/20688\/revisions\/36896"}],"wp:attachment":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/media?parent=20688"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=20688"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtag?post=20688"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=20688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}