All, I'm in the process of upgrading sql server 2000 to 2005 using a side by side setup. I'm running into an issue with the named instance being created on SQL 2005 being different which will require all of our users/programs odbc to change. I'm trying to see if there is an easy way to migrate to the new instance with out changing all the odbc connections. Is it possible to have the same instance on both or rename the instance. Any help would be appreciated. Jamal
Hi Jamal, You can't have two identical Named Instances on an Operating System nor you can't change the name of a Named Instance after installing it. Did you try using an Alias? For example, first install your new SQL Server 2005 instance and then create an Alias using SQL Server Configuration Manager. In the Alias, set the "Server" value as your new installed SQL Server 2005 Instance Name (of course with the Computer Name or IP address) and then set the "Alias Name" value as your SQL Server 2000' s name. However be awared that after creating this Alias, connections to your SQL Server may be redirected to Instance which is configured by you in this Alias' "Server" value. -- Ekrem Önsoy "Jamal" <jma@newsgroups.nospam> wrote in message news:%23WLYTX16IHA.5292@TK2MSFTNGP02.phx.gbl... > All, > > I'm in the process of upgrading sql server 2000 to 2005 using a side by > side setup. I'm running into an issue with the named instance being > created on SQL 2005 being different which will require all of our > users/programs odbc to change. I'm trying to see if there is an easy way > to migrate to the new instance with out changing all the odbc connections. > Is it possible to have the same instance on both or rename the instance. > Any help would be appreciated. > > > Jamal >
