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

bngala5 used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Yoiu will need to downlaod the SQL Studio management on a remote PC to do this.
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial