pdf ifilter issue with sp_fulltext_service

Several internet posts I've read describe how to get SQL Server to recognize
a 3rd party ifilter .dll. This involves the use of sp_fulltext_service with
the following syntax:
Exec sp_fulltext_service 'verify_signature', 0
Exec sp_fulltext_service 'load_os_resources', 1
I've used these commands and have been able to get SQL Server and SharePoint
to build an index for pdf documents. Many of these instructions tell you to
reverse the settings after you're finished in order to better secure the
server. Those commands are:
-- Restore the Full-text service settings to their default
Exec sp_fulltext_service 'verify_signature', 1
Exec sp_fulltext_service 'load_os_resources', 0
The problem is, that once you run the above commands and reboot, you no
longer index any new pdf files added to the server. Is this the expected
behavior? If not, what am I doing wrong? I don't want to leave the security
hole open by not running these commands but then you don't index new files.
This is a duplicate post I created because I did not see my original after a
day of waiting. Please disregard this post and use the other. Thanks.
"Dlorbecki" wrote:

> Several internet posts I've read describe how to get SQL Server to recognize
> a 3rd party ifilter .dll. This involves the use of sp_fulltext_service with
> the following syntax:
> Exec sp_fulltext_service 'verify_signature', 0
> Exec sp_fulltext_service 'load_os_resources', 1
> I've used these commands and have been able to get SQL Server and SharePoint
> to build an index for pdf documents. Many of these instructions tell you to
> reverse the settings after you're finished in order to better secure the
> server. Those commands are:
> -- Restore the Full-text service settings to their default
> Exec sp_fulltext_service 'verify_signature', 1
> Exec sp_fulltext_service 'load_os_resources', 0
> The problem is, that once you run the above commands and reboot, you no
> longer index any new pdf files added to the server. Is this the expected
> behavior? If not, what am I doing wrong? I don't want to leave the security
> hole open by not running these commands but then you don't index new files.
>

PDF Export Failing after SP1

Am also having a problem exporting to PDF since installing SP1. Error is
"Cannot download format=PDF from <server>"
"Internet Explorer was not able to open this Internet Site. The requested
site is either unavailable or cannot be found. Please try again later".
Micktry to export same report to PDF in visual studio designer
you will recive different error
this error is explained in two of todays posts
HTH,
Kamil
U¿ytkownik "Mick Horne" <mick.horne@.conchango.com> napisa³ w wiadomo¶ci
news:%23bePBQeXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Am also having a problem exporting to PDF since installing SP1. Error is
> "Cannot download format=PDF from <server>"
> "Internet Explorer was not able to open this Internet Site. The requested
> site is either unavailable or cannot be found. Please try again later".
> Mick
>
>|||> try to export same report to PDF in visual studio designer
> you will recive different error
> this error is explained in two of todays posts
As posted before I've got the same problem. And yes, you are right, in the
designer I receive a different error. Unfortunately I can not find the posts
where a solution for this is stated. Can you please explain to me how to fix
it?
Thanks.
Christian|||Workaround solution with following post:
"SP1 - Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown" by Rahul
U¿ytkownik "Christian Anders" <anders.christian@.firemail.de> napisa³ w
wiadomo¶ci news:ewNfcgeXEHA.2388@.TK2MSFTNGP11.phx.gbl...
> > try to export same report to PDF in visual studio designer
> > you will recive different error
> > this error is explained in two of todays posts
> As posted before I've got the same problem. And yes, you are right, in the
> designer I receive a different error. Unfortunately I can not find the
posts
> where a solution for this is stated. Can you please explain to me how to
fix
> it?
> Thanks.
> Christian
>sql

PATCH for Article 817326

I am desperately looking for the patch across the internet
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon

Password change

Hi,
I have a pull merge replication configured on two of my servers. These
servers replicate over the internet and use the sa password to connect to the
publisher. I know it is not a good practice to use the sa login for
replication purposes. But it has been configured this way. It would be too
much work to re-configure it. I am not sure about this.
But the question that I want to ask is, if i change my subscribers sa
password, replication stops working.
Can someone tell me what the problem can be?
Thank you in advance.
Regards,
Karthik
try to change also the sqlagent pasword.
zrod
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
> the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik
|||Your pull subscriber authenticates with the agent locally. You can specify
the account to use as well as its password via agent properties.
I think you want to look at [Distributor/Publisher/Subscriber]SecurityMode
and the logon and password parameters.
You should be able to use the accounts of your choice here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik

