-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.

3
  • 3
    By default TCPIP protocol is not enabled when you install sqlexpress, can you validate it's enabled ?
    – yagmoth555
    Dec 8, 2014 at 1:11
  • yes it is enabled from the SQL Server Configuration Manager. Dec 9, 2014 at 2: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, 2014 at 15:26

1 Answer 1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .