Re: SQL Server 2000 Virtual Server Renaming

From: Luca Bianchi (rightjoinREMOVE_THIS_at_hotmail.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 11:48:52 +0200

BarryLynch wrote:
> Hi All
> Client has decided they want to rename the Virtual SQL Server from
> (lets say) SQLA to SQLB.

To avoid to reinstall the server, could you set an alias on your DNS server?
In this way your client can connect to SQL Server with both SQLA or SQLB

> Thanks in advance
>
> Barry

Bye 

-- 
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server 2000 Virtual Server Renaming
    ... SQLA to SQLB. ... Uninstall SQL Server and reinstall. ... Am I right in thinking that I cannot restore the master from the SQLA ... Clearly I would like to do this because all the user databases are ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
Loading