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 server 2000 own instance or upgrade..?
Prev Next
You are not authorized to post a reply.

Author Messages
Henri KONSTAIN User is Offline
Luxembourg
Member since
1/16/2006

Registered Users
Posts: 242
3/10/2006 02:44 PM  
Below is the extract from the 'Completing Setup for Microsoft Windows Small Business Server Premium Technologies' help document Version 2:
 
'You can install SQL Server 2000 as your database for a business application. Additionally, you can upgrade the instance of Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) used by Windows SharePoint® Services if you want to be able to search document libraries in your company's internal Web site.'
 
I have just installed the SQL2000 with SP4 - only as an upgrade to the internal companyweb site following: 'To upgrade the instance of MSDE used for Windows SharePoint Services'
 
The companyweb functions well - and I noticed the new search feature in the top right hand corner..
 
I also notice that the SQL Server Service Manager in systray - is not running and is blank in both Server and Services..
 
Is it correct that SQL SSM is supposed to be related to a seperate instance of the SQL2000 (which I did not install) - and that the upgrade I just did for the internal site has nothing to do with this SQL SSM in the systray..?
 
Should I first have installed a new instance following the 'To install a new instance of SQL Server 2000' in the document..?
SBS 2003 R2 PREMIUM SP2 - EXCHANGE 2003 SP2 - ISA SERVER 2004 SP3
Didier Pironet User is Offline
Belgium
Member since
3/24/2005

Registered Users
Posts: 238
3/10/2006 08:03 PM  
Hi,
 
This behavior is normal if you have multiple instances on SQL...
 
Open the Server Service Manager in the systray and use this namimg convention to find your instance(s): servernam\instancename
 
i.e. myserver\sharepoint or myserver\sbsmonitoring ...
 
Rgds,
Didier
MCSE+I, MSCA, MCSE2003, SBS Specialist certified, HP ASE Proliant, ...
http://www.support-team.be
Henri KONSTAIN User is Offline
Luxembourg
Member since
1/16/2006

Registered Users
Posts: 242
3/10/2006 08:15 PM  
ahh - I see..
 
But when I entered as you wrote - it said that an instance of that one is already running..
 
Also - what I would like to have clarified is - is this Server Service Manager necessary for the companyweb sharepoint database to run..?
I mean - what is the actual purpose of the SSM..?
Because apparently the companyweb runs fine with the SSM not running and blanked out.. 
SBS 2003 R2 PREMIUM SP2 - EXCHANGE 2003 SP2 - ISA SERVER 2004 SP3
Didier Pironet User is Offline
Belgium
Member since
3/24/2005

Registered Users
Posts: 238
3/10/2006 08:26 PM  
SSM is not necessary for sharepoint instance neither for any other instances to run...
It's just a tool to help you manage the SQL services from the systray...
 
Rgds,
Didier
MCSE+I, MSCA, MCSE2003, SBS Specialist certified, HP ASE Proliant, ...
http://www.support-team.be
Henri KONSTAIN User is Offline
Luxembourg
Member since
1/16/2006

Registered Users
Posts: 242
3/11/2006 09:57 PM  
Thanks for the answer
SBS 2003 R2 PREMIUM SP2 - EXCHANGE 2003 SP2 - ISA SERVER 2004 SP3
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > sql server 2000 own instance or upgrade..?


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