Including Port numbers in %systemroot%\system32\drivers\etc\hosts File

sql sql-server migration hosts
mallows98 picture mallows98 · Nov 18, 2009 · Viewed 16.5k times · Source

Is it possible to include port numbers in hosts file? Reason that I'm asking is because I have sites that I'm trying to migrate from one hosting server to another, and the sites are pointing to an old SQL server that uses the standard TCP/IP port (1433). On the new server, the SQL Server port is different, and I don't want to change the connection strings for these sites.

Thank you!

Answer

Byron Whitlock picture Byron Whitlock · Nov 19, 2009

This is not possible in the host file. DNS doesn't know anything about port numbers.

Related questions

How to implement LIMIT with SQL Server?

I have this query with MySQL: select * from table1 LIMIT 10,20 How can I do this with SQL Server?

Read More
Directory lookup for the file failed with the operating system error 3 (The system cannot find the path specified.)

I am trying to re-create a database (MyDB) from one SQL server (Source) to another one (Target). Source is located on my local machine and is SQL Server 2014. Target is located on a remote machine and it's SQL Server 2012. Here …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More