All,
I have a problem with installing SQL 2000 Sevice Pack 4. Please see Part II.
Service Pack 4 comes in four parts and each one is to be used to apply to different SQL server components.
Part I - Analysis Service Pack - Complete.
Part II - MSDE component - Problems. The original problem was that it needed a strong password. I got around that by supplying the sa password. Now it says that the sql server instance name specified is invalid. I spent some time researching this and have tried to add parameters in an ini file to specify the instance to be updated. So far everything I tried has failed. Currently, I am not sure what to try next. Setup will not run from the dos prompt.
Here is what my setup.ini file looks like:
[Options]
SAPWD="nochange"
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$Mssqlserver$RPMS\Binn\"
DATADIR="D:\Mssql\Mssql$RPMS\Data\"
INSTANCENAME="FHDP1IRMPA01\RPMS"
Part III - SQL Server 2000 (64-bit) - No need to install since it does not apply to the machine.
Part IV - Database Components - Complete.
I would appreciate any help or suggestions anyone can provide. Thanks in advance.
PeterJR
there is a switch BLANKPASSWORD=1.
also - try just using "MSSQLServer" for your instance name.
|||You cannot have "\" in the instance name. I am guessing the first part in your instancename is the machine name, but that is not necessary, nor correct.
No comments:
Post a Comment