I'm trying to do homogeneous system copy from ms sql 2000 to ms sql 2005. I was generally guided by 799058 note, section "III HOMOGENEOUS SYSTEM COPY TO MS SQL SERVER 2005", but I have a problem with point 9, which refers to launching SAP tools for MS SQL Server. Problem is that after Defining Parameters (2nd step), saptools can't connect to database (ms sql 2005). Steps after launching sapinst.exe:
1. Step 1 (Choose Option). I'm choosing "Database Copy".
2. Step 2 (Define Parameters). I'm filling in properly "Profile Directory", "Windows Domain" and "Password for ' SQL Server does not exist or access denied."
App host, and db host are on different servers. First I thought that there is something wrong with user's credentials but I can connect to db from app host with SQL Management Studio using this user.
Does anybody know why such thing happen? 😊
Edited by: Jaroslaw Przepióra on Jun 24, 2009 2:42 PM