Hi there!

Anybody out there who can tell me, why several times a day we can't login to
our server  with SQL Authentication but with WIN Authentication we can log in.
In the SQL Log File Viewer appears errors like "Error: 18456, Severity: 14,
State: 10."

any ideas?

Thanks

Hi

The below KB articles may help to resolve your issue.

1. http://support.microsoft.com/kb/925744
2. http://support.microsoft.com/kb/937745

Regards
Balaji

Query with dinamic columns
Backup and Restore Problem
JOIN based on date
What can cause SQL 2000 to stop responding for a while
replicate image of DB at a remote site
Is it possible to associate sql login with network address?
Using Alias with Failover
Error during login to SQL Server 2005
help on tempdb log full
Database file and Transaction log file