Have a strange bird that needs a SP4 install. Currently there are two 2005 database and two 2000 databases on the server. When I look through the servers for SQL listings I have the following:
SQL Server (AWCEXPRESS)
SQL Server (SQLEXPRESS)
I was told that the AWC instance for 2000 was old and not in use but I was going to use it to test the SP4 update before trying MIP that actually needs the update.
I ran the following command SETUP INSTANCENAME="AWC" SAPWD="A_STRONG_PASSWORD" /L*v to a logfile
When I execute the command I get an Invalid Instance however I have selected the Instance in the AWC database and it is AWC.
I am stumped and figure it is perhaps confusing another instance somehow.
I am using SQL2000.MSDE-KB884525-SP4-X86-ENU.EXE.
I accidentally ran the command using the SQLAgent$AWC and it installed a blank instance so it appears to be the correct download.
I am stumped, please help!