1

When I try to run aspnet_regsql.exe on my database when I get to the Select the Server and Database screen and try to choose database the following error is displayed:

Failed to query a list of database names from the SQL server. 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 the SQL server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have followed several tutorials, but nothing worked. Most just say to follow the installation wizard.

1 Answer 1

1

Is your SQL Server instance definitely accessible over named pipes? By default, SQL Server is locked down quite tightly these days, so you may need to enable named pipes (or open up a firewall port if it's not on your local machine).

Network protocol changes are made using the SQL Server Configuration Manager.

There's a good tutorial here.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.