Originally posted by harshal_in
I think you need to chek the connection string with respect to the logins on the server.And the corresponding frontend too.
When I entered EM..right click on the SQL Server | properties
I have noticed that under Security Tab 'This Account' is marked and the Domain and name are correct but the Password is not the same password I enter to my computer (it is longer).
Trying to change the password won't let me althogh I am registered as an administrator.
In addition to that the Authentication was Windows only, changing it to Sql server and Windows with sa and my computer password raised me and error: Login failed for user 'sa'.
Can that mess be cleared?