Entity Framework Connection Error “Cannot open database ”DB“ requested by the login. The login...
I am using Entity Framework in .NET MVC 3.0 and use Code First method.
And I used a .MDF file for database and also use "DropCreateDatabaseIfModelChanges" to generate database automatically after every change.
My application works correct, but when I open database from Server Explorer in VS, then my application gives an error:
Cannot open database "DB" requested
by the login. The login failed. Login
failed for user 'Mahdi-PCMahdi
Could you help me?!
asp.net-mvc entity-framework
asked Jun 4 '11 at 8:05
mdehghani
10629
add a comment |
I am using Entity Framework in .NET MVC 3.0 and use Code First method.
And I used a .MDF file for database and also use "DropCreateDatabaseIfModelChanges" to generate database automatically after every change.
My application works correct, but when I open database from Server Explorer in VS, then my application gives an error:
Cannot open database "DB" requested
by the login. The login failed. Login
failed for user 'Mahdi-PCMahdi
Could you help me?!
asp.net-mvc entity-framework
asked Jun 4 '11 at 8:05
mdehghani
10629
1
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16
add a comment |
I am using Entity Framework in .NET MVC 3.0 and use Code First method.
And I used a .MDF file for database and also use "DropCreateDatabaseIfModelChanges" to generate database automatically after every change.
My application works correct, but when I open database from Server Explorer in VS, then my application gives an error:
Cannot open database "DB" requested
by the login. The login failed. Login
failed for user 'Mahdi-PCMahdi
Could you help me?!
asp.net-mvc entity-framework
asked Jun 4 '11 at 8:05
mdehghani
10629
I am using Entity Framework in .NET MVC 3.0 and use Code First method.
And I used a .MDF file for database and also use "DropCreateDatabaseIfModelChanges" to generate database automatically after every change.
My application works correct, but when I open database from Server Explorer in VS, then my application gives an error:
Cannot open database "DB" requested
by the login. The login failed. Login
failed for user 'Mahdi-PCMahdi
Could you help me?!
asp.net-mvc entity-framework
asp.net-mvc entity-framework
asked Jun 4 '11 at 8:05
mdehghani
10629
asked Jun 4 '11 at 8:05
mdehghani
10629
asked Jun 4 '11 at 8:05
mdehghani
10629
asked Jun 4 '11 at 8:05
mdehghani
10629
asked Jun 4 '11 at 8:05
mdehghani
10629
10629
1
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16
add a comment |
1
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16
1
1
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16
add a comment |
2 Answers
2
active
oldest
votes
Not sure, but... In the Data Connection dialog have you got the "Data Source" set to "Microsoft SQL Server" - I think you might need to change it to be "Microsoft SQL Server Database File"
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
add a comment |
I got this error when I had the mdf file open in SQL SMS 2012 while I was trying to update-database in Visual Studio 2013 Package Manager Console. In my case VS 2013 and SQL SMS 2012 could not share the mdf file. Once I closed SQL SMS I was able to update the mdf file ... that was whack ...
answered Nov 16 '18 at 20:38
Radu Bartan
387
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f6235576%2fentity-framework-connection-error-cannot-open-database-db-requested-by-the-lo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Not sure, but... In the Data Connection dialog have you got the "Data Source" set to "Microsoft SQL Server" - I think you might need to change it to be "Microsoft SQL Server Database File"
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
add a comment |
Not sure, but... In the Data Connection dialog have you got the "Data Source" set to "Microsoft SQL Server" - I think you might need to change it to be "Microsoft SQL Server Database File"
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
add a comment |
Not sure, but... In the Data Connection dialog have you got the "Data Source" set to "Microsoft SQL Server" - I think you might need to change it to be "Microsoft SQL Server Database File"
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
Not sure, but... In the Data Connection dialog have you got the "Data Source" set to "Microsoft SQL Server" - I think you might need to change it to be "Microsoft SQL Server Database File"
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
answered Jun 4 '11 at 8:17
philhobgen
1,8221025
1,8221025
add a comment |
add a comment |
I got this error when I had the mdf file open in SQL SMS 2012 while I was trying to update-database in Visual Studio 2013 Package Manager Console. In my case VS 2013 and SQL SMS 2012 could not share the mdf file. Once I closed SQL SMS I was able to update the mdf file ... that was whack ...
answered Nov 16 '18 at 20:38
Radu Bartan
387
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
add a comment |
I got this error when I had the mdf file open in SQL SMS 2012 while I was trying to update-database in Visual Studio 2013 Package Manager Console. In my case VS 2013 and SQL SMS 2012 could not share the mdf file. Once I closed SQL SMS I was able to update the mdf file ... that was whack ...
answered Nov 16 '18 at 20:38
Radu Bartan
387
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
add a comment |
I got this error when I had the mdf file open in SQL SMS 2012 while I was trying to update-database in Visual Studio 2013 Package Manager Console. In my case VS 2013 and SQL SMS 2012 could not share the mdf file. Once I closed SQL SMS I was able to update the mdf file ... that was whack ...
answered Nov 16 '18 at 20:38
Radu Bartan
387
I got this error when I had the mdf file open in SQL SMS 2012 while I was trying to update-database in Visual Studio 2013 Package Manager Console. In my case VS 2013 and SQL SMS 2012 could not share the mdf file. Once I closed SQL SMS I was able to update the mdf file ... that was whack ...
answered Nov 16 '18 at 20:38
Radu Bartan
387
edited Nov 18 '18 at 12:40
answered Nov 16 '18 at 20:38
Radu Bartan
387
answered Nov 16 '18 at 20:38
Radu Bartan
387
answered Nov 16 '18 at 20:38
Radu Bartan
387
387
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
add a comment |
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
That's not a login failure. That's trying to drop a database while it's connected.
– Gert Arnold
Nov 18 '18 at 13:44
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f6235576%2fentity-framework-connection-error-cannot-open-database-db-requested-by-the-lo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Presuambly the process that creates the DB has different credentials to you.
– Will A
Jun 4 '11 at 8:16