I am attempting to apply SP3a to original SQL Server 2000
install. I get the following:

Setup initialization error.
Access is denied.

Source 'D:\sql2ksp3\x86\setup\sqlspre.ini'
Target: 'C\DOCUME~1\ADMINI~1\LOCALS~1\Temp\setupsql.ini'

Can someone interpret this problem for me? Thanks

Tom,

This error may happen when the setup fails to find the temp folder.Rather
than allowing the default you can set some other values via environment
variables, as in

set TEMP = c:\temp
set TMP = c:\tmp

Now in the same session, proceed with the setup.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"TomR" <tjrow (AT) carolina (DOT) rr.com> wrote

Dinesh,

Thanks. Next question. Could I bother you for an
example. I'm not exactly sure where to go from here ...
when you say "you can set some other values via
environment variables" ... I'm not sure how to do this.

Thanks

Tom

Tom,

No problem.After making sure that you indeed have c:\temp and c:\tmp, open
up a command prompt and type :

set TEMP = c:\temp
set TMP = c:\tmp

now go to the drive and/or folder where you have downloaded the setup.Once
there, type 'setup'


--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"Tom" <tjrow (AT) carolina (DOT) rr.com> wrote