R3Trans error 0012 on shifting DB to a new host

Hi,

We have a Discovery system with WAS and SQL2005 sitting on the same system. We're trying to move the DB to a new System.

We have been able to connect to our New SQL2005 host and our ABAP interface is working fine, even the portal is working fine. However when we try to test our TMS using the new DB server it gives an error, some notes suggested that we run R3Trans –d first and this is the error message that we get.

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'IWDFVM2160' DBNAME = 'ERP'"

The new DB server is “SAPSQL2005”, “IWDFVM2160” is the OLD DB server, IWDFVM2160 also happens to be the server where WAS is running.

Is there some configuration that needs to be changed? Any advice on how to get the TMS working will be appriciated.

Thanks and Regards,

Aniruddha