I have an web application which is was developed in ASP.NET v1.1 and database is sql server 2000. In the beginning of this month, my boss decide to update the database system from sql server 2000 to sql server 2005. Well, I made it. I setup a server with MS Windows 2000 Server, SQL Server 2005 Developer Edition, and .NET Framework, of course. After that, I restore my 10GB database into sql server 2005, edit the web.config as:
<add key="ConnectionString" value="user id=sa;data source=CTNKHSER;initial catalog=BILLING;password=s
Well, my web app runs smoothly with 40 users in my company everyday. But when I check the LOG view in the sql server 2005, I realised that it's fulled with the Error 18456 Severity, state 8 (see the attached picture). And I don't know why.
I know the password is correct as it is coming from the config file and not changing. I tried deleting the users and recreating them by hand but still have the same sporadic problem. I know all the state 8 of the 18456 Severity, and case sensitive of sql 2005 password. In fact, if my password is wrong, my web app can not run. It still running, but log error still alert.
As the result, my server automatically restart after 3-4 hours running.
Web and Database are in the same server.
Anybody can help? my business is go down and make me so confuse.
Here is one of error log from my sql server 2005:
Date 5/9/2009 11:16:24 AM
Log SQL Server (Current - 5/9/2009 11:16:00 AM)
Login failed for user 'sa'. [CLIENT: 192.168.58.4]
Please Note that the IP address 192.168.58.4 is my server IP