[SOLVED] SQL Server does not exist or access denied

[zip]

My otrs is working fine since a few months now. But sometime i see this error in the log:

Code: Select all

[Tue Aug 19 14:15:01 2014][Notice][main::_Status] Scheduler Service status request! PID 23600
[Tue Aug 19 14:15:01 2014][Notice][main::_Status] Scheduler Daemon status request! PID 23600
[Tue Aug 19 14:15:01 2014][Notice][main::_Status] Scheduler Daemon status request! PID 23600
[Tue Aug 19 14:20:24 2014][Error][main::_WatchDog][816] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:24 2014][Notice][main::_WatchDog] Database is not ready!
[Tue Aug 19 14:20:24 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:24 2014][Error][main::_WatchDog][816] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:24 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:24 2014][Notice][main::_WatchDog] Database is not ready!
[Tue Aug 19 14:20:24 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:45 2014][Error][main::_WatchDog][751] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:45 2014][Notice][main::_WatchDog] Database is not ready!
[Tue Aug 19 14:20:45 2014][Error][main::_WatchDog][751] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000)
[Tue Aug 19 14:20:45 2014][Notice][main::_WatchDog] Database is not ready!
[Tue Aug 19 14:25:01 2014][Notice][main::_Status] Scheduler Service status request! PID 23600
[Tue Aug 19 14:25:01 2014][Notice][main::_Status] Scheduler Service status request! PID 23600
[Tue Aug 19 14:25:01 2014][Notice][main::_Status] Scheduler Daemon status request! PID 23600
[Tue Aug 19 14:25:01 2014][Notice][main::_Status] Scheduler Daemon status request! PID 23600

Can i ignore it?

Its because of

I strongly advise not to use MS SQL and IIS for OTRS. Windows is not a sustainable plattform for PERL based webbased software. Also OTRS is extremly slow on MS SQL as there is no PERL database driver!

viewtopic.php?f=62&t=22697 ?

[zip]

Code: Select all

[Wed Aug 20 13:55:01 2014][Notice][main::_Status] Scheduler Service status request! PID 5800
[Wed Aug 20 13:55:01 2014][Notice][main::_Status] Scheduler Daemon status request! PID 5800
[Wed Aug 20 14:00:21 2014][Error][main::_WatchDog][816] [Microsoft][ODBC SQL Server Driver]Login timeout expired (SQL-HYT00)
[Wed Aug 20 14:00:21 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver]Login timeout expired (SQL-HYT00)
[Wed Aug 20 14:00:21 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver]Login timeout expired (SQL-HYT00)
[Wed Aug 20 14:00:21 2014][Notice][main::_WatchDog] Database is not ready!
[Wed Aug 20 14:00:21 2014][Error][Kernel::System::DB::new][223] [Microsoft][ODBC SQL Server Driver]Login timeout expired (SQL-HYT00)
[Wed Aug 20 14:00:21 2014][Notice][main::_Status] Scheduler Daemon status request! PID 5800
[Wed Aug 20 14:05:01 2014][Notice][main::_Status] Scheduler Service status request! PID 5800

[jojo]

check with your windows database guys.

ODBC is not a good way to run business critical applications on. Also MS SQL and OTRS will not run performant because of the need to use ODBC.

It is strongly advised to switch to *nix and mysql/postgres or Oracle instead

[crythias]

This is not an OTRS error.

[zip]

ok thanks for help, i will check it with my system operators.