I am getting an error connecting my label to a database via OLEDB

Question

I have some labels set up in LabelDirect. They have been working up until now but the database connection details have changed and now I cannot reconnect the label to the database. The Error I get is

Login Failed for user 'bcslabels'

However I know it is correct and I have even tried with the sa user and I get the same error

Connects Fine

Then I get an error

Any Suggestions as to what is going wrong?

Answer 1

Solved.

I had not ticked the all important

Allow Saving password

checkbox

Tick that box and all is right.