After runing the DS-Client repair option to recover "DS-Client and delta databases", and restarting the DS-Client to finish the databases recovery, DS-Client service starts and then stops. The following error is reported in the Operating System Event Log: "Cannot open database requested in login 'dsdelta.' Login Fails"
This error message indicates that the database recovery has not yet finished. For large dsdelta databases, you may need to wait longer in order to allow the recovery to finish successfully.
1.If you can start the DS-Client Service: - Connect to the DS-User and trigger a recovery of "DS-Client and delta databases" again. - After you restart the DS-Client Service, please check in the SQL Management Studio the status of the databases. If the status is loading, then the recovery has not yet finished and you should wait until the database status changes to normal. - Try connecting with the DS-User to DS-Client.
2.If you cannot start the DS-Client Service: - delete the dsclient and dsdelta databases manually from SQL management Studio ( https://www.microsoft.com/en-au/download/details.aspx?id=30438 ) or by running the following at an elevated command prompt if sqlcmd.exe is installed
sqlcmd -S .\SQLEXPRESS -q "drop database [dsclient]"
sqlcmd -S .\SQLEXPRESS -q "drop database [dsdelta]"
. - Re-run the DS-Client installation and recreate the DS-Client databases. - Start the database recovery again. - Please make sure that dsclient and dsdelta databases are not in use by other queries while your are trying to recover them.