Sql server express 2014 named instance not connecting from outside network

Question

1.00/5 (1 vote)

See more:

Quote:
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 locally (with a dot) but not able to connect, I also tried to connect from the 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 to start so I've to change into 1438 and 1440.

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

--

What I have tried:

also tried through Dbeaver to make the connection but the 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.

Posted 14-Aug-20 22:09pm

Member 12584383

Updated 14-Aug-20 22:20pm

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-08-14T22:16:00

Read the error message:

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

It tells you what the problem is, and also exactly what you need to do to fix it!

We can't do any of that for you: we have no access to your systems at all!

Sandeep Mewara · Answer 2 · 2020-08-14T22:20:00

You posted this in Database forum yesterday: Database Discussion Boards[^]

Posting same query in multiple places is considered rude. Now looking at the error:

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

It has details of what is causing it. Did you had a look at it?

Attempt and see if things change:
1. verify the server and instance names
2. check that no firewall is blocking UDP traffic to port 1434
3. verify that the SQL Server Browser Service is running on the host

UPDATE:
For such issues, if the obvious errors are not there, you need to troubleshoot and follow knowledge base articles and figure what could be wrong:

1. Reference: https://kb.informatica.com/solution/23/pages/60/507019.aspx

Open SQL server Configuration Manager and enable TCP/IP. TCP/IP should be enabled under:
a. SQL Native client 11.0 configuration
b. SQL server Network Configuration

2. Reference: Configure Windows Firewall - SQL Server | Microsoft Docs[^]
See for firewall setup, connection string used , etc.

Sql server express 2014 named instance not connecting from outside network

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Sql server express 2014 named instance not connecting from outside network

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us