SQL Server migration, Port issues

• gupta.manish82

  Grasshopper

  Points: 24

  More actions

  April 7, 2008 at 5:47 am

  #69767

  We have SQL Server 2000 running on our client's system. We remotely access that system, to do certain jobs. They have provided an IP address and some port number on which we are able to connect to that Server.

  Now we want to upgrade to SQL Server 2005.

  Will the upgrade of the same system from sql server 2000 to sql server 2005, will make any changes to the port numbers or the port numbers will remain same.

  Also will the connection strings need to be modified for this upgrade or the old connection strings will be able to pull the data from the 2005 version.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 7, 2008 at 4:01 pm

  #799473

  Port number will not be changed. Connection string may need to be changed. In SQL Server 2005, the client tools use SQL Native Client driver.