How can I access MS SQL 2000?

There 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).

This article will guide you to access MS SQL 2000 via Microsoft SQL Management Studio Express (MSSQLMSE).

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:

Step 1 of 5
Firstly, download Microsoft SQL Server Management Studio Express

Step 2 of 5
Secondly, Install the application by following the wizard on your local PC / laptop.

Step 3 of 5
After that, once the installation is complete, open the application and choose

Start > Programs > Microsoft SQL Server 2000 > SQL Server Management Studio Express

Step 4 of 5
Then, enter details as below:

Server type: Database Engine
Server name: (IP address of MSSQL server – please see activation form)
Authentication: SQL Server Authentication
Username: (MSSQL username – please see activation form)
Password: (MSSQL user password – please see activation form)

Step 5 of 5
Then click ‘Connect’.

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’s tools. You can also read the article: Connect Microsoft SQL 2000 Database by Using Enterprise Manager