There are 2 ways to access MS SQL 2000 database:
1.Access MS SQL 2000 ASP.net of Enterprise Manager web client
2. Microsoft SQL Server Management Studio Express (MSSQLMSE).
You need to download the application at Microsoft Download Center to use Microsoft SQL Server Management Studio Express (MSSQLMSE).
Firstly, download Microsoft SQL Server Management Studio Express at https://www.microsoft.com/en-sg/download/details.aspx?id=8961
Secondly, Install the application by following the wizard in your local PC / laptop.
After that, once installation is complete, open the application and choose
Start > Programs > Microsoft SQL Server 2000 > SQL Server Management Studio Express
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)
Then click ‘Connect’.
However if you are now connected to the database which you can use to manage tables, queries, settings and much more by using this client’s tools.