Audit V7.4 : Unable to see any servers in "Select Audit Trial Server"

Hi all,

I am unable to see any servers under "Select Audit Trial Server" in WinCC Audit Editor V7.4 SP1 to select and create the new Audit Database.

I have assigned the required user groups ("Logon_Administrator" and "SIMATIC HMI AUDIT / CS / VIEWER") to the built in administrator account, transferred the Audit License, etc., as per the Audit V7.4 configuration manual.

I have tried re-installation with its SP1 package also, but no luck. I've not even found any errors during installation, but it is not showing any server to link it up.

Can someone help me out in this?

Thanks in Advance,

Praveen

Hello Praveen_V

unfortunately this is a common problem of wincc audit, suddenly server stops showing in audit configuration. I have solved this sometimes in past using re installation but sometimes even reinstalllation wont help then I had to format my PC.

Just my experience!!

Kbv.

bg2492

Hello Praveen_V,

you could use the Microsoft SQL Server Management Studion,
to check, if you can find SQL-Databases (Audit or other)
on your local PC or other PCs in the network.


Regards

Georg Berghof

 

Hi bg2492,

We are actually implementing the SSRS reports, for which we need to upgrade the SQL Standard to Express edition. But when we upgrade the edition, the Audit trial services are getting stopped and are not turning ON (attached the pictures of Audit Services).

Also the audit trail server/databases are not showing in Audit Editor (attached the pictures of Audit Editor) and not logging any audit data.

Your earliest response regarding this issue is highly appreciated.

Thanks in Advance,

Praveen

Kbv

Hello Praveen_V

unfortunately this is a common problem of wincc audit, suddenly server stops showing in audit configuration. I have solved this sometimes in past using re installation but sometimes even reinstalllation wont help then I had to format my PC.

Just my experience!!

Kbv.

Hi Kbv,

As suggested by you I have requested my client that formatting of the system will resolve and i got resolved once by formatting the PC...

But again I'm facing the same issue. My client is very angry now...

I'm struggling hard to convince them to get the system formatted again...but they are not ready to accept it.... Please help me out in finding a permanent solution for this kind of issues...

Thanks in advance,

Praveen

Hi Praveen,

CCAuditTrailServer is responsible to publish the information about the available SQLServer for Audit.
If the service is not running -> no available server will be shown in the editor.

CCAuditTrailServer has several dependencies: CCAgent, CCEServer,CCEClient and SQLServer (WinCC) has also to be in state run.

I don't know if it runs with SQL Express (this is an downgrade, not an upgrade). But the Setup installs a lot of StoredProcedures in the SQL. So i assume you have to reinstall Audit after changes at SQL side.

Best regards
Bull

Hi, 

I had the same problem seeing no servers. I also couldn't manually run the CCAuditTrialServer. It gave me the 0x80004005 error.

In the Windows 'Event Viewer' >  'Windows Logs' > 'Application' I saw Information about the CCAuditTrialServer followed by a couple of MSSQL$WINCC logs telling me this:

'Failed to open the explicitly specified database 'AUDIT_TRAIL_CS'

In the Microsoft SQL Server Management Studio  I saw the 'AUDIT_TRAIL_CS' & 'Audit_Trigger_Data' created in the .\WINCCPLUSMIG2014 server. 

To solve the problem i attached the 2 databases to the .\WINCC server. Right click databases > Attach.. > Add... (File location: database properties > Files > Path column).

I restarted my computer and... great succes. :)