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.