Registered users    
MembershipMembership:
Latest New UserLatest:Taganova Ronya
New TodayNew Today:12
New YesterdayNew Yesterday:9
User CountOverall:23415
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12968
Marina Roos12627
Eriq Neale2117
Stan Guinn1918
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren651
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: SQL SP4 upgrade error
Prev Next
You are not authorized to post a reply.

Author Messages
Robert McDade User is Offline
United States
Member since
5/21/2005

Registered Users
Posts: 42
12/09/2005 05:50 PM  
I have SBS2003 SP1 installed and have several instances of SQL installed w/ sp4 with no problems.  I have now added another instance and when I attempt to install the SP4 patch, I get the following error:

"The specified File cannot be opened as write.  Ensure the file is not in use and restart setup.  File: C;\Program Files\Microsoft SQL Server\80\shared\msxmlsql.dll"

I have uninstalled, tried reinstalling, etc to no avail.

Has anyone else experienced this or does anyone have a solution?

Thanks.
Robert
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
12/11/2005 03:16 AM  
Hi Robert,
 
What kind of an instance is it? Anything in the eventlogs? Have you tried a reboot and then try again?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Robert McDade User is Offline
United States
Member since
5/21/2005

Registered Users
Posts: 42
12/11/2005 08:14 PM  
Hi Marina,

Thanks for responding.

It is just a seperate instance that I created to run diskeeper admin from.  Events logs do not show anything unique except that I keep getting a warning message that states the system is ignoring registry key ...mssqlserver/SNMP/current version because it is missing (which it is - I do not know much about SNMP).

Yes I have rebooted, etc to no avail.

I also have a bad problem with my Intel Server Manager program that came with the computer.  It seems that Intel failed to post that this version did not play kindly with SP1 for months after the release of SP1.  It will not uninstall and Intel refuses to provide manual uninstall instructions.  Essentially, this program is playing havoc with the windows performance counters and monitoring.

I can limp along until R2 comes out and then do a complete reinstall

My question is if I have very few users (5), can I do a fresh reinstall with the same names for users & computers for the AD and use the exchange backup that I have? The exchange is fine and really it is the only thing that I need (I can move the data to another machine)?

Thanks,
RObert
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
12/11/2005 10:36 PM  
Hi Robert,
 
Can you tell us a bit more about that diskeeper admin needing SQL? Anything on their website about this issue maybe?
Which version of Intel Server Manager do you have and what have you tried to get the manual uninstall instructions? Seems to me that Intel should provide you those if they have them.
R2 won't be of much help, unless you have SA. Would you really want to do a reinstall because of the Intel issue?? It will mean recreating the user and computer accounts and rejoin them.
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Robert McDade User is Offline
United States
Member since
5/21/2005

Registered Users
Posts: 42
12/12/2005 04:38 PM  
This error occurs after installing the seperate SQL instance and upon trying to apply the SP4 patch - ie, before installing the diskeeper. (Is there a limit to how many seperate SQL instances that you can have on SBS?  - I have 5)

The ISM version is 8.3.  I have searched the web site and spoken with their support and there is no manual unistall instructions that are available.

I just noticed that the R2 has been pushed back until 2nd qtr. :-(

 I do not have a lot of applications loaded on the SBS server machine and I believe that with the SQL issue and the ISM issue, I would spend less time and have greater peace of mind doing a complete reinstall.

If I recreate the 5 user/computer accounts, is it possible to restore the exchange store for these users, amd if so, what is the process to do this?

Thanks again for your assistance.

Robert
MisterSpoot User is Offline

Member since

Posts: 0
12/27/2005 03:46 PM  
Robert,

I just ran into the same problem upgrading an instance (6th one) for a new application.

To resolve the issue, I did the following:
  • Stopped all other SQL Server instanced services
  • Stopped the Microsoft Search service
  • Proceeded with upgrading the instance I needed to upgrade
  • Restarted Microsoft Search and the stopped SQL Server instances.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
12/27/2005 06:57 PM  
Posted By remrebel on 12 Dec 2005 16:38
This error occurs after installing the seperate SQL instance and upon trying to apply the SP4 patch - ie, before installing the diskeeper. (Is there a limit to how many seperate SQL instances that you can have on SBS?  - I have 5)

The ISM version is 8.3.  I have searched the web site and spoken with their support and there is no manual unistall instructions that are available.

I just noticed that the R2 has been pushed back until 2nd qtr. :-(

 I do not have a lot of applications loaded on the SBS server machine and I believe that with the SQL issue and the ISM issue, I would spend less time and have greater peace of mind doing a complete reinstall.

If I recreate the 5 user/computer accounts, is it possible to restore the exchange store for these users, amd if so, what is the process to do this?

Thanks again for your assistance.

Robert
Hi Robert,
 
I don't know what the maximum SQL instances is. Everything that is valid for plain SQL 2000 standard server is valid for SQL on SBS.
ISM??
Again, R2 is only usefull if you have SBS with SA.
And for recreating (as in reinstalling I suppose?), check this out: How to backup and restore your SBS 2003 server
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Robert McDade User is Offline
United States
Member since
5/21/2005

Registered Users
Posts: 42
12/28/2005 06:43 PM  
Rob,

Your suggestion worked !!!

Many Thanks,
Robert
Robert McDade User is Offline
United States
Member since
5/21/2005

Registered Users
Posts: 42
12/28/2005 06:45 PM  
Marina,
 
Thanks for your reply.
 
Since I was able to get the SQL instance installed, I will move my backup questions to the appropriate forum.
 
Thanks again for your assistance,
Robert
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > SQL SP4 upgrade error


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.3593773 seconds.   :   Terms Of Use   :   Privacy Statement