<div>
You need Microsoft SQL Server 2008 R2 Management Studio. <br />
<br />

</div>


<div>
You also have to bear in mind if you want to access out of the network - which means through the internet.<br />
<br />
If so you have to open up for port 1433 and 1434 in your firewall. You have to use SQL Studio Management Studio R2 as the experts says above.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I am new to database technology currently I am using SQL server 2008 and SQL server 2008 R2 trial versions, I would like to connect to the SQL server remotely to access a specific databases to view tables and queries. Which application or client software can I use to accomplish this tasks.
</div>
</div>


I am new to database technology currently I am using SQL server 2008 and SQL server 2008 R2 trial versions, I would like to connect to the SQL server remotely to access a specific databases to view tables and queries. Which application or client software can I use to accomplish this tasks.

You need Microsoft SQL Server 2008 R2 Management Studio. 



You also have to bear in mind if you want to access out of the network - which means through the internet.

If so you have to open up for port 1433 and 1434 in your firewall. You have to use SQL Studio Management Studio R2 as the experts says above.



How to connect to the SQL server database from a client PC remotely

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.