MS SQL

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

MS SQL

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Web & Mail Security] >> GFI WebMonitor >> MS SQL

Page: [1]

Message

<< Older Topic Newer Topic >>

MS SQL - 1.Oct.2009 3:04:16 AM

Red Spider

Posts: 3
Joined: 1.Oct.2009
Status: offline

Dear All,
I have an ISA server 2006 on Win 2k3 R2 I installed GFI Webmonitor 4 and MS Sql server 2000 when i enable the reporting on the GFI Webmonitor I always get the same respond:

Status: An error occured while trying to write in SQL Server database. Rollback.

GFI WebMonitor automatically transfers the data logged during the day to the Microsoft SQL Server backend database you configured above. This is done daily at midnight.

If you want to transfer all the past data right now without waiting for midnight, you can click the Update Reporting Data Now button below.

This will save your current settings and transfer all the data logged so far into the Microsoft SQL Server backend database.

Post #: 1

RE: MS SQL - 1.Oct.2009 9:25:34 AM

DrewE

Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline

Are there any nightly backups that occur on the server?

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to Red Spider)

Post #: 2

RE: MS SQL - 1.Nov.2009 1:38:49 PM

Red Spider

Posts: 3
Joined: 1.Oct.2009
Status: offline

yes its @ 12:00 everynight

(in reply to DrewE)

Post #: 3

RE: MS SQL - 2.Nov.2009 8:19:45 AM

DrewE

Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline

Try restarting the GFI WebMonitor service after the backup runs and see if this helps.

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to Red Spider)

Post #: 4

RE: MS SQL - 11.Nov.2009 3:00:01 AM

Red Spider

Posts: 3
Joined: 1.Oct.2009
Status: offline

I tried it and still its fails is there a step by step way to configure it and shall i use windows auth or sql authantication (SA)

(in reply to DrewE)

Post #: 5

RE: MS SQL - 11.Nov.2009 10:14:09 AM

DrewE

Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline

SQL Authentication is preferred. If it is still failing, will you please open a support request online at http://support.gfi.com/Support/support.aspx?lcode=en so we can best assist you?

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to Red Spider)

Post #: 6