Can't upgrade to SP3 in Win Server 2003

[Joe Bloch]

I'm trying to install SQL Server 2000 on a newly-installed Win 2003
Server box. My disk is SQL Server SP 2. I got the error message
stating that I couldn't run SQL Server less than SP 3, but I
downloaded the patches from Microsoft's website figuring I'd install
SP 2 off the disk and then install the SP 3 from the download.

Trouble is, when I try to install SP 3, it can't authenticate the
login I give it, either the Windows logon or the sa password, to
actually install SP 3.

I've double-checked the passwords and permissions, and the Windows
logon _should_ be working, and the sa password is definitely what I'm
using in the SP 3 installation program, but no luck.

Any help would be appreciated.

Joseph

[Simon Hayes]

jb****@hypotenuse.com (Joe Bloch) wrote in message news:<63*************************@posting.google.c om>...

I'm trying to install SQL Server 2000 on a newly-installed Win 2003
Server box. My disk is SQL Server SP 2. I got the error message
stating that I couldn't run SQL Server less than SP 3, but I
downloaded the patches from Microsoft's website figuring I'd install
SP 2 off the disk and then install the SP 3 from the download.

Trouble is, when I try to install SP 3, it can't authenticate the
login I give it, either the Windows logon or the sa password, to
actually install SP 3.

I've double-checked the passwords and permissions, and the Windows
logon _should_ be working, and the sa password is definitely what I'm
using in the SP 3 installation program, but no luck.

Any help would be appreciated.

Joseph

http://support.microsoft.com/default...&Product=sql2k

If this doesn't help, perhaps you can give some more information. Is
the Windows account you're using for the installation a local
administrator? By default, members of that group are in the MSSQL
sysadmin role, so that should be the easiest way to avoid permissions
issues.

Simon

[Lisa_DBA]

sq*@hayes.ch (Simon Hayes) wrote in message news:<60*************************@posting.google.c om>...

jb****@hypotenuse.com (Joe Bloch) wrote in message news:<63*************************@posting.google.c om>...

I'm trying to install SQL Server 2000 on a newly-installed Win 2003
Server box. My disk is SQL Server SP 2. I got the error message
stating that I couldn't run SQL Server less than SP 3, but I
downloaded the patches from Microsoft's website figuring I'd install
SP 2 off the disk and then install the SP 3 from the download.

Trouble is, when I try to install SP 3, it can't authenticate the
login I give it, either the Windows logon or the sa password, to
actually install SP 3.

I've double-checked the passwords and permissions, and the Windows
logon _should_ be working, and the sa password is definitely what I'm
using in the SP 3 installation program, but no luck.

Any help would be appreciated.

Joseph

http://support.microsoft.com/default...&Product=sql2k

If this doesn't help, perhaps you can give some more information. Is
the Windows account you're using for the installation a local
administrator? By default, members of that group are in the MSSQL
sysadmin role, so that should be the easiest way to avoid permissions
issues.

Simon

Joseph,
Are you installing over Terminal services/remote desktop? You might
want to try VNC or use Control Panel: Add/remove programs to locate
your setup.bat file and run from there. You might also want to check
your Windows Temp and TMP Environment Variables. You need to ensure
that these variables have no spaces in the path. For example, set them
to C:/TMP and C:/TEMP instead of C:/Program files/Temp. You might
also want to locate the log file that the Service Pack writes to...you
should find the error in there! Hope this helps!
Lisa

[addernoir]

We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[addernoir]

We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lisa_DBA]

addernoir <addernoir> wrote in message news:<40*********************@news.frii.net>...

We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Christian,
Have you checked the contents of SQLSP.Log ? You might find more
detail on the source of error there.

[Lisa_DBA]

addernoir <addernoir> wrote in message news:<40*********************@news.frii.net>...

We're having the same issue. We have the latest MDAC installed, and
everything is fine with the registry entries and temp folders. Any
other ideas?

Thanks,

Christian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Christian,
Have you checked the contents of SQLSP.Log ? You might find more
detail on the source of error there.