SQL 7 sa account problems PLEASE HELP!! 1

[PaddyT]

Setup replication, and all worked fine. Then after a day or so, I have a problem sending data from the SQL server that is connecting to the Publishing database.

Following message occurs:

Error message is (Microsoft)(ODBC SQL Server Driver)(SQL Server)Login failer for user 'sa'. Reason: Not associated with a trusted SQL Server connection

Not sure why this problem occured after several days of use, when all was fine.
Thanks

 

[morpheos]

Well once I had similar problem. Are you sure that your typing rightly the password. And if that is not the problem check in your SQL Enterprise Manager / Security /Logins maybe someone touched this and Disabled or limited your rights to modify or see the DataBase

 

[TomSark]

You will also need to ensure that all of the replication agent accounts that are involved have the same security credentials of all machines affected.

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[PaddyT]

Just a thought, someone mentioned that it could possibly be a licence problem. We currently have 5 licences, but I know SQL uses them somewhat freely...Could this affect it?