cannot open database CSE-DEPT requested by the login. the login failed for the user,,,

Question

0.00/5 (No votes)

See more:

Hi. I receive this error when I try to connect to the database 'CSE-DEPT' through my vc# applicaton. My connection string is:

C#

SqlConnection conn = new SqlConnection(@"server = .\sqlexpress; integrated security = true ;database = CSE_DEPT");

I tried the solution of

"Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties. In newly opened screen of Login Properties, go to the "User Mapping" tab. Then, on the "User Mapping" tab, select the desired database – especially the database for which this error message is displayed. On the lower screen, check the role db_owner. Click OK."

but it didnt work.
Your detailed answer is appreciated for this beginner

Posted 11-Jul-12 7:30am

cs101000

Updated 11-Jul-12 7:43am

Mehdi Gholam

v2

Add a Solution

Comments

[no name] 11-Jul-12 14:20pm

Are you logging into your windows desktop as yourself or NETWORK SERVICE?

cs101000 12-Jul-12 1:36am

I have an administrator windows user account that I have logged into and also want to login to sql server with that

[no name] 12-Jul-12 7:36am

And did you set up your user account with access to the database? Why are you messing around with the network service account?

cs101000 12-Jul-12 9:16am

I think I did. Because I can access the database with that account (and windows authentication) by sql server management studio. The connection problem occurs when I wana connect through vc# app. And as I said in the comment of solution 1 I checked db_owner in that account, too.

[no name] 12-Jul-12 9:53am

Compare the connection string from management studio with the connection string that you are using and see if they are the same.

Sandeep Mewara 11-Jul-12 15:14pm

There would be more to the error messae. Can you share full detail?

cs101000 12-Jul-12 2:00am

http://i.imgur.com/cMQe1.png

[no name] 12-Jul-12 7:35am

That is a link to a graphic not an answer to the question.

cs101000 12-Jul-12 9:19am

Im sorry, I thought Sandeep Mewara wanted to see the full error message, didnt he?

[no name] 12-Jul-12 9:51am

Maybe all of us would like to see it. People do not always have access to various sites due to work restrictions.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SalCon · Answer 1 · 2012-07-11T09:48:00

Quote:
"Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties. In newly opened screen of Login Properties, go to the “User Mapping” tab. Then, on the “User Mapping” tab, select the desired database – especially the database for which this error message is displayed. On the lower screen, check the role db_owner. Click OK.

Instead of doing this with the Network Service, repeat the service with your own account name.

Sandeep Mewara · Answer 2 · 2012-07-12T20:15:00

Solution 2

http://i.imgur.com/cMQe1.png

Bases on this, login failed for user "REZA-CS\REZA"

Credentials provided for the user were incorrect. Give complete connection string with username and password. Try out and see.

Posted 12-Jul-12 20:15pm

Sandeep Mewara