Pass-Through Authentication won't work when replicating via the ActiveX Library?

Hi all,
My sql2000 to sql2000 merge replication via internet is run via an
application on the subscriber using activex library.
I read about setting up pass-through authentication so that the user
accounts don't need to be on the same domain. So, I set up Sql Server
and Sql Agent to run on a user account set up identically on each
machine. But, it doesn't seem like the Sql Agent is even involved in
the communication on the subscriber.
Authentication at the publisher fails because it is trying to
authenticate - not the account that sql server and sql agent services
are running under - but the current windows account running on the
subscriber.
ie:
- sql server and sql agent running under "serviceAccount"
- windows user on subscriber machine logged in as "Joe"
- error at publisher = cannot authenticate Joe.
Now, if I create a Joe user on the publisher, with the same password as
on the subscriber, everything works. But this is an impossible setup to
work with because of course there will be many different unknown users.
Please, can anyone help with this? I can't find this problem
anywhere...
JJ
Its probably using the security context of the account you are logged in
under. If you were to run this program/script as a job spawned by SQL Server
agent it would work. Another option would be to use the run as command (have
a look at runas from the command prompt).
I think your best bet would be to use sql authentication though.
This could also be an rights issue when you connect to the snapshot share -
exactly what error message are you getting?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1121742075.969113.19600@.z14g2000cwz.googlegro ups.com...
> Hi all,
> My sql2000 to sql2000 merge replication via internet is run via an
> application on the subscriber using activex library.
> I read about setting up pass-through authentication so that the user
> accounts don't need to be on the same domain. So, I set up Sql Server
> and Sql Agent to run on a user account set up identically on each
> machine. But, it doesn't seem like the Sql Agent is even involved in
> the communication on the subscriber.
> Authentication at the publisher fails because it is trying to
> authenticate - not the account that sql server and sql agent services
> are running under - but the current windows account running on the
> subscriber.
> ie:
> - sql server and sql agent running under "serviceAccount"
> - windows user on subscriber machine logged in as "Joe"
> - error at publisher = cannot authenticate Joe.
> Now, if I create a Joe user on the publisher, with the same password as
> on the subscriber, everything works. But this is an impossible setup to
> work with because of course there will be many different unknown users.
>
> Please, can anyone help with this? I can't find this problem
> anywhere...
> JJ
>
|||Yes I'm pretty sure that it's a rights issue - i was seeing error 1326
(unknown user or bad password). Like you said, it's likely because it's
using the security context of the account that I am logged in under on
the subscriber. In fact, I know that's the issue, b/c if I change the
username and password of my windows account that i am logged in under
on the subscriber to match the publisher, everything works like a
charm. But this is an impossible setup for me.
The issue here is that this is supposed to be an installable
application (unknown users)using MSDE on the subscriber, and the
application is using the ActiveX library - so anything outside of the
control of what can be set up by an installation app won't be feasible.
Re SQL authentication, are you saying that if I change the SQL Server
setup on the subscriber to use SQL authentication instead of windows
authentication, that it might work?
JJ
|||Yes, I am suggesting you do both (SQL authentication on the publisher and
subscriber). You can also use a com component and have this component run
under different security credentials than the account the user is logged on
under.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1121776681.002861.67670@.o13g2000cwo.googlegro ups.com...
> Yes I'm pretty sure that it's a rights issue - i was seeing error 1326
> (unknown user or bad password). Like you said, it's likely because it's
> using the security context of the account that I am logged in under on
> the subscriber. In fact, I know that's the issue, b/c if I change the
> username and password of my windows account that i am logged in under
> on the subscriber to match the publisher, everything works like a
> charm. But this is an impossible setup for me.
> The issue here is that this is supposed to be an installable
> application (unknown users)using MSDE on the subscriber, and the
> application is using the ActiveX library - so anything outside of the
> control of what can be set up by an installation app won't be feasible.
>
> Re SQL authentication, are you saying that if I change the SQL Server
> setup on the subscriber to use SQL authentication instead of windows
> authentication, that it might work?
> JJ
>
|||SQL auth on both didn't work - It was still using the credentials of
the windows login on the subscriber.
Solution - I created a "launcher" application that starts the
application under credentials that match the publisher.
Thanks for the help.
|||Well, it worked on my LAN, but not when i tested it from outside the
LAN. Again, permission problems. Do I need to upgrade the server to a
domain controller?
JJ