usual reason for this error is the sql instance is set to only accept windows authenticated logins but you are trying to connect with a sql authenticated ID. check the properties on your sql instance.

If this is your problem will need to change authentication mode to windows and sql authentication, which will require a sql bounce to take effect.

...or connect with a windows id, which is more secure