SQL Server Error “A Network Related or instance-specific Error: 40”

SQL Server Error “A Network Related or instance-specific Error: 40”


Problem description
When trying to make a connection from Visual Studio Entity Framework Connection Wizard to the local instance of the SQL Server - You get The Error: 40



  1. Make sure that the SQL Server is configured to Allow remote connections (go to SQL Server Management Studio > Properties > Connections)


  1. Make sure that the firewall is opened:  
netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT
  1. Open Sql Server Configuration Manager and SQL Server Services and make sure that the SQL Server Browser is up and running


  1. Go to Protocols for YOURINSTANCE


  1. Right click on TCP/IP (make sure it’s Enabled) and go to properties
  2. Select the IP Address tab and scroll down to the bottom
  1. If the TCP Port is empty then make sure to enter 1433
  1. Now hit Apply and OK and restart your instance




  1. Go to SQL Server Services, find SQL Server (YOURINSTANCE) right click and restart
  1. Netstat -ano will now show the port 1433 LISTENING
  1. If you now test the connection it should be successful

Comments

Post a Comment

Popular posts from this blog

C# - Simple Class Library and how to use it in another project

Image
C# - Simple Class Library and how to use it Create  a Class Library Project Create a new project - Console Application Right click on the newly created project and Set it as a StartUp Project Reason: You cannot run a Class Library on it’s own, it needs to be called from another project. Add a reference to your Class Library project In the SimpleClassLibrary Project - rename the Class to PrintOK and add a public method WriteOK() using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; namespace SimpleClassLibrary { public class PrintOK {     public void WriteOK(){      Console .WriteLine( "OK" );      Console .ReadLine(); } } } Add preprocessor  directive In the UsingClassLibrary project, add the following code: using System; using...
Read more

AWS CLI - INSTALLATION AND CONFIGURATION

Image
AWS CLI - INSTALLATION AND CONFIGURATION https://aws.amazon.com/cli/ Download the MSI installer from here Install as administrator If you haven’t done that before then create your IAM credentials here Access Key ID: AXXXXXXXXXXXXXXXXXXXXQ Secret Access Key : FYYYYYYYYYYYYYYYYYYYYYYYYYYYY2i After the installation is successfully accomplished - open cmd and issue the following command aws configure aws /? Try sns sns /? To get the list of commands that for the sns system You could also use aws help and aws sns help Run the following command: aws sns list-topics
Read more

Upload a file to a Web server in ASP.NET by using Visual C# .NET

Image
Upload a file to a Web server in ASP.NET by using Visual C# .NET Open the Visual Studio Click New > Project ASP.NET WebApplication Name it accordingly When the Project gets created, right click on it and click on Add > New Item > Web Form Name the form FileUpload.aspx Open the FileUpload.aspx the following code <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="FileUpload.aspx.cs" Inherits ="ASPFileUpload.FileUpload" %> <! DOCTYPE html > < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < title > FileUpload </ title > </ head > < body >     < form id ="form1" enctype ="multipart/form-data" runat ="server">         < p >< input type ="file" id ="File1" name ="File1" runat ="server...
Read more