I'm running a program called ChefTec that uses a local SQL database to store
all the information. I recently tried to open the program and am now getting
the following error:

[DBNETLIB][ConnectionOpen (Connnect().]SQL Server does not exist or access
denied.

Can someone please me figure this out. The company that makes the
software is no without paying them a lot of money. I need this resolved
ASAP.
Thanks

"Harlan" <Harlan@discussions.microsoft.com> wrote in message
news:33755D98-696A-4E69-A9E8-21C35BA9AFF3@microsoft.com...
> I'm running a program called ChefTec that uses a local SQL database to
> store
> all the information. I recently tried to open the program and am now
> getting
> the following error:
>
> [DBNETLIB][ConnectionOpen (Connnect().]SQL Server does not exist or access
> denied.
>
> Can someone please me figure this out. The company that makes the
> software is no without paying them a lot of money. I need this
> resolved
> 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