Re: SQL 2000 Client with SQL 2005 Server Alias

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: SBS 2003 R" Premium stops responding to clients
    ... Sometimes the SBS lost DC ... when all clients were down and there are no sql ... The sql load on this system is very small, and there were no sql server ... Mem is 2 GB and there are 10 clients. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • SQL 2000 and MSDE/Express/Compact edition..
    ... desktop app with MSDE 2000 backend to 300 clients enabling them to ... work offline then sync with our SQL server. ... isnt going to be possible with 300 external clients.. ...
    (microsoft.public.sqlserver.replication)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Access 2007->SQL Server2005 "connection was forcibly closed",GNE 1
    ... I have a very big problem connecting an SQL ... changing number of clients using the SQL Server with this frontend at the ... connection pooling or if these connections are separated connections). ...
    (microsoft.public.sqlserver.connect)
Loading