RE: SQl Server after upgrade



Brandy:

Thank you for the reply. As you can see my challenges go further that just
text indexing and I plan to install CRM 3.0 Dynamics. Most important is the
fact that the SQL instance \\servername\SHAREPOINT does not seem to hold once
I register it in enterprise manager. Also if another user signs on after I
re-register it they do not see any registered instance in enterprise manager.

My question is should I unistall and reinstall or just try to complete the
install over what is already there. I am 99% sure I followed the install
proceedure detailed in the installing premium technologies section for SBS
2003 to upgrade the SQL sharepoint instance but.....

You help is appreciated.

Thanks,

emagidson

""Brandy Nee [MSFT]"" wrote:

Hello Emagidson,

Thank you for posting to the SBS Newsgroup.

I understand that you cannot turn on Full Test Search in SharePoint on
the SBS Server. If I have misunderstood your issue, please let me know.

I need to confirm with you if you strictly follow our KB837367 to turn on
full-text search:

837367 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

If you have already performed KB837367, please see my following
suggestions:

1. Use Notepad program to edit a txt file which contains the string
"abc123".

2. Upload the file to the document library.

3. Open SQL Query Analyzer. Connect to the SharePoint database
(ServerName\SHAREPOINT; select Windows authentication method).

4. Run the following command:

Select LeafName from docs where contains (content, 'abc123')

5. Will the system find the content?

For your third questions how to install CRM on SBS Server, please see
following White Papers:

Installing and Securing Microsoft CRM 1.2 on a Windows Small Business
Server 2003 Network
http://www.microsoft.com/downloads/details.aspx?FamilyID=C835F117-A447-48DB-
940B-48EF88A192A3&displaylang=en

Microsoft CRM Implementation Guide - Installing Microsoft CRM Server on
Microsoft Small Business Server
http://www.microsoft.com/technet/prodtechnol/mscrm/mscrm1/deploy/15_sbsrv.ms
px

Chapter 15 has been updated. The update is located here:

Installing Microsoft CRM Server version 1.2 on Microsoft Windows Small
Business Server 2003
http://www.microsoft.com/downloads/details.aspx?familyid=ddbb17dc-fe7f-4309-
b03b-1fc1c4eb6a97&displaylang=en

Download this Installing and Securing Microsoft CRM 1.2 on a Windows Small
Business Server 2003 Network document
http://download.microsoft.com/download/7/0/8/7088e40b-af99-4657-a1a0-948efb9
96196/Installing_and_Securing_CRM_on_SBS.doc

Regarding your second and fourth questions, they are much more related
to SQL Server. This inquiry would best be posted to the SQL Newsgroup t
<microsoft.private.directaccess.sqlserver>. The reason why we recommend
posting appropriately is you will get the most qualified pool of
respondents, and other customers who read the newsgroups regularly can
either share their knowledge or learn from your interaction with us.

Thank you for your time and understanding!

Best regards,

Brandy Nee

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: SQl Server after upgrade
thread-index: AcabJ7HDbGPUu1EFTVGV9qQujE1TPQ==
X-WBNR-Posting-Host: 66.220.103.48
From: =?Utf-8?B?RU1hZ2lkc29u?= <EMagidson@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <778D65D1-FBAE-4A45-9204-61775166CEE9@xxxxxxxxxxxxx>
Subject: RE: SQl Server after upgrade
Date: Wed, 28 Jun 2006 19:57:01 -0700
Lines: 42
Message-ID: <4FD13BE5-7DFD-432B-B0F3-D245A0BFF4EC@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.1830
Newsgroups: microsoft.public.windows.server.sbs
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:278122
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.sbs

More information:

The SQL Server seems to become unregistered in Enterprise Manager when I
rebooted the system this eveing.


.



Relevant Pages

  • RE: Cant connect in to server!
    ... Cant access remote web workplace from outside server, ... Installing RRAS returned OK ... > address 3389 on the command line and paste the results to the newsgroup. ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: NTBackup failing with Event ID 215 ESENT referencing certsrv.e
    ... I would first suggest you installing the following update ... for Volume Shadow Copy service and keep your server up to date. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN disconnection
    ... installing the hotfixes, there will be some problems with VPN. ... Therefore if you installed SP2 on the server, ... Acceleration (ISA) Server 2006 or ISA Server 2004 ... 'Microsoft Firewall' service. ...
    (microsoft.public.windows.server.sbs)
  • Re: iis config
    ... IISlockdown including URLscan and hfnetchk and signing up for the microsoft ... security patches newsletter and installing patches as soon as they come out] ... If you're planning on doing your own security, ... on your server, this may be a false alarm. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Trouble in Windows Firewall
    ... I must try to installing our server from first again? ... Newsgroups: microsoft.public.windows.server.sbs ... I've tried to install program Microsoft Management Console 3.0 for Windows ...
    (microsoft.public.windows.server.sbs)