RE: transfer companyweb config db

Hi,

Thanks for your update! Please see my answer follows:

Q1. Can i preserve my companyweb website by tranferring the current
configuration database for sharepoint services to a new location on the sql
server.

A: You may mistake SQL server conception. When you install SQL server on
one computer, there will be a SQL instance installed on the computer. You
can install many SQL instances on one computer. After you installed
intranet component on the SBS server box, the Sharepoint WMSDC instance has
been installed on the server. It is not different from the instance created
when you install the SQL server.

To move the Sharepoint instance to another location, please refer to the
following white paper to process.

Moving Data Folders for Windows Small Business Server 2003
http://download.microsoft.com/download/1/1/6/11671e4d-fb21-489c-870f-db36fd2
1a7d2/SBS_MoveDataFolders.DOC

The article includes contents of how to:
a. Move the Users Shared Folders
b. Move the SharePoint Databases
c. Move the Monitoring Database
d. Move Exchange Databases and Log Files
e. Move the Sent Faxes Folder
f. Move the ClientApps Shared Folder

Additionally you can upgrade the Sharepoint WMSDC instance to SQL instance
to enable the Sharepoint service full-text search. The both processes (move
database and upgrade instance) are not interferential each other.

You can refer to the following KB article to get detail steps to upgrade
the instance:

How to turn on full-text search in Windows SharePoint Services on a Windows
Small Business Server 2003-based computer
http://support.microsoft.com/default.aspx?scid=kb;en-us;837367

Q2. My problem with project web access is when i go to view my projects or
tasks it goes to the project page for a couple of seconds then throws me
out back to the page i was on previously. Could the sharepoint config
database being in the wrong location be the cause of my grief?

A: I don't think it is the faulty of the Sharepoint database. How you
configured project server integration with SBS 2003 server box?

You can refer to the following steps to process it. Hope it helps!

1) Create a new Web Site in IIS, configured for Scripts and Executables.
For this site, use port 8085 (anything really, so long as it's unique), do
not use host headers or assigned IP addresses.

2) Create a new App Pool, and configure it to run as a Domain user that is
an Administrator on the server. (member of Local Admins group, domain
admins if it's a DC)

3) In SharePoint Central Administration, extend the new website, creating a
new Content Database in SQL Server 2000 for the new site. When it
completes, DO NOT pick a template and assign it to the site.

4) From the Project Server CD, run WSSWiz.exe and select the newly created
site to apply the templates to. You can find WSSWiz on the CD in
\SUPPORT\WSSWIZ\WSSWiz.exe.

5) Visit the PWA > Admin > Manage Windows SharePoint Services > Connect to
SharePoint server page. Enter the following information:

* SharePoint Central Administration URL: http://server:8088
<click the "Test URL" link to confirm>

* Create a site under this SharePoint URL: http://server:8085/sites
<click the http://server:8085/sites/MS_ProjectServer_PublicDocuments link
to confirm>

If both tests pass, click Save Changes at the bottom of the page.

How about the result?

Hope it helps! I am happy to be assistance of you and look forward to your
reply!

Have a nice day!

Sincerely,

Jenny Wu
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.

