How can I access MS SQL 2005?

Last modified: April 3, 2020
You are here:
Estimated reading time: 1 min
MS SQL database 2005
Access MS SQL 2005

 

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.

     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

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

Thirdly, once the 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: 33