Link to home
Start Free TrialLog in
Avatar of LeTay
LeTay

asked on

Connection problem to SQL Server 2014 Express

I have installed SQL Server 2014 Express on a new server
I succeeded restoring a database from another SQL Server (2005)
SQL Studio works fine on the server
I adapted the TCP port on all IP addressed to 1433
Now I try to connect from a PC in the same network (TCP/IP) but it fails
Even running an local application that connects to the SQL server with TCP/IP fails
What shell I verify/set for TCP ?
(during the test, I disabled the server firewall to be sure)
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Hi LeTay,
Please post up any message that is returned when you try to connect from a PC.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LeTay
LeTay

ASKER

tcp/ip is enabled on all IP adresses
Does it need to be enabled somewhere else ?

For example, error trying to connect from for example from Studio from another PC
(french version)
Une erreur s'est produite lors de l'établissement d'une connexion au serveur. Lors de la connexion à SQL Server , cet échec peut être dû au fait que les paramètres par défaut de SQL Server n'autorisent pas les connexions à distance. (provider: Interfaces réseau SQL, error: 26 - Erreur lors de la localisation du serveur/de l'instance spécifiés) (.Net SqlClient Data Provider)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LeTay

ASKER

1. Firewall is currently disabled
2. Remote connection is enabled (server properties seen with Studio)
3. In the configuration, looking at Protocols for SQLExpress, TCP/IP is Enabled
4. In the same config of TCP/IP, all IP Addresses are active, enabled = yes, tcp dynamic ports empty and TCP PORT = 1433
5. Looking with Process Explorer the SQLServer process TCP/IP stuff, i see :
    Protocol TCP Local Address serverfullname:ms-sql-s LISTENING
    Protocol TCPV6 Local Address serverfullname:1433 LISTENING
6. Trying to connect with IP addresse fails
What else should I check ?
Avatar of LeTay

ASKER

I have tested the connection with telnet and that one connects correctly (telnet servername 1433)
So ?