Entity Data Model Wizard failed to attach to database

Question

I'm using the Entity Data Model Wizard in Visual Studio Express 2013 to create an EDM on an SQL 2012 Enterprise database that was already created.

Went through all the steps (working with Ying Bai's "Practical Database Programming with Visual Basic.NET" book) but when I click "Test Connection," I get this message:

“The attempt to attach to the database failed with the following information:

The user instance login flag is not supported on this version of SQL Server.

The connection will be closed.”

Any help in solving this would be appreciated.

Thanks,

Philip

Answer 1

Hi,

The forum supports .Net Framework Setup. Your issue isn't related to the forum.
I have moved it to the related forum for better support.

Regards.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

I'm using the Entity Data Model Wizard in Visual Studio Express 2013 to create an EDM on an SQL 2012 Enterprise database that was already created.

.... The user instance login flag is not supported on this version of SQL Server.

Hello Philip,

By Default the Express Edition of Visual Studio utilize a "user instance" of SQL Server, which is not supported by the Enterprise Edition of SQL Server.

You have to modify the Connection string in you app/web.config file: Remove "User Instance=True" and "AttachDBFile" properties; see also SQL Server Express User Instances

---

Olaf Helper

[ Blog] [ Xing] [ MVP]