SQL Server 2005 connection problems
Posted on 2010-08-24
I am having problems connecting to SQL server time to time.
In event log I keep getting msg like this:
Login failed for user 'sa'. [CLIENT: 192.168.x.x]
The user name is different in other msgs.
When I check the settings all is ok...all ports are enabled, all agents started...
Sometimes the problem goes away in few seconds. Sometimes the only thing to make it work is to reboot the WIN server and then its ok again.
I also checked log file for SQL server and I see errors like:
 ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
 Logon to server 'SERVER' failed (SaveAllSchedules)
I am using Windows Small Business Server 2003 Premium Edition with SQL Server 2005 standard.
Thanks for suggestions!