Cannot open user default database login failed SQL2005 error 4064 sap 4.7

[Former Member]

Hi gurus

i am in the process of creating a copy of another system.

So installed a full system then copied that data files from that system.I dettached the database but now i cant login as the database was the default.

I can log in as master but how do i attached the copied datafiles from another system as iam still facing login problems now

System sap 4.7 enterprise database sql20005

Any ideas welcome

[Former Member]

Hi,

check following sap note

151603 :Copying an SQL Server database (homogeneous system copy)

551915 - R/3 won't start after database restore or database copy

regards,

kaushal

[Former Member]

Thanks problem fixed

[Former Member]

solved