I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software).
I have perform the following tests, all of which succeeded:
- Ping and DNS resolve test from internal and external (my laptop).
- Creating System ODBC entry and then perform test from the server RDP connection and also remotely from my laptop.
- Open up SQL Server management studio and look at the status of the database, are all fine with the total disk usage is under 4 GB.
The following is the error that I can capture:
---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed: SQLState: '01000' SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed: SQLState: '08001' SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
---------------------------
OK
---------------------------
Any help and suggestion would be greatly appreciated.