Question about MSSQL

["Don" <Don () WeberOnTheWeb com>]

I'm getting just tons of errors
is anyone suing this option yet with win2k server and mssql, snort build
1.8.6, i used the mssql-create script that came with the build, one problem
i am having is with schema, apparently when snort goes to look at the schema
version it gets a 0 as return value, which i blv is an error in how it asks,
using query ana, i must type
SELECT vseq from [schema];
to get results
typing simply
SELECT vseq from schema;
results in syntax error, i'm thinking this is why snort doesnt get the
correct results when attempting to connect to the db
here's some of the text from the screen, any ideas what is going on?
actually first i had to allow nulls on column 'last_cid' to even get this
far. here's the error before i made that change, it had quite a few more
errors after that one, so i was taking them one at a time, allowing nulls in
this column seems to have fixed the rest of those errors tho.

database: SQL Server message 515, state 2, severity 16:
        Cannot insert the value NULL into column 'last_cid', table
'Snort.snortu
sr.sensor'; column does not allow nulls. INSERT fails.

now i get this error, which i think if the code put the word schema in [] it
would probably work fine, or could there be some configuration error on my
system that wont let it see just the word schema as a table somehow, i
usually dont have to put tables in brackets.

database:     sensor id = 1
database: SQL Server message 156, state 1, severity 15:
        Incorrect syntax near the keyword 'schema'.
Server 'WEBER', Line 1
database:  The above error was caused by the following statement:
SELECT vseq FROM schema
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 vseq FROM schema
database: schema version = 0
database: The underlying database seems to be running an older version of
          the DB schema (current version=0, required minimum version= 106).


thanks in advance

Don



-------------------------------------------------------
This sf.net email is sponsored by: See the NEW Palm 
Tungsten T handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users