How can I access MS SQL 2005?

Last modified: February 23, 2020
You are here:
Estimated reading time: 1 min

How can I access MS SQL 2005?

The MS SQL 2005 database can be accessed with 2 choices. You can use:

     1) ASP.net Enterprise Manager web client at http://124.217.254.98/sqlmanager

     2) Microsoft SQL Server Management Studio Express (MSSQLMSE).

In order to use the Studio Express (MSSQLMSE) Microsoft SQL Server Management, you must:

Firstly, download Microsoft SQL Server Management Studio Express at:

https://www.microsoft.com/en-sg/download/details.aspx?id=8961

Secondly, install the application in your local PC/laptop by following the wizard.

Thirdly, once installation is finished open the application at Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express.

Then enter the following information:

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

But you are now linked to the database, which enables you to use the tools of this client to handle table, query, setting and much more.

Was this article helpful?
Dislike 0
Views: 17