RE: Upgrading to R2 premium SQL questions

Hi,

Thank you for posting here.

From your post, I understand you want to upgrade to SBS SQL 2005 on SBS R2.
If I'm off base, please do not hesitate to let me know.

Technical speaking on SBS server, there are already 2 instances using MSDE
to store SharePoint (Companyweb) uses the MSSQL$SharePoint database, while
the Monitoring features use the MSSQL$SBSMonitoring database to store data.
Both of these features are mutually exclusive for the most part.

You could (and you should) upgrade the SharePoint named instance to full
SQL from MSDE to SQL 2005.

Note : You cannot upgrade the Monitoring instance to SQL

Actually, the detailed installation instructions have already been
integrated into the sqlinstallsteps.htm file in the SBS 2k3 R2 Premium CD
root folder,

Upgrade the SHAREPOINT instance of WMSDE to SQL 2005 Work Group Edition.

" To prepare the http://companyweb Web site
" To create the SQL Server 2005 Workgroup Edition SHAREPOINT instance
" To configure permissions for the new SHAREPOINT instance of SQL Server
2005
" To turn on full-text search in Windows SharePoint Services



The following article describes the detailed steps, screenshots and some
additional tips for upgrading SharePoint instance to SQL 2005:

SBS 2003 R2 - Upgrading the SharePoint instance to SQL 2005
http://www.smallbizserver.net/tabid/266/articleType/ArticleView/articleId/21
1/Default.aspx

You can download the PDF for offline reading here:
http://www.smallbizserver.net/tabid/228/Default.aspx

Hope this helps, if you need more help on this issue, 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: "John" <nospam@xxxxxxxxxxx>
| Subject: Upgrading to R2 premium SQL questions
| Date: Thu, 12 Oct 2006 21:11:35 -0700
| Lines: 18
| 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: <O1UEv2n7GHA.4708@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: ip68-231-202-20.oc.oc.cox.net 68.231.202.20
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:304735
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| I have a client that I am upgrading from SBS SP1 Premium to R2 Premium.
| He is only using SQL from the premium part. My questions are:
|
| 1. If we are not using SQL for SharePoint do I need to upgrade the
| MSDE for it? Or for that matter do anything with the MSDE?
|
| 2. I have looked at the SQL2000 to 2005 docs and I have no clue about
the
| collation settings. Does anyone have any realworld experiance on this
| upgrade?
|
|
| Thanks
|
|
| John
|
|
|
|

.

Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade
    ... Last week my client wanted me to upgrade a SBS standard edition to ... I ran through the html procedure to install single instance of SQL ... I then tried to upgrade Sharepoint from MSDE to SQL as per same ...
    (microsoft.public.windows.server.sbs)
  • RE: Migration to SQL 2005 for Workgroups
    ... there are already 2 instances using MSDE ... You could upgrade the SharePoint named instance to full ... SQL from MSDE to SQL 2005. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Upgrade of Sharepoint to SQL Server 2000 - Questions
    ... If you are using SBS 2003 Premium Edition then you could upgrade the ... SharePoint named instance to full SQL. ... enjoy Full Text Search in Sharepoint and all the advantages SQL server ...
    (microsoft.public.windows.server.sbs)
  • Re: Configuring Full Text Search FOr SharePoint Web
    ... My SharePoint database had been upgraded to SQL and the data was being ... You need to make sure that you have upgrade your sharepoint instance to ...
    (microsoft.public.windows.server.sbs)
Loading