Unable to connect Cognos Planning 8 to pad_live_common database

[Wilkie]

I have since moved the two database find pad_live and pad_live_common to a new MSSQL database server.  I have been able to connect to the pad_live database through 'Cognos Planning 8.1 - Contributor Administrator' and been able to point the new databases server to the user databases under Applications.

Although when I click on Macro is still has reference of the old database and the following error is shown
"Unable to open connection using connection string of Provider=SQLOLEDB;Data Source=SQL_server;Trusted_Connection=YES and timeout of 15 seconds.~~~~Login failed for user 'domain\user1'.   domain\admin   

Also within 'Cognos Planning 8.1 - Contributor Administrator'  under Job Server Cluster \jobserver\job servers \ congos apps server\Monitored Applications
I'm unable to attach the Pad_live_comman database

I'm unable to trace the connection back within Cognos Planning 8 back in order to change the database server connection name.

Would be grateful for your comments