Add Reporting Services to Trusted Accounts

I installed SQL 2005 SP2 and RS add-in for Sharepoint to a WSS 3.0 site.

I get the error: 'A connection to the server cannot be established' when I try to use the sharepoint account set up for this purpose. It is in the farm administrators, and has the required permissions when I check the database. Are there any other recommended troubleshooting tips that I can do? Thanks.

Dan

FYI - I resolved the problem by adding the account to the local group WSS_RESTRICTED_WPG. This account needs to be in the Local Administrator's group, and the groups starting with WSS.

Add Category to SQL Full-text

I'm moving my STS sites to WSS, and I'm running into a bit of a
problem. We've got everyone on our team adding a category to their
documents to help us search and organize them. However, seach under
WSS (w/ SQL and Free-Text search) doesn't pick up the category field
in my Word documents.
I saw some talk about adding it via SQL so it appears in searchs
through Sharepoint, but I've no idea how. Any suggestions or
instructions that could help me out here?
that's correct. SQL FTS only indexes documents contents when they are stored
in the image data type columns. It doesn't index properties. You would have
to extract the property and store it separately in a column in the table you
are full text indexing.
"Elroy" <derekvof@.yahoo.com> wrote in message
news:47f03009.0403231310.5344561b@.posting.google.c om...
> I'm moving my STS sites to WSS, and I'm running into a bit of a
> problem. We've got everyone on our team adding a category to their
> documents to help us search and organize them. However, seach under
> WSS (w/ SQL and Free-Text search) doesn't pick up the category field
> in my Word documents.
> I saw some talk about adding it via SQL so it appears in searchs
> through Sharepoint, but I've no idea how. Any suggestions or
> instructions that could help me out here?