|
sponsored links |
|
|
sponsored links
|
|
1
2nd May 20:07
External User
Posts: 1
|
MSDE 1.0 TO MSDE 2000 Release A
I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I attempt to run Setup I get a dialog saying "The instance name specified is invalid." What could be causing this? Also... what impact will an installation of MSDE 2000 have on my existing MSDE 1.0 databases? Is there a procedure I should be following? Thanks in advance. Nancy |
|
|
|
2
2nd May 20:07
External User
Posts: 1
|
MSDE 1.0 TO MSDE 2000 Release A
hi Nancy,
"Nancy Lorieau" <NancyLorieau@discussions.microsoft.com> ha scritto nel messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@microsoft.com... I personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always backedup the users database and restored them on the MSDE2000 new instance after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0 instance at all... anyway, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp reports you have to add the UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd commandline parameters to your call to the setup.exe bootstrap installer... the users databases will be upgraded to MSDE 2000 level... you coul'd be affected by cross database ownership chaining, which behaviour has been changed... further info at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_8d7m.asp -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply |
|
|
Linear Mode
