current datasource is unavailable -multiple errors

Hi,
Do you have any other application installed in the database, or it exclusive for Remote Desktop Manager ? For the login error, here is some possible causes:

http://msdn.microsoft.com/en-us/library/ms366351.aspx

Hi David,

This server is a dedicated SQL server that has multiple databases. The other applications that connect to it have no issues. We have been using it for RDM for about 8 months. Just recently we have been getting the errors I mentioned. There seems to be no pattern you can be connected and then the error pops up and you lose connection to the SQL server. You may get right back in or you may have to wait to get back in. So far our database admin has not determined if this is an application or a database issue. So any help would be appreciated as this is our main management application.

If we use the offline mode and we lose connection will it reconnect with the database comes back online automatically? I only ask as this would help us to keep working while we determine the cause of the problem.

Thanks,
Larry

Hi,
What you can try, is to increase the connection timeout, You can also try install another instance of SQL Server Express and see if you get the error. Maybe this happen when a long query is executed by another application (a report for example).

For the offline mode, you must return online manually, there is a menu item for that in File. Let me know if I can do something else.