Hello Manjree,

Thank you for your reply. You could define an alias by using the following
methods:

1. In SQL configuration manager

Under SQL native client configuration->Alias, and define alias
name/port/servername.

This defines a alias using SQL native client to connect SQL 2005

2. Run cliconfg.exe and add alias/port which uses sql server (not native
client) to connect to sql server.

You don't need to add port number after alias since port is configured in
alias.

To check the network status of the machine, please run the following
command to get more information:
netstat -nba > netstat.txt

Also, if you run osql command without port number from local console of SQL
Server, what't the result? Did you try to temporarily disable firewall on
the server to test?

You may need also add Sql Browser service to Firewall exception list
besides the upd port 1434.

I'm looking forward to your update. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.