-1

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:

  1. Ping and DNS resolve test from internal and external (my laptop).
  2. Creating System ODBC entry and then perform test from the server RDP connection and also remotely from my laptop.
  3. 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.

Katherine Villyard
  • 18,550
  • 4
  • 37
  • 59
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
  • 3
    By default TCPIP protocol is not enabled when you install sqlexpress, can you validate it's enabled ? – yagmoth555 Dec 08 '14 at 01:11
  • yes it is enabled from the SQL Server Configuration Manager. – Senior Systems Engineer Dec 09 '14 at 02:40
  • 1
    Can you explain how your monitoring software is trying to log in? Sounds like maybe it's using a login that doesn't have access to the server or database. Also, is your SQL Server instance set to use only Windows authentication, or is it mixed mode? – squillman Dec 16 '14 at 15:26

1 Answers1

0

OK, so the problem was that the server where the SQL Server is running, all in a sudden was removed from the DNS. :-/

Not sure why, the server can ping to the rest of the data center, but the rest of the data center cannot ping or access this server.

Rebooting the server resolved this issue.

Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62