MSSQL - Cannot Open User Default Database (error 4064)

[Former Member]

Hi gurus, I have sap running on MSSQL. i have tried to de-attached the database. but now i unable to connect. i have done some research about this. I have logged in as Master in the option menu. Then i have logged . but i cant attach back the IDS server. It showing the same error.Can anyone guide me how to solve this error please. I am not very familiar with MSSQL script. Please guide me through. Thank you in advance.

[Former Member]

Note 151603 - Copying an SQL Server database.> resolve the problem. Thanks for all the suggestion. Appreciate it.

[Former Member]

Hi Ram,

Try to check the following microsoft artical.It may not the solution, but you will get an idea.

http://support.microsoft.com/kb/307864

Thanks & Regards,

Nagendra.

[Former Member]

Hi,

Have you checked SAP Note 806925 ?

Cheers...,

Raghu