SQLConnection code [duplicate]

Question

When trying to establish a connection I get the exception below:

System.Data.SqlClient.SqlException occurred
  HResult=0x80131904
  Message=Login failed for user ''.
  Source=.Net SqlClient Data Provider
  StackTrace:
<Cannot evaluate the exception stack trace>

I keep getting the above error, here is my code:

SqlConnection conn = 
  new SqlConnection(@"Data Source = Computer-DELL\SQLEXPRESS;Initial Catalog = Drivers");

conn.open();

What about entering a user ID and password, or trusted connection? — Patrick Hofman
– Patrick Hofman, Commented Jul 4, 2017 at 11:05

sharp · Accepted Answer · 2017-07-04 11:05:38Z

2

Your connection string does not have Username and Password and or Integrated Security.

With Integrated Security:

Data Source=localhost\SQLSERVER;Initial Catalog=YourDataBaseName;Integrated Security=True;

With username and password:

Data Source=localhost\SQLSERVER;Initial Catalog=YourDataBaseName;persist security info=True;user id=someusername;password=somepassword;

answered Jul 4, 2017 at 11:05

sharp

1,21115 silver badges41 bronze badges

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

1 Comment

SCramphorn Over a year ago

If it is local and they have rights use the integrated security if its easier.

SCramphorn · Accepted Answer · 2017-07-04 11:10:15Z

0

Assuming they have permission, local user:

SqlConnection conn = new SqlConnection(@"Data Source = Computer-DELL\SQLEXPRESS;Initial Catalog = Drivers;Trusted_Connection=True;")
conn.open();

answered Jul 4, 2017 at 11:10

SCramphorn

4674 silver badges25 bronze badges

Collectives™ on Stack Overflow

SQLConnection code [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related