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).
How 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 ¨C please see activation form)
Authentication: SQL Server Authentication
Username: (MSSQL username ¨C please see activation form)
Password: (MSSQL user password ¨C 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