BillQuick is installed on the server that is also hosting SQL Server and it successfully connects and opens the company file. However, when BillQuick is installed on a workstation, it fails to recognize the SQL Server.
There are a few possibilities as to why this is happening:
- Either your workstation is not networked properly to see your SQL Server. Use Ping command to test the connectivity.
- Most commonly, Windows Firewall on Windows Server helps prevent unauthorized access to computer resources. However, if the firewall is configured incorrectly, attempts to connect to an instance of SQL Server may be blocked.
To access an instance of SQL Server that is behind the firewall, you must configure the firewall on the computer that is running SQL Server.
Please see the below knowledgebase article from Microsoft's website:
http://support.microsoft.com/kb/968872