Hello,

Does anyone know how to configure a SQL 2005 Alias where SQL 2000 Clients
can access it by name? I migrated a db over to a new server and would like
to decommission the old one but point all of the clients to the 05 server.

Regards,
Stewart

Change the DNS entry to point to the new IP address or change the connection
strings.

--
Andrew J. Kelly SQL MVP

"Stewart" <stewart (AT) aol (DOT) com> wrote

I tried editing the host file, but that did not work. I was hoping that we
wouldn't have to modify the connection string because the previous developer
hard coded it into the source and it's an old VB app...

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

If he used a server name vs. an IP address you should be able to change the
DNS entry on your DNS Server to point to the new IP address.

--
Andrew J. Kelly SQL MVP

"Stewart" <stewart (AT) aol (DOT) com> wrote

You can also try creating a SQL Server alias with the Client Network Utility
if modifying DNS is not an option. The utility is part of SQL Server client
tools, stand-alone in 2000, bundled into Configuration Manager in 2005. It's
also included with MDAC so if SQL Server is not installed on the same
machine, run "cliconfg" at the DOS prompt. The downside of using SQL Server
alias is that you have to do it on every workstation. Easy for a web server
but harder if you have a bunch of VB apps on mutliple workstations.

Roman

--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak


"Stewart" <stewart (AT) aol (DOT) com> wrote