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: Basic question(s) - instances and licensing
Prev Next
You are not authorized to post a reply.

Author Messages
Mike Webb User is Offline
United States
Member since
3/31/2005

Registered Users
Posts: 163
7/11/2008 05:13 PM  
I have 2 servers - SBS 2003 Premium SP1 and one running Windows Server 2003 R2 Std. SP2.  On the second server I have installed MOSS 2007, and have a 300GB partition on it for the datafiles, docs, etc.
 
I had hoped to leverage SQL 2000 on the SBS server to "run" the database I'll create for MOSS, with the database files located in that 300GB partition.  However, I had problems yesterday trying to install a named instance of SQL on the SBS server and mapping a path to the other server's partition.  SQL installation didn't like that.  Further reading told me that it needs to go into the default paths so it can share the tools resident in SQL.
 
My qustions are:
(1) Is a "named instance" considered a separate/new installation of SQL server?
(2) I thought of using KB 224071 to move the database files over, but I think this may be for attaching to a new SQL Server instead of what I'm thinking about.  Can someone explain what "moving the databases" means, with repect to SQL Server we install on SBS?
(3) What licensing problems are there if installed SQL Server from the SBS server, but chose the Remote Computer option?
Mike Webb
Platte River Whooping Crane Maintenance Trust, Inc.
a conservation non-profit organization
Nebraska, USA
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
8/31/2008 02:37 AM  
Hi Mike,

Did you figure this out yet?
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 Webb User is Offline
United States
Member since
3/31/2005

Registered Users
Posts: 163
9/02/2008 03:57 PM  
Yes, but it wasn't as I expected.  I got a reply on the MS SBS newsgroup to check the HP website for my model.  Turns out that it IS a single processor and the BIOS just "sees" it as two.  Problem solved.
Mike Webb
Platte River Whooping Crane Maintenance Trust, Inc.
a conservation non-profit organization
Nebraska, USA
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Basic question(s) - instances and licensing


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