Error when updating database - can't start Console...

Support, Questions and Discussions on MonitorWare Console

Moderator: alorbach

Google Ads


Error when updating database - can't start Console...

Postby tosh » Mon Jan 12, 2004 12:22 pm

Hi

I'm trying to evaluate the Console, and when I first start the console, I get prompted by the login box. Username is admin, and password is blank.

My ODBC connection is using Windows NT Authentication to my SQL Server, and tests are fine.

Press OK on the login box, and a dialog pops up:
"We have identifed you are using an old database schema.... press Yes to upgrade etc."

Press Yes, and get a dialog "Invalid user ID or Password Try again"

Press OK again, and get "An unhandled exception has occurred in a component in your application..." Details are below:

Press OK again, and get a hang - can you help?

--Tosh

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.IOException: The process cannot access the file "C:\Program Files\MonitorWare\Console\DbUpdateDebug.log" because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String str)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at Adiscon.MonitorWare.Console.DatabaseUpdater..ctor(String connectionString, String provider, ProgressBar p)
at Adiscon.MonitorWare.Console.UserLoginForm.cmdEnter_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
MWConsole
Assembly Version: 1.1.1374.17170
Win32 Version: 1.1.1374.17170
CodeBase: file:///C:/Program%20Files/MonitorWare/Console/MWConsole.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
Microsoft.Data.Odbc
Assembly Version: 1.0.3300.0
Win32 Version: 1.0.4030.0
CodeBase: file:///C:/Program%20Files/MonitorWare/Console/Microsoft.Data.Odbc.DLL
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby tosh » Mon Jan 12, 2004 12:24 pm

and here is the contents of DBUpdateDebug.log (and yes, it's truncated)


Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this operation on table 'systemevents'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.executeQuery(String fieldName, String dataType)
***********************************
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this operation on table 'systemevents'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.executeQuery(String fieldName, String dataType)
***********************************
Error running the following command
CREATE TABLE [dbo].[Devices] (
[DeviceID] [int] IDENTITY (1, 1) NOT NULL ,
[SystemID] [int] NULL ,
[DeviceReportedName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DeviceAssignedName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DeviceIPMain] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DeviceType] [int] NULL ,
[ShortDescription] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LongDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Location] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DeviceTZ] [int] NULL ,
[AdminName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AdminOfficePhone] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AdminMobilePhone] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AdminHomePhone] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AdminEMail] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AdminPager] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [int] NULL ,
[AutoCreated] [int] NULL ,
[DateCreated] [datetime] NULL ,
[DateLastSeen] [datetime] NULL ,
[DatePurchased] [datetime] NULL ,
[DateRetired] [datetime] NULL ,
[RecordStatus] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[DeviceToKB] (
[DeviceID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[KBID] [int] NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[EventLogSummaryTable] (
[ID] [int] NULL ,
[MinDate] [datetime] NULL ,
[MaxDate] [datetime] NULL ,
[FromHost] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EventSource] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EventID] [int] NULL ,
[Checksum] [int] NULL ,
[GroupCount] [int] NULL ,
[NTSeverity] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[HelperTZ] (
[TZID] [int] NOT NULL ,
[TZShortNameGen] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TZShortNameDS] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TZNameGen] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TZNameGenDS] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OffsetUTC] [int] NULL ,
[OffsetDS] [int] NULL ,
[DSBeginDate] [datetime] NULL ,
[DSEndDate] [datetime] NULL
) ON [PRIMARY]

INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100001, NULL, NULL, 'Eniwetok, Kwajalein', NULL, -720, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100002, NULL, NULL, 'Midway Island, Samoa', NULL, -660, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100003, NULL, NULL, 'Hawaii', NULL, -600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100004, NULL, NULL, 'Alaska', NULL, -540, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100005, NULL, NULL, 'Pacific Time (US & Canada);Tijuana', NULL, -480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100006, NULL, NULL, 'Arizona', NULL, -420, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100007, NULL, NULL, 'Mountain Time (US and Canada)', NULL, -420, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100008, NULL, NULL, 'Central America', NULL, -360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100009, NULL, NULL, 'Central Time (US and Canada)', NULL, -360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100010, NULL, NULL, 'Mexico city', NULL, -360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100011, NULL, NULL, 'Saskatchewan', NULL, -360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100012, NULL, NULL, 'Bogota, lima, Quito', NULL, -300, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100013, NULL, NULL, 'Eastern Time (US and Canada)', NULL, -300, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100014, NULL, NULL, 'Indiana East', NULL, -300, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100015, NULL, NULL, 'Atlantic Time (Canada)', NULL, -240, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100016, NULL, NULL, 'Caracaz, La Paz', NULL, -240, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100017, NULL, NULL, 'Santiago', NULL, -240, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100018, NULL, NULL, 'Newfoundland', NULL, -210, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100019, NULL, NULL, 'Brasilia', NULL, -180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100020, NULL, NULL, 'Buenos Aires, Georgetown', NULL, -180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100021, NULL, NULL, 'Greenland', NULL, -180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100022, NULL, NULL, 'Mid-Atlantic', NULL, -120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100023, 's', '', 'Azores', '', -60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100024, NULL, NULL, 'Cape Verde Is.', NULL, -60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100025, NULL, NULL, 'Casablanca, Monrovia', NULL, 0, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100026, NULL, NULL, 'Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London', NULL, 0, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100027, NULL, NULL, 'Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna', NULL, 60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100028, NULL, NULL, 'Belgrade, Bratislava, Budapest, Ljubljana, Prague', NULL, 60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100029, NULL, NULL, 'Brussels, Copenhagen, Madrid, Paris', NULL, 60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100030, NULL, NULL, 'Sarajevo, Skopje, Sofija, Vilnius, Warsaw, Zagreb', NULL, 60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100031, NULL, NULL, 'West Central Africa', NULL, 60, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100032, NULL, NULL, 'Athens, Istanbul, Minsk', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100033, NULL, NULL, 'Bucharest', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100034, NULL, NULL, 'Cairo', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100035, NULL, NULL, 'Harare, Pretoria', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100036, NULL, NULL, 'Helsinki, Riga, Tallinn', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100037, NULL, NULL, 'Jerusalum', NULL, 120, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100038, NULL, NULL, 'Baghdad', NULL, 180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100039, NULL, NULL, 'Kuwait, Riyahd', NULL, 180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100040, NULL, NULL, 'Moscow, St.Petersburg, Volgograd', NULL, 180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100041, NULL, NULL, 'Nairobi', NULL, 180, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100042, NULL, NULL, 'Tehran', NULL, 210, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100043, NULL, NULL, 'Abu Dhabi, Mascat', NULL, 240, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100044, NULL, NULL, 'Baku, Tbilisi, Verevan', NULL, 240, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100045, NULL, NULL, 'kabul', NULL, 270, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100046, NULL, NULL, 'Ekaterinburg', NULL, 300, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100047, NULL, NULL, 'Islamabad, Karachi, Tashkent', NULL, 300, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100048, NULL, NULL, 'Calcutta, Chennai, New Dehli, Mumbai', NULL, 330, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100049, NULL, NULL, 'Kathmandu', NULL, 345, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100050, NULL, NULL, 'Almatay, Novosibirsk', NULL, 360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100051, NULL, NULL, 'Astana, Dhaka', NULL, 360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100052, NULL, NULL, 'Sri Jayawardenepura', NULL, 360, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100053, NULL, NULL, 'Rangoon', NULL, 390, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100054, NULL, NULL, 'Bankok, Honoi, Jakarta', NULL, 420, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100055, NULL, NULL, 'Krasnoyarsk', NULL, 420, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100056, NULL, NULL, 'Beijing, Chongqing, Honk Kong, Urumqi', NULL, 480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100057, NULL, NULL, 'Irkutsk, Ulaan Bataar', NULL, 480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100058, NULL, NULL, 'Kuala Lumpur, Singapore', NULL, 480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100059, NULL, NULL, 'Perth', NULL, 480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100060, NULL, NULL, 'Taipei', NULL, 480, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100061, NULL, NULL, 'Osaka, Sapporo, Tokyo', NULL, 540, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100062, NULL, NULL, 'Seoul', NULL, 540, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100063, NULL, NULL, 'Yakutsk', NULL, 540, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100064, NULL, NULL, 'Adelaide', NULL, 570, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100065, NULL, NULL, 'Darwin', NULL, 570, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100066, NULL, NULL, 'Brisbane', NULL, 600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100067, NULL, NULL, 'Canberra, Sydney, Melbourne', NULL, 600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100068, NULL, NULL, 'Guam, Port Moresby', NULL, 600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100069, '', '', 'Hobart', '', 600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100070, NULL, NULL, 'Vladivostok', NULL, 600, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100071, NULL, NULL, 'Magadan, Solomon Is., New Caledonia', NULL, 660, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100072, NULL, NULL, 'Aukland, Wellington', NULL, 720, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100073, NULL, NULL, 'Fiji, Kamchatka, Marshall Is.', NULL, 720, 0, NULL, NULL);
INSERT INTO HelperTZ (TZID, TZShortNameGen, TZShortNameDS, TZNameGen, TZNameGenDS, OffsetUTC, OffsetDS, DSBeginDate, DSEndDate) VALUES (100074, NULL, NULL, 'Nuku''alofa', NULL, 780, 0, NULL, NULL);
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[InfoUnits] (
[ID] [int] NULL ,
[Description] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

INSERT INTO InfoUnits (ID, Description) VALUES (1, 'Syslog Reported Event');
INSERT INTO InfoUnits (ID, Description) VALUES (3, 'Windows Event Report');
INSERT INTO InfoUnits (ID, Description) VALUES (5, 'File Monitor');
INSERT INTO InfoUnits (ID, Description) VALUES (10, 'Windows Service Monitor');
INSERT INTO InfoUnits (ID, Description) VALUES (2, 'Heart Beat');
INSERT INTO InfoUnits (ID, Description) VALUES (8, 'Ping Probe');
INSERT INTO InfoUnits (ID, Description) VALUES (9, 'Port Probe');
INSERT INTO InfoUnits (ID, Description) VALUES (11, 'Disk Space Monitor');
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[IUTs] (
[IUTid] [int] NOT NULL ,
[ShortDescription] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level1Value] [int] NULL ,
[Level2Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level3Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level4Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level5Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level6Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level7Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Level8Value] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RecordSource] [int] NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[JMSettings] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PropValue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[KBCategories] (
[KBCatID] [int] IDENTITY (1, 1) NOT NULL ,
[Descr] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

INSERT INTO KBCategories (Descr) VALUES ('General');
INSERT INTO KBCategories (Descr) VALUES ('Change Log');
INSERT INTO KBCategories (Descr) VALUES ('Trouble Ticket');
INSERT INTO KBCategories (Descr) VALUES ('External Knowledge Base');
INSERT INTO KBCategories (Descr) VALUES ('New Trouble Ticket');
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[KBEntries] (
[KBID] [int] NOT NULL ,
[IUTid] [int] NULL ,
[Title] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[KBText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Category] [int] NULL ,
[CreatedBy] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SuppliedBy] [int] NULL ,
[CreatedAt] [datetime] NULL ,
[LastUpdate] [datetime] NULL ,
[LastUpdator] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[KBLinks] (
[KBID] [int] NOT NULL ,
[URL] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ShortDescription] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[SavedReports] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[RTID] [int] NULL ,
[XML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[SavedTemplates] (
[RTID] [int] IDENTITY (1, 1) NOT NULL ,
[XML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[SystemEventsProperties] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SystemEventID] [int] NULL ,
[ParamName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ParamValue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[Systems] (
[SystemID] [int] NOT NULL ,
[ShortDescription] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LongDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[UserPrefs] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserLogin] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PropValue] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[Users] (
[UserID] [int] IDENTITY (1, 1) NOT NULL ,
[UserIDText] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DisplayName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LastLogon] [datetime] NULL ,
[UserType] [int] NULL ,
[HomeTZ] [int] NULL ,
[PrefCulture] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


SET IDENTITY_INSERT [dbo].[Users] ON

INSERT INTO Users (UserID, UserIDText, Password, DisplayName, LastLogon, UserType, HomeTZ, PrefCulture) VALUES (124, 'admin', ' ', 'MWAdministrator', 0, 1, 100026, 'en');

SET IDENTITY_INSERT [dbo].[Users] OFF
It gave the following Exception
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied in database 'SysLog'.
at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Adiscon.MonitorWare.Console.DatabaseUpdater.createAndFillTables(String sql, String fileName)
****************************
Error running the following command
CREATE TABLE [dbo].[WebSearch] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Url] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Description] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[WebSearch] ON

INSERT INTO WebSearch (Id, Url, Title, Description) VALUES (3, 'http://www.google.com/search?q=Eventsource+$EventSource', 'Google search (EventSource)', 'search criteria is EventSource');
INSERT INTO WebSearch (Id, Url, Title, Description) VALUES (4, 'http://www.google.com/search?q=EventID+$EventID', 'Google search (EventId)', 'search criteria is EventId');
INSERT INTO WebSearch (Id, Url, Title, Description) VALUES (27, 'http://www.google.com/search?q=$EventLogType', 'Google search (SysLogTag)', 'search criteria is SysLogTag');
INSERT INTO WebSearch (Id, Url, Title, Description) VALUES (35, 'http://www.google.com/search?q=$Message', 'Google search (Message)', 'search criteria is message');
INSERT INTO WebSearch (Id, Url, Title, Description) VALUES (36, 'http://www.google.com/search?q=EventID+$EventID+$EventSource', 'Google search (EventID + EventSource)', 'search criteria is EventSource');

SET IDENTITY_INSERT [dbo
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby tosh » Mon Jan 12, 2004 12:26 pm

If you have the SQL scripts, I can run them manually through Query Analyzer...

--Tosh
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby alorbach » Mon Jan 12, 2004 12:27 pm

CREATE TABLE permission denied in database 'SysLog'.


Check Permission settings to the database (from the ODBC DSN User)
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Postby tosh » Mon Jan 12, 2004 12:32 pm

Hi

I've thought of that - I'm listed as a db_owner on the database (SQL Enterprise Manager, expand the db and users and have added my NT account as db_owner) but get the same results.

I'm going to try and run the updater program on the database server itself, logged in as domain admin, and see how far I get.

--Tosh
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby tosh » Mon Jan 12, 2004 12:39 pm

Hi

I can't run the updater on the SQL server, as it doesn't have .net 1.1 installed (and I can't reboot it during the day)

When I try and run the updater on my machine I get a dialog:

"Application has generated an exception that could not be handled.
Process id=0x820 blah blah blah
OK to terminate the application"

Can I use the .txt files in the SQL directory in Query Analyser to update the DB manually?

--Tosh
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Postby alorbach » Mon Jan 12, 2004 12:41 pm

Yes of course you can use the sql files manually and execute them via Query Analyzer.
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Postby tosh » Mon Jan 12, 2004 1:04 pm

Hi

I managed to run the scripts manually - but I had to drop the tables before I could run the scripts - but it's working now.

Thanks

--Tosh
tosh
Frequent Poster
 
Posts: 83
Joined: Fri Feb 28, 2003 3:14 pm
Location: London, UK

Google Ads



Return to MonitorWare Console

Who is online

Users browsing this forum: No registered users and 0 guests

cron