Error 1919 during install

LukeCh

Hello,

I have installed eventsentry already on a server (Windows server 2003) and I wish to configure the installation so that I can setup web reports.

I have configured the install within add/remove programs and then selected * Setup ISS and * Setup MSSQL in the install.

I now get a error saying

Error 1919. Error configuring ODBC data source EventSentry MSSQL, ODBC error 9:Invalid DSN. Verify that the file EventSentry MSSQL exists and that you can access this.

When pressing ignore, I get another message saying

Error 27502 Could not connect to MS SQL server. Login failed for user sa (18456).

Anyone know what to do to get the database installed and working?

Many thanks,

Luke

Steve

Hi Luke,

Is this a 64-bit 2k3 system?

If so, it sounds like you are using a 64-bit DSN instead of a 32-bit DSN (since EventSentry is a 32-bit program, it can only access 32-bit DSNs).

Please run 'C:\Windows\SysWOW64\odbcad32.exe' and select the 'System DSN' tab to verify that the 'EventSentry MSSQL' DSN exists (if not, you would have to create it).

If the DSN does exist, please reconfigure it with your 'SA' account/password and verify it can connect to the database by using the 'TEST' button.

LukeCh

Steve,

Thanks for your input on this. The server is actually a 32 bit machine so I do not see the C:\Windows\SysWOW64\odbcad32.exe anywhere on the machine.

Any other suggestions?

Luke

Steve

Hi Luke,

OK, you might need to go into your System DSNs and select 'Reconfigure' for this one. Since you are getting the 27502 error stating that the login failed for the SA user account (was the password recently changed on this account?).

Reconfigure this DSN so it works with the SA user account and hit the "TEST" button after reconfigured to make sure it works correctly.

Howdy, Stranger!

Categories