Showing posts with label searching. Show all posts
Showing posts with label searching. Show all posts

Friday, March 23, 2012

Is it possible to do?

I am searching through forums but cannot find the answer.

I have reports on the Intranet.I do not need to restrict it.Everyone should be able to see everything.The problem is that if I assign anonymous access to the reporting server, I cannot manage it.Whatever I do, it would give me an error message saying that account IUSR_SERVER has not rights to do anything.

I cannot use form authentication because I send parameters using url.

Any solution that I could use?

Can I create a user that has restricted access to reporting and use authentication using url?

Any other ideas?

Thank you.

Igor L. Kravchenko.

You need to give IUSR_SERVER Report Server permissions, but know that once you allow Anonymous Access, EVERYONE is seen as IUSR_SERVER, and will get the corresponding Report Server permissions.|||

Thank you for your reply.

I understand that everyone will be able to see all reports but I do not care.

I gave IUSR_SERVER permissions on the server and it works. The problem is that, in this case, it does not allow me to manage it.

What to do, so I could manage my reports?

Thank you.

Igor Kravchenko.

|||If you give IUSR_SERVER the Content Manager role on Home and the System Administrator role at the system level, everyone will be able to manage the Report Server.|||

I understand it.

Is there any way that I can login as someone who can do it when eveyone else could not do it?

Thank you.

Igor Kravchenko.

Friday, March 9, 2012

Is it neccesary to restart sql server engine after modifying a noise word list?

Hello all,

We are using sql server 2005 for full text searching.

I removed some of the words in the noise word file (noiseENU.txt) and rebuilt the catalog. However i find that the changes made to the noise file do not reflect immediately. I had to restart sql server engine before my queries returned results according to the updated noise list. Is there a workaround for this ( wherein there isnt the neccesity of restarting sql server engine....this is becoming a problem on live environments as i cannot restart the server when needed)?

Thanks in advance,

Harish

In fact you will only have to start the FTS again to reflect the changes. There is no (even no one to me) known way around this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank You.

But i had tried restarting just the FTS service; didn't work out for me until i restarted the sql server engine again