I encountered an issue where a SQL Database was in restoring state after a restore operation failed from SQL Management studio UI.

When attempting to connect to SQL server database using Dynamics NAV SQL client, you may recieve the following message: The Server cannot be found. Try again later or contact your system administrator.

When installing NAV 2009 database component on window server 2008 that has SQL server 2008 installed, the following error may occur: Failed to connect to SQL database (-2147467259 master)