Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 2618 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sophos Reporting Interface

Andre

Hi,

We just upgraded our Sophos from SEC 4.5 to SEC 5.1.0.1839 and I had read that this version includes the Reporting Interface.

I'm trying to follow the guide "Sophos reporting Interface - Creating Reports using Crystal Reports 2008" but I am having problems creating the connection.

I'm using Crystal Reports 2010 from my workstation (running as user) and selected the OLE DB (ADO) "Microsoft OLE DB Provider for SQL Server". For the Connection Information in the server field I use "%servername\SOPHOS" (SOPHOS being the name of the Sophos DB isntance running on our AV server where Sophos is installed). Does the Servername have to be the FQDN? I have tried it both ways and couldn't get it to connect.

In the Database field I type the name of the Database.

I select the Integrated Security and it also won't connect.

The error when pressing finish is:

The domain account I'm using is part of the local group Sophos DB Admins on the sophos server.

I looked for the services on the machine, but I don't find any that have the words "Sophos reporting" or "Reporting Log Writer".

Do these need to be installed separately? I had understood they would come with the upgrade.

Would anyone have any hints on how I can set up the connection?

Many thanks

:34249


This thread was automatically locked due to age.
Parents
  • 0

    Hi Christian,

    sorry about the link, I  copied two extra characters.

    That document is the one I had found and printed. For accessing the Sophos DB via Crystal Reports I don't seem to require the Log Writer, so I'm still trying to figure out the connection I need to set up.

    Many thanks

    :34265
Reply
  • 0

    Hi Christian,

    sorry about the link, I  copied two extra characters.

    That document is the one I had found and printed. For accessing the Sophos DB via Crystal Reports I don't seem to require the Log Writer, so I'm still trying to figure out the connection I need to set up.

    Many thanks

    :34265
Children
No Data