Hi James, According to the file sp3readme.htm which is located in the directory that MSDE-SP3 was extracted, the version you currently have installed is "SQL Server 2000 Original Release 8.00.194 RTM"
With that in mind, you will want to follow Microsoft's directions on upgrading an existing instance(also contained in sp3readme.htm) with considerations to your environment. The directions follow: 3.7.4 Upgrading Existing Instances of MSDE 2000 To SP3a The following information applies only to Desktop Engine (MSDE 2000). The examples in this section will upgrade an existing instance of MSDE 2000 to SP3a, and also disable the network connectivity for that instance of MSDE 2000. If the instance must accept connections from applications running on other computers, do not specify the DISABLENETWORKPROTOCOLS parameter. The examples in this section assume that the sa login has a strong password. For more information about the sa login password, see section 3.7.2 Security Considerations for MSDE 2000 SP3a. To upgrade SQL Server 2000 Desktop Engine Open a command prompt window. >From the command prompt, use the cd command to navigate to the folder containing the >MSDE 2000 SP3a setup utility: cd c:\MSDESP3aFolder\MSDE where c:\MSDESP3aFolder is either the path to the folder into which you extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the SQL Server 2000 SP3a CD. Execute one of the following commands: For a default instance using Windows Authentication Mode, execute: setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=1 For a named instance using Windows Authentication Mode, execute: setup /upgradesp sqlrun INSTANCENAME=InstanceName DISABLENETWORKPROTOCOLS=1 For a default instance using Mixed Mode (where AnAdminLogin is a member of the sysadmin fixed server role), execute: setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin UPGRADEPWD=AdminPassword DISABLENETWORKPROTOCOLS=1 For a named instance using Mixed Mode (where AnAdminLogin is a member of the sysadmin fixed server role), execute: setup /upgradesp sqlrun INSTANCENAME= InstanceName SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin UPGRADEPWD=AdminPassword DISABLENETWORKPROTOCOLS=1 Important If you use an .ini file during setup, avoid storing credentials in the .ini file. Note When upgrading Desktop Engine on a computer running Windows 98 or Windows Millennium Edition, the instance of Desktop Engine that you are upgrading must be stopped before starting Setup. Hope this helps, -Phil G. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mohr James Sent: Thursday, November 06, 2003 7:49 AM To: [EMAIL PROTECTED] Subject: [ISSForum] Installing MSDE SP3a Hi All! I am trying to install SP2 for SiteProtector 2.0. It requires MSDE SP3a. So, I downloaded the file sql2kdesksp3.exe from Microsoft and run it, which unpacks the file. Then in the appropriate directory I run setup.exe after a minute, I get and error saying "The instance name specified is invalid". The version of SQL is the one provided with site protector and SELECT @@VERSION shows: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Since the installation exists after the above error, I am stuck at this point. Any help would be greatly appreaciated. Regards, Jim Mohr ELAXY Brokerage & Trading GmbH & Co KG _________________________________ James Mohr Systembetrieb Am Hofbr�uhaus 1 96450 Coburg Germany Fon +49 (0) 95 61.55 43.0 Fax +49 (0) 95 61.55 43.302 E-Mail: [EMAIL PROTECTED] --------------------------------------- "Be more concerned with your character than with your reputation. Your character is what you really are while your reputation is merely what others think you are." -- John Wooden --------------------------------------- Be sure to visit the Linux Tutorial: http://www.linux-tutorial.info _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
