sql server connect: database connections after the migration -- sql server connect

database connections after the migration

Kiyomi
6/10/2004 3:57:29 PM

sql server connect:

Hello,

We are planning to upgrade SQL Server 7 databases to SQL Server 2000 on a
different server. There are many ASP and other applications running on the
current SQL Server 7 and pointing to its databases.

After the database migration, is there any way to make all the applications
to connect and point to the new databases on SQL Server 2000 without
changing any codes in the applications ?

Thank you very much for your kind advice,

Kiyomi

Re: database connections after the migration

John Bell
6/10/2004 7:31:57 PM

Hi

If your new server has the same name and instances then you should be able
to connect. You may have to transfer logins:
http://support.microsoft.com/default.aspx?kbid=246133

These may also be useful:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240872
http://support.microsoft.com/default.aspx?kbid=274188
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

If you are renaming the new server then you will also need
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

John

[quoted text, click to view]