SQL 2000 Client with SQL 2005 Server Alias

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)
  • 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)
  • 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)
  • Error 18456 Login failed...
    ... I have Windows 2000 clients on local network with SQL ... server 7.0 on windows 2000 server. ...
    (microsoft.public.sqlserver.security)
  • Re: Connection to SQL Server 2005 lost
    ... Q. Must I upgrade clients to use SQL Native Client as soon as I upgrade my ... Applications deployed before SQL Server 2005 was released can and should ...
    (microsoft.public.sqlserver.connect)
Loading