SQL Server Express Entity Framework code-first

Question

I Tried to use the code first approach to create my database I created every class that I needed and then added a web form to my project and a grid view to it. then I tried to set the grid view's data source to the data base. when I want to Choose a new connection it actually finds my database automatically named "TimeTrackerDbContext" but when I hit next I get this error : "Database Schema Could not be retrieved for this connection. A network related or instance-specific error occured 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: Named Pipes Provider, error:40 - Could not open a connection to SQL Server) at DataObjectSupport(422,6)"

my connection strings section in web.config is: "name="TimeTrackerDbContext" connectionString="server=./SqlExpress;integrated security=SSPI; database =TimeTracker" providerName="System.Data.SqlClient"

and I use win 8. Can you help?

server=./SqlExpress; should not it be server=.\SqlExpress;? — Pawel
– Pawel, Commented Nov 8, 2012 at 16:06

Hugo V · Accepted Answer · 2012-11-08 16:03:10Z

0

Are you sure your active directory username is dbowner if this database? You need to have the rights to create objects in this database

answered Nov 8, 2012 at 16:03

Hugo V

1843 bronze badges

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

3 Comments

Noid Over a year ago

no actually I'm not sure , I'm brand new to this , I was following a video tutorial and I did everything according to it. but I got this Error. can you explain what you mean by active directory username?

Hugo V Over a year ago

Check out this post: How to add Active Directory user group as login in SQL Server

Hugo V Over a year ago

In you case you add your windows user, the same you have in the error message. Make sure that you check dbowner in options.

Collectives™ on Stack Overflow

SQL Server Express Entity Framework code-first

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related