Click here to Skip to main content
14,931,001 members
Please Sign up or sign in to vote.
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
Updated 14-Aug-20 22:20pm

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!
   
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.
   
v5
Comments
Member 12584383 15-Aug-20 6:21am
   
1---yes,
I've posted the same query yesterday on SQL community forum
but not any single response throghout the day. that's the reason posted multiple forum of same query.

2- instance name and server name is correct
1434 port is open from firewall and SQL browser is running fine
--I want to make a connection with local(without using server name and instance name)
--and it can be accessible from outside network(using static ip)
Sandeep Mewara 15-Aug-20 6:54am
   
Sure.

Updated answer with couple of more options. Checkout. You need to troubleshoot and see all good.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900