Re: SQL 2000 Client with SQL 2005 Server Alias

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@xxxxxxx> wrote in message
news:u41tWiQwHHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxx> wrote in message
news:ek$K2UQwHHA.3684@xxxxxxxxxxxxxxxxxxxxxxx
Change the DNS entry to point to the new IP address or change the
connection strings.

--
Andrew J. Kelly SQL MVP

"Stewart" <stewart@xxxxxxx> wrote in message
news:u%23PH72PwHHA.4228@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... If the client is on the host server it will try to use Shared Memory by default. ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... "Andrew J. Kelly" schrieb im Newsbeitrag ...
    (microsoft.public.sqlserver.connect)
  • RE: A couple mail questions
    ... Is the server using a single IP address? ... their DNS entry to the internal IP address. ... For outbound mail you do not need to have a MX record and dyndns is not ... will start flowing and your clients will be able to connect to. ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance really poor if calling data from sql clients
    ... The power management is set to a mode that no power off for hard disk nor CPU ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to convert the SQL Developer Edition to SQL Standard Editi
    ... Andrew J. Kelly SQL MVP "Kam" wrote in message ... > I think i make this mistake when I try to install the sharepoint portal> server on that machine. ...
    (microsoft.public.sqlserver.setup)
  • VPN RAS connections create dns entries on DC
    ... The server is a DC/Exchange/RAS server. ... When clients connect via VPN, a dns entry with the server's name using dhcp ip range is created in DNS. ... This causes problems for local clients when they pickup this dns entry and start using it instead of the proper static one. ...
    (microsoft.public.win2000.ras_routing)
Loading