How can I access MS SQL 2000?
There are 2 ways to access MS SQL 2000 database. You can use ASP.net Enterprise Manager web client at http://220.127.116.11/sqlmanager or use Microsoft SQL Server Management Studio Express (MSSQLMSE).
In order to use Microsoft SQL Server Management Studio Express (MSSQLMSE) you need to download the application at Microsoft Download Center.
1. Download Microsoft SQL Server Management Studio Express at http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en
2. Install the application in your local PC/laptop by following the wizard.
3. Once installation is complete, open the application and choose Start > Programs > Microsoft SQL Server 2000 > SQL Server Management Studio Express
4. 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)
5. Click 'Connect'.
6. 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.