Your Gateway To Digital Success
Wesbytes Blue Logo

Wesbytes Knowledge Base

Search our articles or browse by category below

How can I access MS SQL 2005?

Last modified: July 2, 2022
You are here:
Estimated reading time: 1 min

There are two choices we can use to access the MS SQL 2005 database. You can use:

     1) Enterprise Manager web client.

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

In this article, we will guide you by using Studio Express (MSSQLMSE) Microsoft SQL Server Management. In order to use the application , you must:

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

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

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

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