Re: Sharepoint and SQL?
- From: v-chacez@xxxxxxxxxxxxx (chace zhang)
- Date: Fri, 25 Aug 2006 03:52:48 GMT
Hi,
Thank you for posting here.
As I mentioned, by default after you installing SBS Standard, there are 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.
I understand you have removed SQL on you SBS Server, and you want to set
Companyweb to MSDE, based on my experience, you can perform the following
steps to achieve your goal.
Please make sure to fully back up your SBS 2003 server prior to
reinstallation components.
I. Uninstall Intranet
1. Click Start, click Control Panel, and then click Add or Remove
Programs.
2. Select Windows Small Business Server 2003 and then click
Change/Remove. The Setup Wizard appears.
3. Click Next to start the wizard.
4. On the Windows Configuration page, click Next.
5. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet component to Remove, and then
click Next.
6. On the Component Summary page, click Next.
7. Click Finish.
II. Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT)
In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
(SHAREPOINT) and then click Remove. A dialog box appears. To confirm that
you want to remove, click Yes.
III. Delete Registry Keys
1. Delete
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Intranet
2. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SHAREPOINT
3. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web
Server Extensions\Ports\Port /LM/W3SVC/4: (Do not delete "Port
/LM/W3SVC/1:" because it is FronPage Server Extension 2002 which is
installed on the Default WebSite. If you see additional "Port
/LM/W3SVC/X:", backup and then remove them)
IV. Delete IIS Virtual Directory
1. Delete SharePoint Central Administration (Do Not Delete Microsoft
SharePoint Administration. It belongs to FronPage Server Extension)
2. Delete Companyweb
Note: If AV software install any extra IIS virtual directory, also remove
them if possible. They sometimes use port 8081 which will conflict with our
SharePoint Central Administration virtual directory.
V. Delete Application Pool
There should be only 4 application pools (DefaultAppPool,
ExchangeApplicationPool, ExchangeMobileBrowseApplicationPool, and
MSSharePointAppPool). Besides those 4, delete all the extra.
VI. Rename Folders
1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT
2. Rename C:\Inetpub\companyweb
VII. Install the intranet component
1. In Add or Remove Programs, select Windows Small Business Server
2003 and then click Change/Remove. The Setup Wizard appears.
2. Click Next.
3. On the Windows Configuration page, click Next.
4. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet and Monitoring components to
Install, and then click Next.
5. On the Logon Information page, click Next.
6. On the Component Summary page, click Next.
7. Click Finish.
VIII. The Installation should still fail, then apply the patch located at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CB7E90A1-DE9D-4A83-
85F8-951E9F055BF0&displaylang=en
For more information, I would also like to give you the following article.
829113 How to restore a Windows SharePoint Services CompanyWeb database
after the intranet component and SQL Server or MSDE 2000 have been removed
on Windows Small Business Server
http://support.microsoft.com/?id=829113
829114 How to remove and how to install the Windows Small Business Server
2003 SharePoint Services Companyweb Web site
http://support.microsoft.com/?id=829114
If you have any further questions or concerns, please feel free to let us
know. Thanks for your time and we look forward to hearing from you.
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.
--------------------
| NNTP-Posting-Date: Thu, 24 Aug 2006 06:53:49 -0500
| From: "MuniciNET" <dan@xxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| References: <ewGncMxxGHA.356@xxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Sharepoint and SQL?
| Date: Thu, 24 Aug 2006 07:46:29 -0400
| 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.2869
| X-RFC2646: Format=Flowed; Response
| Message-ID: <EfOdnbnLXsTQDnDZnZ2dnUVZ_rednZ2d@xxxxxxxxx>
| Lines: 44
| NNTP-Posting-Host: 67.102.13.203
| X-AuthenticatedUsername: NoAuthUser
| X-Trace:
sv3-BVYjQaer0PJzPXcEdzgoJGHk+asH4jDzp1gCU5rZaQTwulctPb9zJOWxKN0yJigpeoRHHNCH
2ZUG6rp!92efG4UOY5jQaU1i35P9I9v9w1tdw5ZSbJcDAz1P1n2g4jEPYzx+LBVzhDBCW0nkZxcR
F2xbTa3h!JbjbZvY=
| X-Complaints-To: webmaster@xxxxxxxxx
| X-DMCA-Complaints-To: webmaster@xxxxxxxxx
| X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
| X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
| X-Postfilter: 1.3.32
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!news-out.c
wix.com!newsfeed.cwix.com!newscon02.news.prodigy.net!prodigy.net!nx02.iad01.
newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.gig
anews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!nntp.lbdsl.com!new
s.lbdsl.com.POSTED!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:292565
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| OK, since Chance Zhang didn't come close to answering my question or even
| reading it, is there anyone else that could try a little harder to
actually
| read my problem and answer it? You guys are usually quick and right on,
and
| I appreciate you volunteering your time to answer these questions
(Microsoft
| employees, not withstanding).
|
| I guess the bottom line is: Can SharePoint and companyweb run on MSDE and
| how do I make that happen AFTER removing full SQL from my SBS box?
|
|
| "Dan Tschippert" <dan@xxxxxxxxxxxxx> wrote in message
| news:ewGncMxxGHA.356@xxxxxxxxxxxxxxxxxxxxxxx
| >I think I broke it. In an attempt to clean-up our SBS2003 box, I found
| >several connections to SQL that weren't being used anymore. They were
from
| >various software we tried out. We had uninstalled the trial software,
but
| >it apparently left the connections to SQL. Sooooo, I stopped SQL to make
| >sure what we needed wouldn't be affected and all seemed well with SQL
| >shutdown.
| >
| > I uninstalled SQL, rebooted and now our "companyweb" sharepoint won't
| > work. It worked while I had SQL shutdown, but won't work with it
| > uninstalled.
| >
| > So my question I guess is: does sharepoint and the company web need SQL
or
| > did I "break" something else. I looked at KB823287. Part of the KB says
to
| > look for MSSQL$SHAREPOINT and make sure it is running in services.
Well,
| > it is and it is!
| >
| > But the rest of the article says to go to programs and to SQL but
| > obviously, since I uninstalled it it isn't there.
| >
| > So, do I need to reinstall SQL in order to have "company web" and
| > shartpoint?
| >
| > The problem I was trying to solve was extreme latency between the
clients
| > and server that was affecting almost everything. Printing, internet
use,
| > file use. Since I stopped SQL and subsequently uninstalled it, there is
| > GREAT improvement so I guess the faux SQL connections were part of the
| > problem.
| >
| > Thanks, in advance if any has any comments or help to offer!
| >
|
|
|
.
- References:
- Sharepoint and SQL?
- From: Dan Tschippert
- Re: Sharepoint and SQL?
- From: MuniciNET
- Sharepoint and SQL?
- Prev by Date: RE: ISA 2004 - Messager Screener and Download Limit
- Next by Date: Re: Moving Exchange Server files
- Previous by thread: Re: Sharepoint and SQL?
- Next by thread: Re: Sharepoint and SQL?
- Index(es):
Relevant Pages
|
Loading
