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 Guinn1917
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren650
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: Reinstall SQL 2000
Prev Next
You are not authorized to post a reply.

Author Messages
Marshall Robert User is Offline
United States
Member since
3/13/2007

Platinum Membership
Posts: 25
9/02/2008 05:56 PM  
Running SQL 200 on SBS 2003. When I try to look at data tables in the Enterprize Manager, I get the following message:
 
"The query cannot be executed, because some files are either missing or not registered. Run setup again to make sure the required files are registered."
 
I think I can figure out how to re-install, but should I take any precautions to prevent data loss or other problems with the overall system?
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
9/11/2008 08:42 PM  
Marshall,
 
Have a look here:
 
PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP:
http://support.microsoft.com/kb/315868
Mariëtte Knap 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'
Marshall Robert User is Offline
United States
Member since
3/13/2007

Platinum Membership
Posts: 25
9/18/2008 04:58 PM  
I repent that it took me so long to get back. This looks like the solution to my problem, but I can't seem to find the SQL 2000 client tools in the SBS 2003 media. If I try to run the entire SBS setup, the installation stops, saying I'm trying to install an older version. I thought there might be a download of the client tools from Microsoft, but I can't find one.
 
Thank you for your time.
 
 
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
9/18/2008 07:44 PM  
Do you have Premium or Standard?
Mariëtte Knap 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'
Marshall Robert User is Offline
United States
Member since
3/13/2007

Platinum Membership
Posts: 25
9/18/2008 08:42 PM  
Premium.
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
9/18/2008 09:05 PM  
I am sorry, I should have read your initial post better. Of course you have Premium. Can you post the exact error or better a screenshot?
Mariëtte Knap 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'
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
9/18/2008 09:06 PM  
THis should fix it:
 
PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP:
http://support.microsoft.com/kb/315868
Mariëtte Knap 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'
Marshall Robert User is Offline
United States
Member since
3/13/2007

Platinum Membership
Posts: 25
9/18/2008 09:35 PM  
You have the right error, and I strongly suspect this is solution I need. (This is the same reference you posted on 9/11.) The problem now is that I can't find the client tools on the media I have. It seems like this is the correct error. Do you still need the screen shot?
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Reinstall SQL 2000


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.3437522 seconds.   :   Terms Of Use   :   Privacy Statement