April 15, 2003 at 2:39 pm
While trying to apply SP3, it got to the copying files part and then errored out with "The specified file cannot be opened as write, ensure the file is not in use and restart setup. File: sqlpath\install\instmsdb.sql"
NT privs to install dir look OK. Server reboot, etc had no effect.
Had to reinstall base SQL 2000 + SP1 to get the system back up and running.
Anyone else have any problems like this?
April 15, 2003 at 3:07 pm
Are you sure you don't have something running while this is upgrading? Maybe a job or a DTS package? Did you look in the instmsdb.sql file to see what it's trying to do? Maybe that will shed some light on what's happening.
Darren
Darren
April 15, 2003 at 3:53 pm
No jobs or packages running;
instmsdb is the create script for msdb, though it doesn't seem to be calling the script, but rather trying to copy it (or a new version of it) to the install dir.
Tried renaming instmsdb.sql, then got an error saying the file wasn't there.
April 15, 2003 at 4:07 pm
Are you logged on under the local admin group login? Seems like a permissions problem. Sorry I can't be of more help.
Darren
Darren
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply