Cannot open database requested by the login. The login failed. Login failed for user “sa”.

Error:

Cannot open database <FileName> requested by the login. The login failed. Login failed for user “sa”.

Snapshot:

Causes:

1. Entered “sa” may be wrong.

2. Mixed authentication mode is not enabled.

Workaround:

1. Enter correct “sa” password and try connecting.

2. Enable mixed authentication mode. (click below link)

http://techsupport.relyonsoft.in/?p=2282