cannot open database requested in login 'My_database'. Login fails

Question

0.00/5 (No votes)

See more:

C#

st = "Data source =eduDotNet-Pc06; Initial Catalog=My_database; Integrated security=true";
         cn = new SqlConnection(st);
            try
            {
                cn.Open();

            }
            catch (Exception e1)
            {
                MessageBox.Show(e1.Message);
            }

Posted 23-Oct-12 2:31am

zeshanazam

Add a Solution

Comments

Herman<T>.Instance 23-Oct-12 8:35am

sometimes you have to set Integrated security=sspi in stead of true. don't ask me why. Is your account added to the logins and users in the database system?

3 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)

Tim Corey · Answer 1 · 2012-10-23T02:34:00

Solution 1

This is rather straight-forward: the login you are running this code under does not have permissions to this database. When you use "Integrated Security=true", you are saying that the application will take the permissions of the user running it. If this is a desktop application, it is going to be the logged on individual. If it is a service, it will take on the permissions that the service runs under. If it is a web application, it will take on the permissions of the application pool it is using.

To fix the error, figure out who you are running under and make sure to give them the appropriate permissions.

Posted 23-Oct-12 2:34am

Tim Corey

Comments

zeshanazam 23-Oct-12 8:39am

how to give them the appropriate permissions. ?? using windows xp.

Tim Corey 23-Oct-12 8:45am

The permissions are at the database level, not the operating system level. You would need to identify which accounts need access to the database and then add those accounts to the security in the database. How you do that depends on your database type that you are using. Your other option would be to use a local database user instead of integrated security. I would recommend you look into database security before you continue just to make sure you know what you are doing and why.

Ambesha · Answer 2 · 2012-10-23T02:40:00

Solution 2

Please verify that are you able to login in database seperatly , if also not there then stop the service for DB and change the credential form there and restart the service .

Thanks,
Ambesha

Posted 23-Oct-12 2:40am

Ambesha

Comments

zeshanazam 23-Oct-12 8:57am

I HAVE TRIED EVERY THING, BUT PROBLEM IS SAME....

Lakhan Aanjana · Answer 3 · 2012-10-23T07:28:00

Solution 4

please try this...

st = "Data source =eduDotNet-Pc06; Initial Catalog=My_database; Integrated security=SSPI"; User Id=myUsername; Password=myPassword;

Please Let Me know ur feed back

Thanks
lp

Posted 23-Oct-12 7:28am

Lakhan Aanjana