Re: SBS2003 SQL question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi,

Thank you for your update. I'm glad to hear that the info that I delivered
was helpful.

Yes, the restrictions of R2 are similar with Small Business Server 2003 SP1.

More info please refer to following article:

Release Notes for Windows Small Business Server 2003 R2

http://www.microsoft.com/downloads/details.aspx?FamilyId=017C0553-B1AD-44B3-
84D1-4D2B07D41CD8&displaylang=en


If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.

Best Regards,

Chace Zhang (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| From: "Andrew Kennard" <a.kennard@xxxxxxxxxxxxxx>
| References: <uMqaPnb$GHA.3560@xxxxxxxxxxxxxxxxxxxx>
<GllZmVm$GHA.4432@xxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: SBS2003 SQL question
| Date: Thu, 2 Nov 2006 15:45:21 -0000
| Lines: 181
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
| X-RFC2646: Format=Flowed; Original
| Message-ID: <e7I7oXp$GHA.4328@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: wor2092m-adsl.demon.co.uk 80.177.112.17
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:309790
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Thank you VERY much for your informative reply !
|
| My original post should have really said SBS2003 R2 ! ;)
|
| I notice towards the end of your reply you seem to be talking of SBS2003
SP1
| I assume it's almost the same for R2
|
| I understand about having to purchase licenses for SQL Server 2005
| Standard/Enterprise
|
| Thanks very much for all the info on the designed in limitations of SBS
|
| Kind Regards
|
| Andrew
|
|
|
| "chace zhang" <v-chacez@xxxxxxxxxxxxx> wrote in message
| news:GllZmVm$GHA.4432@xxxxxxxxxxxxxxxxxxxxxxxx
| > Hi,
| >
| > Thanks for your post.
| >
| > As we know, SQL 2005 workgroup edition is included in the SBS 2003 R2
| > premium. If you want to use SQL 2005 standard edition or Enterprise
| > edition, you need to purchase the SQL 2005 standard edition as well as
the
| > CALs.
| >
| > Actually, we can install SQL Server 2005 Standard Edition and Enterprise
| > edition on Windows Small Business Server 2003 with SP 1 or later. For
| > information about this, you can check the following web site:
| >
| > SQL Server 2005 Standard Edition System Requirements
| > http://www.microsoft.com/sql/editions/standard/sysreqs.mspx
| >
| > SQL Server 2005 Enterprise System Requirements
| > http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx
| >
| >
| > After you installing the SQL Server 2005 Standard Edition to the SBS
| > server, you will be able to upgrade the SharePoint MSDE instance to the
| > SQL
| > instance. If you encounter any issue during that process, you can post
the
| > issue into the SQL newsgroup for assistance.
| >
| > microsoft.private.directaccess.sqlserver
| >
| > Please kindly note that the SBS 2003 Server is a integrated solution
| > production, it contains Windows 2003 Standard Server, Exchange 2003
| > Standard Server, WSS, SQL Server 2000 (Premium Edition), ISA 2000 or
2004
| > (Premium Edition or SP1). We cannot run Exchange 2003
| > Additionally, the Windows Small Business Server 2003 operating system
has
| > the following restrictions:
| > 1. Only one computer in a domain can be running Windows SmallBusiness
| > Server 2003.
| >
| > 2. Windows Small Business Server 2003 must be the root of the Active
| > Directory forest.
| >
| > 3. Windows Small Business Server 2003 cannot trust any other domains.
| >
| > 4. A Windows Small Business Server 2003 domain cannot have any child
| > domains.
| >
| > 5. Each additional computer running Windows Server 2003 must have a
| > Windows
| > Small Business Server 2003 client access license (CAL).
| >
| > 6. A Windows Small Business Server 2003 domain can have no more than 75
| > CALs. You can use CALs for each user or for each device.
| >
| >
| > 7. Terminal Server is not included. Windows Small Business Server 2003
| > does
| > not include Terminal Server. However, you can remotely administer
| > computers
| > using Remote Desktop for Administration (in Microsoft Windows 2000
Server,
| > this was called Terminal Services in Remote Administration mode), which
| > allows you to connect to the console or to create up to two new sessions
| > from another computer. If you want to use Terminal Server to host
| > applications centrally, you must install a second server.
| >
| >
| > Hope above information helps.
| >
| >
| > If anything unclear, please do not hesitate to let me know.
| >
| > Have a nice day!
| >
| >
| > Best Regards,
| >
| > Chace Zhang (MSFT)
| >
| > Microsoft CSS Online Newsgroup Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================
| > This newsgroup only focuses on SBS technical issues. If you have issues
| > regarding other Microsoft products, you'd better post in the
corresponding
| > newsgroups so that they can be resolved in an efficient and timely
manner.
| > You can locate the newsgroup here:
| > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| >
| > When opening a new thread via the web interface, we recommend you check
| > the
| > "Notify me of replies" box to receive e-mail notifications when there
are
| > any updates in your thread. When responding to posts via your
newsreader,
| > please "Reply to Group" so that others may learn and benefit from your
| > issue.
| >
| > Microsoft engineers can only focus on one issue per thread. Although we
| > provide other information for your reference, we recommend you post
| > different incidents in different threads to keep the thread clean. In
| > doing
| > so, it will ensure your issues are resolved in a timely manner.
| >
| > For urgent issues, you may want to contact Microsoft CSS directly.
Please
| > check http://support.microsoft.com for regional support phone numbers.
| >
| > Any input or comments in this thread are highly appreciated.
| >
| > =====================================================
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| > --------------------
| > | From: "Andrew Kennard" <a.kennard@xxxxxxxxxxxxxx>
| > | Subject: SBS2003 SQL question
| > | Date: Wed, 1 Nov 2006 13:29:45 -0000
| > | Lines: 24
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
| > | X-RFC2646: Format=Flowed; Original
| > | Message-ID: <uMqaPnb$GHA.3560@xxxxxxxxxxxxxxxxxxxx>
| > | Newsgroups: microsoft.public.windows.server.sbs
| > | NNTP-Posting-Host: wor2092m-adsl.demon.co.uk 80.177.112.17
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:309494
| > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > |
| > | Hi all
| > |
| > | If I start with a SBS2003 R2 server and find that I need more features
| > than
| > | are availible in the SQL 2005 workgroup edition can I upgrade just the
| > SQL
| > | server to Standard/Enterprise later ?
| > |
| > | I dont think I'm ever going to need lots of 'power' but lots of
features
| > is
| > | important. eg not fully checked out all the mirroring/sync options etc
| > yet.
| > |
| > | Also Is there any difference to the underlying W2003 OS whether
'full'
| > | verion or SBS ?
| > |
| > | ie if you install a standard/enterprise SQL server on SBS is it
| > restricted
| > | by the operating system in anyway ?
| > |
| > | Thanks in advance for you help
| > |
| > | Kind Regards
| > |
| > | Andrew
| > |
| > |
| > |
| > |
| > |
| >
|
|
|

.



Relevant Pages

  • Re: Email enable doc lib
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... navigate to the public folder and send some posts with attachments to the ... I have disabled forms base Athentication from the default V.Smtp server ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant logon from workstation as Administrator
    ... server box and let me know if there is any problem related to the issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... be able to logon using ANY accounts from that workstation. ...
    (microsoft.public.windows.server.sbs)
  • RE: w3wp.exe unable to start properly and mail delivery very slow
    ... I will be here waiting for your updates, please feel free to post back. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... |> internal NIC as the DNS server on both client computer and SBS server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Nagging Autorization issue for Companyweb after ISA04 install
    ... Check the companyweb CNAME entry in the DNS Server. ... Does the situation occur when you access companyweb from the ISA ... > 'Microsoft Firewall' service. ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Email enable doc lib
    ... server to test the issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Please try to logon Public folder list using URL: ...
    (microsoft.public.windows.server.sbs)