How can I access MS SQL 2000?

Last modified: February 23, 2020
You are here:
Estimated reading time: < 1 min
There are 2 ways to access MS SQL 2000 database:

1.Access MS SQL 2000 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

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.

Was this article helpful?
Dislike 0
Views: 22
Customer Services Contact

Need Help? Send a Ticket to our 24X7 Technical Support Team

Subscribe Newsletter

Subscribe to Casbay Newsletter for online tips, events and latest promotion !

Copyright © 2010 – 2020 Casbay Sdn. Bhd. (1042688-D). All Rights Reserved.

All Trademarks Are The Property of Their Respective Owner.