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