--------------------
>Thread-Topic: transfer companyweb config db
>thread-index: AcX1lUXinbFgbmvoS+mN9WMPGPLHHg==
>X-WBNR-Posting-Host: 147.10.225.138
>From: "=?Utf-8?B?Y2p1cGl0ZXI=?=" <cjupiter@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <67396178-6D1F-4F27-910C-88747069E7C3@xxxxxxxxxxxxx>
<0mXWafK9FHA.832@xxxxxxxxxxxxxxxxxxxxx>
>Subject: RE: transfer companyweb config db
>Date: Wed, 30 Nov 2005 02:03:12 -0800
>Lines: 141
>Message-ID: <927268A2-32AA-44D9-A3CF-79AF5367C134@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:226633
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Perhaps I was not quite clear in my intial post
>
>What i want to do is preserve everything i have currently setup in my
>current companyweb website. I have setup links, uploaded documents..etc.
Now
>i want to transfer the config database from the default location for
>sharepoint services being Servername\Sharepoint to a new location being on
>the SQL server.
>
>So basically companyweb is still working at the moment, but project web
>access is not working correctly. I think what might solve the problem with
>project web access not working correctly is to use a config database on
the
>sql server like it says in the setup guide when installing project server.
>
>So really i have two questions:
>
>1. Can i preserve my companyweb website by tranferring the current
>configuration database for sharepoint services to a new location on the
sql
>server.
>
>2. My problem with project web access is when i go to view my projects or
>tasks it goes to the project page for a couple of seconds then throws me
out
>back to the page i was on previously. Could the sharepoint config database
>being in the wrong location be the cause of my grief?
>
>""Jenny wu [MSFT]"" wrote:
>
>> Hi,
>>
>> Thanks for using the SBS newsgroup!
>>
>> For your description, I understand that the companyweb site can not work
>> after installed SQL server and project server on the SBS 2003 server
box.
>> If I am off base, please don't hesitate to let me know.
>>
>> Before we go further, please kindly help me collect some information to
>> isolate the issue:
>>
>> 1. What is the error message when you try to access the companyweb site?
>> Please give the accurate error message.
>>
>> 2. Is the MSSQL$SHAREPOINT service running (type "services.msc" (no
>> quotation marks) in CMD prompt to open Services console)? If not, please
>> start it and set the Start type as "Automatic" and then test, how about
the
>> result?
>>
>> 3. How you configured the SQL config database? Could you describe me
>> detail? By default, when you install SQL server on SBS server box, it is
>> not necessary to configure Sharepoint WMSDE instance to use sql instance
>> and they work separately. And also we can upgrade the Sharepoint WMSDE
>> instance to SQL. You should refer to the following KB article to process:
>>
>> How to turn on full-text search in Windows SharePoint Services on a
Windows
>> Small Business Server 2003-based computer
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;837367
>>
>> 4. Can you find any related error event logged in the Event Viewer? If
yes,
>> please paste the detail error information in the newsgroup.
>>
>>
>> Related information:
>>
>> 827701 How to perform a disaster recovery operation of SharePoint
Services
>> http://support.microsoft.com/?id=827701
>>
>> 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
>>
>> I appreciate your time. I am happy to be assistance of you and look
forward
>> to your update!
>>
>> Have a nice day!
>>
>> Sincerely,
>>
>> Jenny Wu
>> 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.
>>
>> --------------------
>> >Thread-Topic: transfer companyweb config db
>> >thread-index: AcX0MpEVX1NTrhnpQOOef8/b9OrXgg==
>> >X-WBNR-Posting-Host: 147.10.225.138
>> >From: "=?Utf-8?B?Y2p1cGl0ZXI=?=" <cjupiter@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >Subject: transfer companyweb config db
>> >Date: Mon, 28 Nov 2005 07:44:06 -0800
>> >Lines: 7
>> >Message-ID: <67396178-6D1F-4F27-910C-88747069E7C3@xxxxxxxxxxxxx>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.windows.server.sbs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:226049
>> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >
>> >I have recently installed SQL server 2000 on my win SBS 2003 machine.
In
>> the
>> >process of installing project server 2003 i had to set the config
database
>> to
>> >a database within sql server. Now i can not get companyweb to work
because
>> >its config was located in a different config database. Is there anyway
i
>> can
>> >make companyweb work again with the new config database on the SQL
server
>> >that i used for project server, preserving all data created within that
>> >companyweb website?
>> >
>>
>>
>

.

Relevant Pages

  • I broke Sharepoint :(
    ... SBS was installed and the server was up and running including the default ... After 2 days I was looking at SQL backups I relaised that Sharepoint ... database and the other instances were not migrated accross. ...
    (microsoft.public.windows.server.sbs)
  • Re: Service Account Password Change
    ... app pools and changed the passwords, when I got to the sharepoint admin ... the sharepoint domain account didnt have the database admin ... Our dev environment is a domain member server running sharepoint portal ... > Detach from the config database in SharePoint Central Administration ...
    (microsoft.public.sharepoint.portalserver)
  • Steps for Migrating WSS 3.0 from Windows Internal Database to Microsoft SQL 2005
    ... done the stupid things I did when I started playing with Sharepoint ... when I first installed it and assuming that it would find the SQL 2005 ... Windows Internal Database). ... Reboot the server to finish up any uninstall scripts. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Failing Application?
    ... logon the server, and you find the following error message in Event Log: ... Check the database connection information and make sure that the database ... this problem could be caused because the SharePoint ... Timer Service failed to contact the SharePoint database while the SBS is ...
    (microsoft.public.windows.server.sbs)
  • Re: SPS 2003 Portal change SQL server
    ... db's to new server and save the config database for last). ... Stop the virtual server in IIS ... Sharepoint Portal Server ...
    (microsoft.public.sharepoint.portalserver)