Problem with SQL Server

Question

I am having a problem with accessing SQL Server in visual studio. I am reading in a csv file and putting it into a SQL Server database. I am using DBAccees to do this, however, when I run the application, I get a "Login Failed for user" error. I am not sure why it is doing this as the username and password is right.

DBAccess _dba = new DBAccess("server=servername;database=name;password=password;user=username");

Any help is appreciated

Chandu · Accepted Answer · 2011-02-03 16:33:37Z

2

I think the username parameter in the connection string is wrong. change it to:

DBAccess _dba = new DBAccess
                ("server=servername; database=name;password=password;uid=username");

answered Feb 3, 2011 at 16:33

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

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

3 Comments

Joe Smith Over a year ago

if i want have to no password, do i need to put password= or just not put it in there at all

Joe Smith Over a year ago

well, I am currently using my local machine as the server...Would that cause any problems...and i cant get sql server authentication to work..only windows authentication

Chandu Over a year ago

Are you able to connect to the server using SQL Server Management Studio and using SQL Authentication?

David Yenglin · Accepted Answer · 2011-02-03 18:32:42Z

0

If you cant get SQL server authentication to work, have you verified you have a correctly configured SQL user setup? With access to the correct database? If you don't need to use SQL authentication and want to use Integrated use this for a connection string:

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

answered Feb 3, 2011 at 18:32

David Yenglin

6855 silver badges14 bronze badges

Collectives™ on Stack Overflow

Problem with SQL Server

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related