G Guest Jun 8, 2004 #1 I have a middle tier dll that will be accessing SQL Server 2000 with ADO .NET. What is the best way to do my connection? Adding a user to SQL Server or using the Windows authentication
I have a middle tier dll that will be accessing SQL Server 2000 with ADO .NET. What is the best way to do my connection? Adding a user to SQL Server or using the Windows authentication
W William Ryan eMVP Jun 8, 2004 #2 It really depends, but in general, using Windows Authentication is considered more secure and it's definitely easier to maintain. -- W.G. Ryan, eMVP http://forums.devbuzz.com/ http://www.knowdotnet.com/williamryan.html http://www.msmvps.com/WilliamRyan/ http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp Alex said: I have a middle tier dll that will be accessing SQL Server 2000 with ADO Click to expand... ..NET. What is the best way to do my connection? Adding a user to SQL Server or using the Windows authentication?
It really depends, but in general, using Windows Authentication is considered more secure and it's definitely easier to maintain. -- W.G. Ryan, eMVP http://forums.devbuzz.com/ http://www.knowdotnet.com/williamryan.html http://www.msmvps.com/WilliamRyan/ http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp Alex said: I have a middle tier dll that will be accessing SQL Server 2000 with ADO Click to expand... ..NET. What is the best way to do my connection? Adding a user to SQL Server or using the Windows authentication?
