RE: migrating from wmsde to sql server

Hi Joe,

Thanks for your update! I am glad to know the MSDE migration issue is
getting fine now. I appreciate your time and effort to try my suggestions
and get this resolved.

Yes, as you done, we need register the instance in SQL Enterprise Manager
so that we can manage it in SQL Enterprise Manager. The detail steps:

A. Click Start, point to All Programs\Microsoft SQL Server, and then click
Client Network Utility. Make sure "Enable shared memory protocol" is
selected.
B. Open Enterprise Manager, right-click a server or a server group, and
then click New SQL Server Registration. Click Next.

NOTE: If you selected the From now on I want to perform this task without
using a wizard check box the last time you used the Register Server Wizard,
SQL Server Enterprise Manager displays the Registered SQL Server Properties
dialog box. Otherwise, the Register Server Wizard is started.

C. In the Server box, type the instance name, ie, <sbsserver>\SHAREPOINT,
and click Add and then Next.
D. Click "The Windows account information I use to log on to my computer
(Windows Authentication)", and then click Next.
E. In the Server Group list, click a server group and click Next.

NOTE: If the group you need does not exist yet, create it by clicking the
build (...) button, and then completing the Server Groups dialog box.

F. Click Finish, and then Close.

After we register the instance, we can see it at the left panel of SQL
Enterprise Manager immediately. If it doesn't appear, we can restart the
SQL Enterprise Manager to resolve it.

You can follow MS KB article 837367 to turn on full-text search in WSS:
837367 How to turn on full-text search in Windows SharePoint Services on a
http://support.microsoft.com/?id=837367

Please feel free to post back when you need further assistance on this
issue and I am always happy to be assistance of you!

Have a nice day!

Best Regards,

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: migrating from wmsde to sql server
>thread-index: AcXCopxNWsL7yCd5SKS3+/Tsg8S5tQ==
>X-WBNR-Posting-Host: 166.82.89.10
>From: =?Utf-8?B?Sm9l?= <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <A2D87F3E-3185-406D-842A-E6302F452703@xxxxxxxxxxxxx>
<cZOvuZkwFHA.3020@xxxxxxxxxxxxxxxxxxxxx>
>Subject: RE: migrating from wmsde to sql server
>Date: Mon, 26 Sep 2005 07:00:11 -0700
>Lines: 113
>Message-ID: <3B8EE7EE-CB91-4F92-97B6-511128A4E9B3@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: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:156494
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>I do see it now. After registering I had to reboot the server(maybe it
may
>have worked if I stoped and restarted SQL services). Thanks for the help
>Now I will work on the search field.
>
>
>""Jenny wu [MSFT]"" wrote:
>
>> Hi,
>>
>> Thanks for posting here! I am sorry for the delayed response due to
>> weekend. Please understand that the newsgroups are staffed weekdays by
>> Microsoft Support professionals to answer your systems and applications
>> questions. Your understanding is greatly appreciated!
>>
>> Regarding to your post, I understand that the SQL Server 2000 Setup
Control
>> Manager hangs at "Setup is preparing to copy files" when upgrading the
>> Sharepoint instance of WMSDE to full SQL 2000 Server. If I am off base,
>> please don't hesitate to let me know.
>>
>> Based on my research, the issue caused by that the Service Control
Manager
>> (Scm.exe) experienced a time-out when it tries to stop the
MSSQL$SharePoint
>> service.
>>
>> To work around this problem, we must manually stop the MSSQL$SharePoint
>> service before we start the Setup program to upgrade the instance of SQL
>> Server 2000 Desktop Engine (Windows).
>>
>> To manually stop the MSSQL$SharePoint service, you can follow below
steps:
>>
>> 1. Click Start, click Run, type Services.msc, and then click OK.
>> 2. In the right pane of the Services window, locate MSSQL$SharePoint.
>> 3. Right-click MSSQL$SharePoint, and then click Stop.
>> 4. Close the Services window.
>>
>> For more detail information, please refer to the following KB article:
>> 841773 BUG: SQL Server Setup stops responding when you upgrade an
instance
>> of
>> http://support.microsoft.com/?id=841773
>>
>> Try to test, does the issue be fixed?
>>
>> I am currently standing by for your test result and I am glad to be
further
>> assistance!
>>
>> Have a nice day!
>>
>> Best Regards,
>>
>> 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: migrating from wmsde to sql server
>> >thread-index: AcXANjC9AjGiJOYKTzOhJWkcS7GOdw==
>> >X-WBNR-Posting-Host: 166.82.89.10
>> >From: =?Utf-8?B?Sm9l?= <Joe@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >Subject: migrating from wmsde to sql server
>> >Date: Fri, 23 Sep 2005 04:59:02 -0700
>> >Lines: 9
>> >Message-ID: <A2D87F3E-3185-406D-842A-E6302F452703@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: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:155868
>> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >
>> >On SBS Permium, I have SQL SP3 already installed at the time of initial
>> >server setup and now I'm looking to use sharepoint services.
>> >I'm in the process of migrating from wmsde to sql server bu following
>> >artical: http://support.microsoft.com/?id=837367
>> >After stepping through the wizzard it is at the point of "setup is
>> preparing
>> >to copy files" and it has been there for a couple of hours.
>> >Is it because I already have SP3, because all the documents refer to
>> >migrating before SQL SP3?
>> >
>> >
>>
>>
>

.