Registered users    
MembershipMembership:
Latest New UserLatest:Mary Reiman
New TodayNew Today:11
New YesterdayNew Yesterday:9
User CountOverall:23414
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: Event Log Errors, Two Version of SQL Maybe?
Prev Next
You are not authorized to post a reply.

Author Messages
Mike Loughran User is Offline
United States
Member since
4/5/2006

Registered Users
Posts: 34
5/10/2006 03:18 PM  
I have had these errors ever since a medical software company had installed there software on a brand new dell poweredge server that had sbs preinstalled.  The program that was installed is a web based .net / sql program.  What I think may have happened is that when installing the software, the vendor also installed SQL 2000 ( Another version which probobly came with the software).  Ever since, my sbs monitoring doesn't work as well as I get sharepoint database errors. 
 
Some bg info, I have two directories (Im not sure if this is correct).
    C:\Program Files\Microsoft SQL Server\
    C:\Program Files\Microsoft SQL Server SP4\
    -Are these two seperate version of SQL?
 
Now, in C:\Program Files\Microsoft SQL Server\, I see teh sub dir MSSQL$SBSMonitoring and MSSQL$SHAREPOINT.
 
Im guessing the SP4 is the one that was installed with the medical software. 
 
Can someone tell me how I can get my Monitoring to work again, as well as SHAREPOINT?
Leeland Clay User is Offline
United States
Member since
5/8/2006

Registered Users
Posts: 11
5/10/2006 09:25 PM  
Having 2 installations of SQL server will not by itself break anything.  However, if they did install a new instance of SQL they may have installed an update that wasn't the right one.  If they installed a Service Pack that wasn't designed to be installed on SBS for their enterprise version, then it will by default install on the original installation.  There's an easy way to test this.  Open up SQL Query Analyzer and run the following command:
 
Select @@Version
 
This will produce a grid that has your entire version string information.  The last part will show you the version number.  Copy the results here so we can see what it is.
 
*EDIT*  Oh yeah...connect to both databases and copy the results for both seperately
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
5/11/2006 12:49 AM  
The Microsoft SQL Server SP4 is the result of the SBS 2003 SP1. It has 2 folders, MSDE and WMSDE and is meant for updating the Desktop Engine versions with SP4.
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'
Mike Loughran User is Offline
United States
Member since
4/5/2006

Registered Users
Posts: 34
5/11/2006 08:06 PM  
Just an update.. the guys that installed the software are looking into this, they have now disabled some how the msde, so I can't get into the database to do an query analysis.  I will update asap.
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Event Log Errors, Two Version of SQL Maybe?


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