It may be a classic but yes I am newbie and I need your help with stg.
Server 2003 and SQL Server 2005 runs on the same server. A process (.exe) has to be running all the time. However, sometimes I find out that this specific .exe has stopped and therefore no data was pulled from any of our branches (around 50). My phone keeps ringing, users say they can't see their records etc.
When I look at Server Application Logs I see attached scene. I am not sure why this happens. The user PDKS is a legitimate SQL user and I don't know why it sometimes fails to log on and most of the time runs without problems. Up until a month ago, this server was reachable from the Internet for SQL and RDP protocols (I know not ideal). I saw many different IPs that seemed to tried access by using 'brute force'. Currently the server is unreachable from the internet.
Any ideas why we might be getting these errors? We do take backups from this server but not always at the time this errors are thrown. For example we don't take backups in the morning. What do you think I should do?