SQL Server DLLs required on user's PC

• tim8w

  Old Hand

  Points: 375

  More actions

  January 4, 2021 at 11:52 pm

  Go to Answer

  #3827358

  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.

• tim8w

  Old Hand

  Points: 375

  More actions

  January 5, 2021 at 4:01 am

  Answer

  #3827414

  Ended up being in my ConnectionString. Once I ended up removing the "Integrated Security=SSPI;" everything worked correctly.

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