Error in connect sqlserver 2005 lan system

Question

Hi Friends I have developed in my project C# .net 2005 and sqlserver 2005. this project runs correctly in developing system. but when i have put that exe in other lan system that comes error. not working that project.that error is given below: Login failed for user the user is not associated with a trusted sql server connection how do i will.. my project works all my lan system.. my application work all system . but only one server. (server is developing system) Advance thanks Regards Bala.

Santhosh Veeraraman · Answer

Try these two fixes: 1. goto server properties > Security > Enable Sql server and windows authentication mode or Create a new valid user in the sql server and use it in the connection string. Before that try connecting sql with that newly created user through Management Studio and check if it is connecting or not.