Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Non-Default Port Number Works without Alias

Author  Topic  km2002 Starting Member 3 Posts Posted - 2006-12-07 : 12:45:17 I have set up several SQL Server machines and have been using TCP/IP with a non-default port number. The application server that I would setup would require the alias for it to make a connection to the database server. I have set up a new server with Windows 2003 R2 w/ SQL Server 2000 SP4. I have removed Named Pipes and left only TCP/IP with the port number being for example 5000. The application server that is also running Windows 2003 R2 does not have any SQL Server client tools installed and they were able to make an ODBC connection to the new database server wihtout an Alias. I did a netstat on the database server and found that it is connecting with TCP/IP and the non-default port number. I tried connecting to the database server from my workstation (XP) and found that it connected without setting up an alias. All is good, since it works, but I want to know what "fixed" it so that no Alias is required.