connection string login error in c# ?

Question

1.00/5 (1 vote)

See more:

SQL

Cannot open database "mydb" requested by the login. The login failed.

my connection string is :

C#

public string connectionstring =
      @"Data Source=SSD-PC\SSD;Initial Catalog=mydb;user=sa;password=sa;Integrated Security=True";

Posted 9-Sep-14 4:06am

MariwanIT

Add a Solution

Comments

Thanks7872 9-Sep-14 10:11am

Ican't understand why you guys expect that some one will show you the direct and instant way to resolve the issue, you will implement it and done. Why? Have you ever heard about Google.com? Have you tried searching for the issue there?

MariwanIT 9-Sep-14 10:16am

are you ok.

[no name] 9-Sep-14 11:16am

@Rohan : hahaha,,, these people r really sick, u r right :(

[no name] 9-Sep-14 14:14pm

u r a mother f******** tooo

E.F. Nijboer 9-Sep-14 10:12am

try logging in using management studio and/or check out some of the examples here: http://msdn.microsoft.com/en-us/library/ms156450.aspx

MariwanIT 9-Sep-14 10:20am

thanks i have solved i have to change integrated security to false or delete it

OriginalGriff 11-Sep-14 5:28am

Off topic: Please don't edit spam posts to remove the content.
Instead, just hit the red flag, and (if you want to) report it here:
http://www.codeproject.com/Forums/1652005/Spam-and-Abuse-Watch.aspx
Chris tries out automated spam filters from time to time, and edited posts being reported as spam can confuse them. Plus there is the risk that people will assume you are the spammer, and report you instead of the real culprit! :laugh:

With QA question or answer spam, the Protectors are pretty vigilant and we will remove the offending item PDQ (we have the ability to directly delete stuff so we don't have to wait for enough spam reports to get rid of it) once it's brought to our attention.

4 solutions

Solution 4

if want to log in with windows authentication mode then you need to write Integrated Security=true instead of username and password
public string connectionstring =
@"Data Source=SSD-PC\SSD;Initial Catalog=mydb;Integrated Security=true";

if want to log in with SQL server authentication mode then you need to write user id and password instead of Integrated security= true other wise you can write Integrated Security=false

@"Data Source=SSD-PC\SSD;Initial Catalog=mydb;Integrated Security=false;user id=sa;password=sa;";

or

@"Data Source=SSD-PC\SSD;Initial Catalog=mydb;user id=sa;password=sa;";

Posted 15-Sep-14 21:00pm

Samatha Reddy G

Solution 5

try to make Integrated Security=false

C#

public string connectionstring =
     @"Data Source=SSD-PC\SSD;Initial Catalog=mydb;user=sa;password=sa;Integrated Security=false"

Posted 15-Sep-14 21:21pm

mhegazy94

Add a Solution

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

hypermellow · Accepted Answer · 2014-09-09T04:23:00

Solution 2

Hi,

Change your Integrated Security value to false.

C#

public string connectionstring =
      @"Data Source=SSD-PC\SSD;Initial Catalog=mydb;user=sa;password=sa;Integrated Security=false";

Whilst Integrated Security is set to True, the connection will be attempted using the Windows based credentials - i.e. it will ignore the username/password values in the connection string.

Hope it helps.

Posted 9-Sep-14 4:23am

hypermellow

Comments

MariwanIT 9-Sep-14 12:19pm

dear How to solve this error:
this.tempTableAdapter.Fill Login failed for user 'sa'.

hypermellow 10-Sep-14 6:18am

Hi, what happens when you connect using these credentials in SQL Server Management Studio?
If you can't connect using the Management Studio, then you'll need to review the permissions this user has in the target database.

MariwanIT 10-Sep-14 7:14am

my programs countered 10000 bugs then i am creating a new one.
thanks for you help

MariwanIT · Accepted Answer · 2014-09-09T04:21:00

Solution 1

delete Integrated Security or set it to false

Posted 9-Sep-14 4:21am

MariwanIT

Comments

[no name] 9-Sep-14 11:18am

google google :D

connection string login error in c# ?

4 solutions

Solution 2

Solution 4

Solution 1

Solution 5

Add your solution here

Preview 0

connection string login error in c# ?

4 solutions

Solution 2

Solution 4

Solution 1

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us