ow to upgrade Microsoft SQL Server 2000 - 8.00.19

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

ow to upgrade Microsoft SQL Server 2000 - 8.00.19

Author

Topic

getSqlMastered
Starting Member

12 Posts

Posted - 2009-06-01 : 11:53:13

Hi colleagues

I download sp3 and sp4 for sql server developer edition and try to upgrade fron no service pack to sp3/sp4. But the set up even does not start and shows me permision issues. I have try it both as local admin and domain admin . but yet no change.

Any help on what might be the casess and possible solutions?
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-01 : 13:32:52

Post the errors.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

getSqlMastered
Starting Member

12 Posts

Posted - 2009-06-02 : 02:16:47

The version of the sal server is
"Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)" which has no service pack. I relaize this when i get a difficulty of remote acces from a client machine in using an application. Fianlly, I wanna to upgrade to sp3/sp4 and download the service packs(SQL2000-KB884525-SP4-ia64-ENU,SQL2000.AS-KB884525-SP4-x86-ENU,SQL2000.MSDE-KB884525-SP4-x86-ENU,sql2ksp3) and try to install on the server, and it says" Windows can not access the specified device, path or file.You may not have the appropriate permissions to access teh item". However, when I ahve tried to install on the otehr server with version"Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)" the intallation goes peacefully.

So is there any pre-requisite to update from nor servcie pack to sp4 or what may be the case? any help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-02 : 03:02:54

Do you have appropriate rights for the directory where the install file wants to unpack it's content?

E 12°55'05.63"
N 56°04'39.26"

getSqlMastered
Starting Member

12 Posts

Posted - 2009-06-02 : 06:25:00

yes

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2009-06-02 : 11:01:30

How much space is on that disk?

getSqlMastered
Starting Member

12 Posts

Posted - 2009-06-02 : 12:04:13

8.13GB on drive of local instance and 680GB on named instance

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-06-04 : 13:14:13

Please reapply your permissions to the folders in question.

It is possible to have different permissions on individual subfolders denying you access, even if you can see the root.

Check the sql server folders for your instances, and also ensure you have a temp folder setup and active.

Try unpacking the sp on another machine and manually coping the installation files / installing from your desktop to skip the unpacking step.

getSqlMastered
Starting Member

12 Posts

Posted - 2009-06-05 : 13:02:38

thanks dear

I have extracted the Sp4 on other machine and try to install on the required server. but while conducting on the process, I fave and error message of "error running script: sp1_serv_uni.sql(1) ".

I am searching what might be the case. If any soultion, I welcome you coleages with great thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources