Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Several issues involving STS, SQL, and IIS

Asked By: Jamie Baker Date: Mar 24, 2006 Category: Sharepoint Views: 191

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?

Tagged:several issues involving sts sql and iis

3 Answers Found

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

A 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
SharePoint.

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

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, 2006

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
installed.

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.