It is usually under c:\WINNT directory....So you need you admin help. Please ask your admin to give admin rights to SQL box ,since SP not only uses MSSQL directory using installation. Or let him do the SP install with admin account with your directions.
regards
Elias
-----Original Message-----
From: Hyra, Bev A [mailto:[Email Address Removed] November 27, 2003 3:58 PM
To: LazyDBA.com Discussion
Subject: RE: SQL 7 with sp3, upgrading to sp4
Doesn't seem to be there. At least it is not on any drive that I can map to. I can only see the mssql directory and everything under it. I will have to get a sys admin to take a better look. Because the server is a domain controller, my access is limited. We used it to run a tool called fastlane migrator. Apparently when we first installed the tool had to be installed on a domain controller and needed an SQL 7 database.
Thanks.
___________________________________________
-----Original Message-----
From: Peter, Elias (COR) [mailto:Elias.[Email Address Removed] Thursday, November 27, 2003 1:49 PM
To: Hyra, Bev A; LazyDBA.com Discussion
Subject: RE: SQL 7 with sp3, upgrading to sp4
Hi ,
Look for a file called sqlstp.log ,it will tell you where it failed. Please post that Information in this site and we can look at it.
regards
Elias
-----Original Message-----
From: Hyra, Bev A [mailto:[Email Address Removed] November 27, 2003 3:42 PM
To: LazyDBA.com Discussion
Subject: SQL 7 with sp3, upgrading to sp4
Hi,
We have an installation of SQL 7 with sp3 and we are trying to apply service pack 4. The service pack starts to run, but then seems to just sit there forever. It never starts to run any of the upgrade scripts. After a long time we just end it. The server is a domain controller and it is running Windows 2000.
We have successfully applied sp4 to other installations of SQL 7 with sp3.
Has anyone experienced anything like this?
Thanks very much for all replies.
Bev.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page