February 25, 2009 at 10:41 pm
Pls let me know the advantages/Disadvantages of using Trusted connections over SQL logins from the application?
Which is the better way of implmenting?
Thanks for the help
February 26, 2009 at 7:36 am
If you are running a desktop application then Trusted Connections are the way to go. With web applications they are a little more difficult to implement, but still, IMO, should be used if possible.
If your AD uses groups then most of the management can be done in AD by assigning users to the correct groups because you could allow those groups access to the SQL Server and then to the database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 26, 2009 at 2:31 pm
Unless you have a bonafide functionality reason why you couldn't use trusted connections (such as a web server sitting in the DMZ, which wouldn't be on the domain), the recommendation is to go with trusted connections. Most of the reasons have been covered by Jack.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply