Category: Microsoft SQL Server

SQL Database in Restoring State

I encountered an issue where a SQL Database was in restoring state after a restore operation failed from SQL Management studio UI. I used the following SQL Script to take the database back to operational state: Script: RESTORE DATABASE [Database Name] WITH RECOVERY

Read More
Firewall: Microsoft SQL Server 2008

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. System Environment: Server: Windows Server 2008 (any edition) SQL Server: Microsoft SQL Server 2008 (any edition) Dynamics NAV: 2009 SP1 A solution on […]

Read More
Error: Installing Database Component

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) This error is typically triggered because when the local database was installed and then subsequently uninstalled, the SQL Server not available during the uninstallation. It is possible that SQL […]

Read More
Copyright © 2020 Unylogic Consulting Ltd.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram