"sysft_Content" - what is it?

upgraded 2000 - 2005 and applied sp1.

also same failure with SQL 2005 from scratch

tried to do a simple Backup Database of a db named 'msu' to a disk file on a local hard drive just like I would with 2000. failed with:

System.Data.SqlClient.SqlError: The backup of the file or filegroup
"sysft_Content" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the
selection to include only online data. (Microsoft.SqlServer.Smo)

That is your fulltext catalog. It needs to be rebuilt after the upgrade.

In sql2005, backups include fulltext, just like regular database and log files.

The fulltext catalog is modeled as a single "file".

You can take one of these actions and then try the backup again:

1) rebuild the catalog (the rebuild doesn't need to complete, and the re-crawl doesn't have to be triggered either)

2) drop the catalog

3) perform a file backup rather than full backup.

We are working on a KB article to address this problem, but it's not ready yet.

|||

Rebuild All - Failed to rebuild full-text catalog.
--Property PopulationStatus is not available for FullTextCatalog '[Content]'.
This property may not exist for this object,
or may not be retrievable due to insufficient access rights.
New Catalog & Drop Catalog - Cannot execute changes.
--Create failed for FullTextCatalog 'dfgdfg'. (Microsoft.SqlServer.Smo)
Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application. (Microsoft SQL Server, Error: 7616)

EXEC sp_fulltext_database 'enable'; - "Completed Successfully"
but still get the "Full-Text Search is not enabled" messages

login 'sa'

|||

Could you check if msftesql service is running properly?

Is msftesql service running in a different service account?

I suspect there is some problem due to upgrade so that full-text is not running properly.

thanks,

Jingwei

"Logon failure: unknown user name or bad password"

First, I checked all the obvious problems. The password is right and the login works perfectly.
Here is the output from Developer Studio when trying to deploy/process a cube:

Performing an incremental deployment of the 'MaxMinManufacturingDM' database to the 'localhost' server.
Generating deployment script...
Process Database MaxMinManufacturingDM
Done
Sending deployment script to the server...
Error -1056899072 : The following system error occurred: Logon failure: unknown user name or bad password. .
Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Max Min Manufacturing DM', Name of 'Max Min Manufacturing DM'.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Manufacturing Fact', Name of 'Dim Time' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Year Of Manufacture' attribute of the 'Dim Time' dimension from the 'MaxMinManufacturingDM' database was being processed.

My Analysis Services project (or Business Intelligence project) has only one Data Source, "Max Min Manufacturing DM.ds". I'm using a SQL Server login with a saved password.

I double click the data source to get to the "Data Source Designer" dialog and see the following connection string:

Provider=SQLNCLI.1;Data Source=localhost;Persist Security Info=True;Password=**********;User ID=MaxMinUser;Initial Catalog=MaxMinManufacturingDM

I click "Edit" and "Test Connection" and get "Test connection succeeded". The "Save my password" option is checked. The password is fine and the login should works perfectly. Developer Studio can obviously connect to the database since I've done all the design through it. I can't imagine why I'm getting this error.

I'm using:

Windows XP (dev machine)
Relational Data Mart is using SQL Server 2000 SP4 (I can't upgrade to SQL Server 2005 for business reasons beyond my control)
Visual Studio Studio 2005
SQL Server Analysis Services 2005 (I believe I put SP1 on this).

Any idea?

Hello. Are you running the SQL Server services and the SSAS2005 services with the same or different accounts?

When you process a cube the SSAS2005 must have permissions to read data from the source database. If you run SSAS2005 on a separate machine than the sourec database and the SSAS2005 service account is running as "local system" this server have no permissions on other servers/machines.

You can check this is the SQL Server Configuration manager(for SSAS2005).

Also, try the default impersonation mode for the data source connection.

HTH

Thomas Ivarsson

|||Great!!! Setting the "impersonation mode" to default worked. I guess I should read up on that so I understand what the difference between the impersonation mode and the database login is.

Yes, everything is running on the same server (it's a development box): SSAS2005, MSSQL2000, and Visual Studio.