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

On Apr 23, 3:19 pm, Brent White <bwh...@xxxxxxxxxxxxxxxxxxxx> wrote:
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?

Anyone?

.

Relevant Pages

  • Re: ESENT Event ID 474 Database page cache error
    ... As your server is freezing this usually means hardware so check all your ... Resetting the FRS database with the following steps: ... Rename the ntfrs.jdb file in the \ntfrs\jet folder. ...
    (microsoft.public.windows.server.sbs)
  • RE: AS2005 Rename cube
    ... We are having a problem in SQL Server 2005 Analysis Services SP2 ... synchronizing a database after rename. ... In the source server process the database Adventure Works DW. ...
    (microsoft.public.sqlserver.olap)
  • 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)
  • RE: Problems copying Sharepoint to another server
    ... If you are deloping sinlge server, it should be the sql server is not connect ... When you rename the SQL server, better to rebuild the master database ...
    (microsoft.public.sharepoint.portalserver)
  • 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)
Quantcast