> I'm running a program called ChefTec that uses a local SQL database to
> store
[quoted text clipped - 10 lines]
> ASAP.
> Thanks
Hi
The message is as it says! You can not connect to the server because you are
either connecting to the wrong server or it can find the server and you
aren't permitted to connect or are using the wrong credentials or there is a
configuration issue that stops you connecting.
If the first question is have you ever had this application working? If yes
then what has changed? Is SQL Server running? Can you connect to the server
using SQLCMD, SSMS or even the ODBC (DSN) configuration manager.
If no check that you have configured the connection string correctly. Check
you can connect to the SQL server using one of the programs listed above
then it is related to the application. If not check you can connect locally
(on the sever itself), if only remote connections are not working check
they are enabled in the Surface Area Configuration Tool. Also check the
protocols configured on client and server and make sure they correspond.
HTH
John