connecting SQL

I am trying to define a connection to a remote SQL, although the server is installed localy. can I try to connect via IP (as a remote client) even though the server is on my local machine ?

thanks,

dror

You can do that. For instance, you can use osql.exe to connection a local instance as:

osql -E -Stcp:.\<instance>,<portnumber>

For Yukon, the portnumber is 1433. Also the link (http://support.microsoft.com/kb/265808) tells you how to find out a port for all versions of SQL Server.

Thanks,

Junfeng