Re: Upgrading to R2 premium SQL questions
- From: v-chacez@xxxxxxxxxxxxx (chace zhang)
- Date: Mon, 16 Oct 2006 07:38:18 GMT
Hi,
Thank you for posting back.
I'm glad the info is helpful, please let me know if you need additional
help in the future, I look forward to working with you again.
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>
| References: <O1UEv2n7GHA.4708@xxxxxxxxxxxxxxxxxxxx>
<##B5Whp7GHA.1864@xxxxxxxxxxxxxxxxxxxxx>
<1A016F48-0C8C-4ACD-BB54-15C182AB7FDF@xxxxxxxxxxxxx>
| Subject: Re: Upgrading to R2 premium SQL questions
| Date: Fri, 13 Oct 2006 09:02:17 -0700
| Lines: 165
| 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: <eP7d4Du7GHA.4084@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:304849
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Once again I appreciate this group for helping all of us out.
|
| All of my questions were answered. :-)
|
|
| John
|
|
|
| "bass_player" <bassplayer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
| news:1A016F48-0C8C-4ACD-BB54-15C182AB7FDF@xxxxxxxxxxxxxxxx
| > Collation settings in SQL Server is commonly used for international
| > support.
| > The term, collation, refers to a set of rules that determine how data is
| > sorted and compared. Character data is sorted using rules that define
the
| > correct character sequence, with options for specifying
case-sensitivity,
| > accent marks, kana character types, and character width. We normally
use
| > this
| > to support our global clients. If your LOB application which uses SQL
| > Server
| > as it's backend database is only used for one regional setting, default
| > collation is typically accepted
| > --
| > MCP MCDBA MCAD MCSD MCT MCTS:SQL Server 2005
| > "Helping people grow and develop their full potential as God has plan
for
| > them"
| >
| >
| > "chace zhang" wrote:
| >
| >> 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
| >> |
| >> |
| >> |
| >> |
| >>
| >>
|
|
|
.
- References:
- Upgrading to R2 premium SQL questions
- From: John
- RE: Upgrading to R2 premium SQL questions
- From: chace zhang
- RE: Upgrading to R2 premium SQL questions
- From: bass_player
- Re: Upgrading to R2 premium SQL questions
- From: John
- Upgrading to R2 premium SQL questions
- Prev by Date: Using multiple accounts in POP3 connectors and Outlook 2003
- Next by Date: RE: Can not delete message from mailbox
- Previous by thread: Re: Upgrading to R2 premium SQL questions
- Next by thread: REMOTE PRINTING
- Index(es):
Relevant Pages
|
Loading
