Accessing remote SQL Server database

I'm trying to access the mssql database of my website which a web desig开发者_运维知识库n team has designed. They have given me the ip, port, db name, user and password... but how can I connect to the mssql server?

I have tried doing it via php but I think I have to compile php without "--without-mssql" "--without-pdo-mssql"... which I would not rather do on this windows 7 computer unless I have to.

I've tried SQL Server Management Studio Express but I couldn't find a way to access to a REMOTE database.

I've also tried Razor SQL but that did not connect either.

I almost tried something like phpmyadmin for asp.net but wanted to find an easier solution for this- without installing asp.net.

So what would be a good solution for managing a remote mssql database? Is there a program like Office Access that can handle such job?

SQL Server Management studio does support remote connections, in the small dialog you see in the middle of the screen when you run it, specify IP, username and password.

do you get any error? Which error do you get?

I am a fan of Navicat:

http://www.navicat.com/en/products/navicat_sqlserver/sqlserver_detail_win.html

However, I have not used the Sql Server version, but the MySQL and Oracle versions are pretty good - MySQL is awesome (mid range price point is the only draw back).

However Navicat Lite, which is still pretty good (and can handle most server types) is free!

Just a note, has the remote DB been setup for remote connections? If not you will not be able to get access no matter what you use.