SQl server connection from another location

[Luke]

Hi All,

I'm trying to make a connection with the SQL server from one of my coleagues,
What are the steps I must take to do this?

I can ping the server, with success!
I have a userid & password for the SQL server,....

Please help !!

[Gregory Dean]

Use the Client Network Utility on you local computer and create add the
client's SQL server. Create an alias, select TCP/IP as the connection method
and use the SQL Server's IP address as the name. Make a friendly name for
the alias.

Try to load it in Enterprise Manager.

If none of this works make sure the client's SQL Server isn't behind a
firewall that is blocking port 1433 and 1434. Pinging it just means that you
can reach the computer on the port for ICMP. Try telnetting into the server
on the SQL ports.

-Greg
On 2/10/05 7:43 AM, in article
87**************************@posting.google.com, "Luke"
<in**@scriptingit.be> wrote:

Hi All,

I'm trying to make a connection with the SQL server from one of my coleagues,
What are the steps I must take to do this?

I can ping the server, with success!
I have a userid & password for the SQL server,....

Please help !!