SQL Server DLLs required on user's PC

Question

Hi,
I have deployed my program on several user's PCs and they get the following error I believe when the program tries to Open a connection: "Login filed for user". Kind of a strange error., since the credentials are in the program and I don't get the error when I run from my PC, but obviously I have all the correct DLLs installed since I have SQL Server 2014 installed on my development PC. What DLLs does the user's PC need to have installed? We are using SQL Server 2014.

Thanks

Answer 1

It was the "Integrated Security=SSPI;Persist Security Info=False;" actually more precisely just the "Integrated Security=SSPI;" that was forcing the connection to the Windows logon instead of the SQL Server user logon specified in the connection.

SqlConnection myConnection = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FPY;Data Source=MyServer;User ID=PartsetupUser;Password=MyPassword");