0

enter image description here

It says "A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)"

I tried looking up solutions online but I couldn't find anything.

I am using Microsoft Visual Web Developer 2010 Express. I'm not using anything new because that's what my school uses when teaching. I've tried creating another website and doing it there, it gave me the same error.

jarlh
  • 42,561
  • 8
  • 45
  • 63
Elise Jackson
  • 1

2 Answers2

0

Let us check into the steps to resolve this error.

  1. SQL Server should be up and running.

  1. Enable TCP/IP in SQL Server Configuration

  2. Open Port in Windows Firewall

  3. Enable Remote Connection

  4. Enable SQL Server Browser Service

    https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ read this article to doing steps I described

Kaumadie Kariyawasam
  • 1,232
  • 3
  • 17
  • 35
  • In every tutorial I saw of people doing this they just clicked add new item, chose SQL database and it worked, are you sure I need to do all this before it will work? I don't even have an SQL server and they didn't either. – Elise Jackson Mar 27 '21 at 20:20
0

The installation should have included an instance of SQL Server Express Edition. Verify that you have that installed and running.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67