Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Several issues involving STS, SQL, and IIS

  Asked By: Jamie    Date: Mar 24    Category: Sharepoint    Views: 948

1. We cannot run maintenance plans and therefore we can not use SQL
automated backups and maintenance tasks.
2. We can not use SQL Enterprise Manager over the network to connect
to the database. If we install anything under the network parameters
the site then refuses connections.
3. The search function in SharePoint is not working. The full text
function is installed in SQL and the searh function button is checked.
The database is installed as a single instance in IIS and is not
installed as a farm. Should it be installed as a farm? If so, is
there a way to either migrate this installation, or do we need to do a
new install with a restore from a sharepoint backup?
Are these issues related to the IIS database being installed as a
single install instead of as a farm, or is this a characteristic that
is inherent to setting up this type of configuration of WSS and SQL?



3 Answers Found

Answer #1    Answered By: Freddy Heath     Answered On: Mar 24

single  server setup *is* a farm  - it's just that you have all four
roles running on the same box. The database  installed in IIS is
connected to a virtual server and does not in any way define the type  of
farm you have. The farm database is hosted in SQL, not IIS. Based on
what you've written here, I think your problem is with SQL, not

Answer #2    Answered By: Joanna Dixon     Answered On: Mar 24

I am beginning to think it is the SQL.
This is all very new to me.

Answer #3    Answered By: Gopal Jamakhandi     Answered On: Mar 24

Sharepoint sets the full  Text indexing in sql  to use 'Change Tracking
Update in Background'. In order for this to work we found that you
need to set the idle CPU condition on the SQL Agent Service. It is
not set by default. You might also need to manually populate the sql
FT catalogs for the first time if they didn't when the farm  was

Didn't find what you were looking for? Find more on Several issues involving STS, SQL, and IIS Or get search suggestion and latest updates.