Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1714

Re: Unable to connect Client to SQL Server

Show all headers | View raw

Erland Sommarskog laid this down on his screen :
> Bruno Campanini (brunocam@libero.it) writes:
>> Erland Sommarskog has brought this to us :
>>> What error message do you get?
>> 
>> Connection failed:
>> SQL State: '08001'
>> SQL Error: 5
>> [Microsoft][Driver 11 for SQL Server]Named Pipes Provider:Could non 
>> open a connection to SQL Server [5].
>> Connection failed:
>> SQL State: 'HYT00'
>> QSL Server Error: 0
>> [Microsoft][ODBC Driver 11 for SQL Server]Login timedout expired
>> 
>> From that I am unable to uderstand/get any useful information.
>> 
>
> Well, at least then I know that it is a connectivity problem and 
> not a strict authorisation problem.
>
> Could you try changing the server name to something absolutely 
> wrong and see if you get the same error message, or a different one?

With a wrong server name I got:

Connection failed:
SQL State: '08001'
SQL Error: -1
[Microsoft][ODBC Driver 11 for SQL Server]SQL Server Network 
Interfaces: Error Locating Server/Instance Specified
[xFFFFFFFF]
Connection failed:
SQL State: 'HYT00'
SQL Server Error: 0
[Microsoft][ODBC Driver 11 for SQL Server]Login timedout expired

> Are you using Windows authentication or SQL authentication?
SQL Authentication on the default instance MSSQLSERVER

> Sorry for all the question, but troubleshooting connectivity problems on 
> a distance with a minimum of information is tedious.
- TCP/IP enabled
- FILESTREAM enabled
- Allow remote connection to the server
- SQL Server Services are running
- SQL Server Browser is running
- SQL Server Agent stopped (it doesn't start!)
- Firewall disabled on Server and Client

It seems all is ok, but it's three days I try to connect a Client,
without any success!

Bruno

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 00:24 +0100
  Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 08:00 +0000
    Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 19:47 +0100
      Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 21:04 +0100
        Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 01:21 +0100
          Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 08:51 +0000
            Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 13:37 +0100
              Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 21:01 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 15:02 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 15:30 +0000
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:10 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:46 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 21:16 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 21:45 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 23:20 +0100

csiph-web