Re: SQL Server soon to switch...how to change ODBC paths?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

yes; in theroy

"Brent White" <bwhite@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1177355978.548039.223460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have several Microsoft Access 2000 databases reading data from a SQL
Server 2000 database using a built-in account in SQL Server. Soon, we
will be swapping this server out for another.

Would it be sufficient to just rename the old server something else
and name the new server the existing name (e.g., MachineA is the name
of the existing system, new system named MachineB. Rename MachineA to
MachineAOLD and rename MachineB to MachineA)? I know this will help
with the web server that is also accessing this database, but I have
ODBC and OLEDB connections all over the company. Would changing the
machine names in this manner be enough to allow the ODBC/OLEDB
connections to point to the new server?



.

Relevant Pages

  • Re: Problem with local policy while connecting to a terminal server
    ... MCSE, CCEA, Microsoft MVP - Terminal Server ... I would have posted this under win2003 terminal services .. ... I have win2003 standard server (MachineA) into which I normally ... I was then still able to logon to terminal ...
    (microsoft.public.win2000.termserv.clients)
  • SQL Server soon to switch...how to change ODBC paths?
    ... Server 2000 database using a built-in account in SQL Server. ... and name the new server the existing name (e.g., MachineA is the name ...
    (microsoft.public.data.odbc)
  • Re: IIS CRL Checking is really driving me crazy!!
    ... whatis the CRL publication interval? ... be expired before any new CRLs will be loaded by the IIS server. ... It seems like with each different configuration this ... > - MachineA: Windows Server 2003 configured as domain controller, ...
    (microsoft.public.platformsdk.security)
  • Re: SQL Server soon to switch...how to change ODBC paths?
    ... Server 2000 database using a built-in account in SQL Server. ... Would it be sufficient to just rename the old server something else ... and name the new server the existing name (e.g., MachineA is the name ...
    (microsoft.public.data.odbc)
  • New Install/New problems with CRLs...
    ... Windows Server 2003 - not on the MachineA domain, ... Certificate Server is configured as a Standalone CA. ... Windows 2000 Pro - this is my client machine ...
    (microsoft.public.inetserver.iis.security)