Login failed for user 'sa'error happens when 5 people try to access our system. Any help will be very much appreciated. Thanks.
1) Don't use sa. Create a limited access account for your apps.<BR>2) Close your connections.<BR>3) More info?
maybe sa password has changed. Can u log in to QA with the same sa/<password> you users are using?<BR><BR>and yeah, dont use sa.
Go to SQL server Properties<BR>Connections <--- reset here<BR><BR>BTW you should not Use 'sa' to connect to a DB