CODEWITHSUNDEEP
sql-servervisual-web-developer-2010
Elise Jackson
Elise Jackson

Reputation: 1

Can't create SQL database, visual studio gets stuck and I get this error after a while

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.

Upvotes: 0

Views: 722

Answers (2)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89396

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

Upvotes: 0

Kaumadie Kariyawasam
Kaumadie Kariyawasam

Reputation: 1476

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

Upvotes: 0

Related Questions