I have hands on experience in setting up MS SQL Server 2005/2008 on Windows 2003/2008 Server OS for both x86 & x64 Architectures.
Scope of Work:
As per my understanding of your requirement, I need to configure both your remote & local systems to enable you to connect & browse your remote SQL Server database/s from your local PC using MSSQL Management Studio.
My Assumptions:
1) Your remote database server runs a Windows 2003/2008 R2/ XP/7
2) MSSQL Server versions 2005/2008.
3) Local System runs Win XP/7 OS with MS SQL 2005/2008 Client libraries & Tools installed, including Management Studio.
4) Remote Server has a Static IP address, with / without a Firewall. If with a firewall, then access to the same is available for it to be configured for opening MSSQL port.
5) Administrative rights to both the Remote & Local systems for situations where installations/configuration changes may need to be done..
6) Access to the both the systems through Team Viewer, AmyAdmin, ShowMyPC etc. If through any other software, that needs to be given to me.
I thank you in anticipation of your valued assignment and for giving me an opportunity to offer you my quality services.
Please feel free to revert for any clarification.
Warm Regards
Avi