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

Was this article helpful?
Dislike 0
Views: 19