MSSQL Homogeneous System Copy : SAPINST cannot connect to default database

[Former Member]

Hello.

We want to perform a homogeneous system copy, following Note 151603.

We have attached the source DB (RP1) to the destination DB (RD4) following the above mentioned Note.

Now, logged to the server as DOMAIN\rd4adm , we want to execute the SAPINST, as indicated in the Note 683447, but when giving the password for user rd4adm we get a pop up

Cannot connect to R3SVIL\RD4 [SQL Server]Cannot open user default database. Login failed.

R3SVIL is the server. Login is done with windows authentication (connected as domain\rd4adm)

We cannot find a Note descibing this issue and how to fix it, must be something with user : does anybody have suggestion or solution?

Thanks a lot,

Dino

[Former Member · Accepted solution]

Hi,

did you apply SAP note 551915 - R/3 won't start after database restore or database copy

also check Note 806925 - SQL Error 4064: Cannot open user default database

regards,

kaushal

[Former Member · Accepted solution]

Hello, thanks for your reply.

The Note 551915 shoudl be implemented after the SAPINST, which cannot start due to the mentioned error.

The 806925 has already been checked but without result...

Regards,

Dino

[Former Member · Accepted solution]

Hi,

it's not necessary you can apply note 551915 before running sap SAPINST,

please provide complete sapinst error log

regards,

kaushal

[Former Member · Accepted solution]

Hello.

We found the error. The database was attached when the connection to SQL Management Studio was done without specification of the database, only the server was specified (server instead of server\SID : so it was not really attached.....)

Thanks a lot for your replies