Cannot add App_Data SQL Server database

Question

Using Visual Studio 2010 10.0.20319.1 RTMRel and SQL Server Express 10.50.1600.1 I'm trying to add a new SQL Server Database .mdf, however, I receive the following error:

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: 25 – Connection string is not valid)

I have enabled TCP/IP and Named Pipelines, added Firewall Exceptions for Sql Server, I am successfully connecting from VS in the Server Explorer window.

I would appreciate if someone can pint me to a solution to my problem.

Thank you.

The error says that your connection string is not valid. So, check your connection string. If you're not sure what to look for, then post your connection string. — Aaronaught
– Aaronaught, Commented May 9, 2010 at 21:58
I start blank, I do not have any connection string set up; none that I know of anyway. — Interfector
– Interfector, Commented May 10, 2010 at 12:36

Simon L-D · Accepted Answer · 2013-03-13 18:59:12Z

1

I think that SQL Server must be running locally to be able to create those databases.

I was getting the same error
Started my local .\SQLEXPRESS instance
no more error, and a cute .mdf file was created

answered Mar 13, 2013 at 18:59

Simon L-D

111 bronze badge

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

1 Comment

Interfector Over a year ago

I cannot verify the answer anymore, but I'll give a plus :)

SQLMenace · Accepted Answer · 2010-05-09 22:05:38Z

0

According to your error

(provider: SQL Network Interfaces, error: 25 – Connection string is not valid)

check here what your connection string should look like

http://www.connectionstrings.com/sql-server-2008

answered May 9, 2010 at 22:05

SQLMenace

136k25 gold badges212 silver badges227 bronze badges

Collectives™ on Stack Overflow

Cannot add App_Data SQL Server database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related