We help IT Professionals succeed at work.

SQL: "A network-related or instance-specific error occurred..."

Medium Priority
29 Views
Last Modified: 2020-03-21
Hello:

I just installed a new instance of SQL and am getting the attached error that begins with "A network-related or instance-specific error occurred..."

I have tried everything online that I have found.  What can I do, to get rid of this?

Software Engineer

SQL
Comment
Watch Question

Senior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:

Author

Commented:
Great idea!

I just created and enabled a new firewall rule, for port 1433.  I'm still getting the error.  But, maybe, 1433 is not my port.  Is there a way of either telling the correct port number or do I need to do something else in the firewall rules?

Thanks!

John
ste5anSenior Developer
CERTIFIED EXPERT

Commented:
Change the network protocol from named pipes to TCP:

Surface Area Configuration

btw, for firewall rules allow the SQL Server binary of your instance instead of a fixed port number.

Author

Commented:
Thank you, both!

John

Explore More ContentExplore courses, solutions, and other research materials related to this topic.