Snort, MSSQL and Win2k Question

["Nick Patellis" <NPatellis () TheFund com>]

Hi,

 

I am running snort 1.8.7 on a win2K SP2 server along with MSSQL 2000 SP2
and am getting some errors which appear to be related to incorrect table
creation.  I used the create_mssql script to create the tables.  Here is
a sample of errors:

 

        The text, ntext, and image data types cannot be compared or
sorted, exce

pt when using IS NULL or LIKE operator. 

Server 'ELF1', Line 1

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag =
'4474'

database: DB-Library error:

        General SQL Server error: Check messages from the SQL Server.

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag =
'4474'

database: SQL Server message 306, state 1, severity 16:

        The text, ntext, and image data types cannot be compared or
sorted, exce

pt when using IS NULL or LIKE operator. 

Server 'ELF1', Line 1

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag =
'4474'

database: DB-Library error:

        General SQL Server error: Check messages from the SQL Server.

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag =
'4474'

database: Unable to insert the alert reference into the DB

database: SQL Server message 306, state 1, severity 16:

        The text, ntext, and image data types cannot be compared or
sorted, exce

pt when using IS NULL or LIKE operator.

Server 'ELF1', Line 1

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag =
'CAN-2002-007

9'

database: DB-Library error:

        General SQL Server error: Check messages from the SQL Server.

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag =
'CAN-2002-007

9'

database: SQL Server message 306, state 1, severity 16:

        The text, ntext, and image data types cannot be compared or
sorted, exce

pt when using IS NULL or LIKE operator.

Server 'ELF1', Line 1

database:  The above error was caused by the following statement:

SELECT ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag =
'CAN-2002-007

9'

 

Any ideas?  

 

Thanks

 

Nick

 

=======================================

Nick Patellis

Computer Security Analyst

Attorneys' Title Insurance Fund

407.240.3863