SQL Server ConnectionOpen (Connect()) Error
Did SQL Server 2000 ever give you this weird error?
It’s usually accompanied by a “[DBNETLIB] SQL Server does not exist or Access Denied error”.
There are many reasons this could happen. Here are a few things you can try to get rid of this error:
- If you’re using an older version of SQL Server Desktop Engine, download Desktop Engine Release A and install it. If you already have data, etc, you will need to download the latest SQL Server Service Pack in order to update it.
- If you get this error with SQL Server 2000, ensure you have the latest Service Pack installed.
- Go to “Start | Run…” and type “svrnetcn”. This will start the SQL Server Network Utility. Make sure Named Pipes and TCP/IP are in the “Enabled Protocols” list.
- If all these fail, go here and download the “SQL Server Security Tools”. This usually solves the problem.
