sql server express 2014 named instance not connecting from outside network

%3CLINGO-SUB%20id%3D%22lingo-sub-1588348%22%20slang%3D%22en-US%22%3Esql%20server%20express%202014%20named%20instance%20not%20connecting%20from%20outside%20network%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588348%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3Ei'v%20install%20sql%20server%20express%202014%20named%20instance%20with%20mixed%20mode%20authentication.%3C%2FP%3E%3CP%3Eone%20more%20sql%20server%202005%20version%20installed%20with%20default%20instance%20and%20TCP%20port%20has%20been%20assigned%201433.%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3Efollowing%20error%20occurred%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EServer%20Name%3A%20.%5Csqlexpress%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EError%20Number%3A%2018456%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ESeverity%3A%2014%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EState%3A%201%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ELine%20Number%3A%2065536%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E-i%20want%20to%20connect%20localy%20(with%20dot)%20but%20not%20able%20to%20connect%2C%20i%20also%20want%20to%20connect%20from%20outside%20network%3C%2FP%3E%3CP%3E-with%20static%20IP%20still%20getting%20the%20same%20problem.%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3Efollowing%20changes%20i've%20done%3C%2FSTRONG%3E%3C%2FU%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-remove%20dynamic%20tcp%20port%20from%20configuration%20manager%20ipall%3C%2FP%3E%3CP%3E-instead%20of%20dynamic%20port%20i've%20place%20static%20tcp%20port%201438%20and%201440%20both%20are%20listening%3C%2FP%3E%3CP%3E-try%201434%20tcp%20port%20but%20sql%20service%20not%20able%20start%20so%20i've%20change%20into%201438%20and%201440.%3C%2FP%3E%3CP%3E-and%20same%20has%20been%20configured%20from%20firewall%20inbound%20and%20outbound%20rule.%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3E--also%20tried%20through%20dbeaver%20to%20make%20connection%20but%20following%20error%20occurred%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3ESQLEXPRESS%2C1438%20failed.%20Error%3A%20%22java.net.UnknownHostException%3A%20103.87.24.38%3A3390%3A%20invalid%20IPv6%20address%22.%20Verify%20the%20server%20and%20instance%20names%20and%20check%20that%20no%20firewall%20is%20blocking%20UDP%20traffic%20to%20port%201434.%20For%20SQL%20Server%202005%20or%20later%2C%20verify%20that%20the%20SQL%20Server%20Browser%20Service%20is%20running%20on%20the%20host.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

hi,

i'v install sql server express 2014 named instance with mixed mode authentication.

one more sql server 2005 version installed with default instance and TCP port has been assigned 1433.

following error occurred

Server Name: .\sqlexpress
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

-i want to connect localy (with dot) but not able to connect, i also want to connect from outside network

-with static IP still getting the same problem.

following changes i've done 

-remove dynamic tcp port from configuration manager ipall

-instead of dynamic port i've place static tcp port 1438 and 1440 both are listening

-try 1434 tcp port but sql service not able start so i've change into 1438 and 1440.

-and same has been configured from firewall inbound and outbound rule.

--also tried through dbeaver to make connection but following error occurred

SQLEXPRESS,1438 failed. Error: "java.net.UnknownHostException: 103.87.24.38:3390: invalid IPv6 address". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

0 Replies