SQL Server DLLs required on user's PC

Timothy Alvord 236 Reputation points
2021-01-04T18:50:33.66+00:00

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

Developer technologies | .NET | Other
0 comments
Answer accepted by question author
Timothy Alvord 236 Reputation points
2021-01-05T04:03:01.343+00:00

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");

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.