This article discusses issues relating to connecting to a SQL database.
It may also resolve #DBCONNECT! errors returned by functions that use a database connection.
When the SQL database is hosted on a separate machine the following should be checked.
To establish if the firewall is preventing access we recommend disabling the firewall on the SQL Database machine temporarily and try re-connecting on the machine being licensed. If this is then successful re-enable the firewall and adjust the settings.
To adjust Windows Firewall settings on the SQL Database machine please refer to the relevant article below:.
For Windows Server 2003, Windows XP and Windows Vista - see How To: Configure Windows Firewall for SQL Server - Windows XP and Vista.
For Windows Server 2008, Windows 7 and Windows 8 - see How To: Configure Windows Firewall for SQL Server.
It could be that SQL Server is not configured for remote access. To change this setting please refer to the relevant article below:
For SQL Server 2005 - see How To: Configure SQL Server 2005 for Remote Access.
For SQl Server 2008 - see How To: Configure SQL Server 2008 for Remote Access.
|Knowledge Base Article Ref:||KB13103032|