February 12, 2010 at 4:36 am
Hi,
I have changed my app connection string from windows to SQL Server authentication.
My app connect now to SQL Server using SQL Server authentication.
Can i expect my app to become more slow because of this change?
Do the querys executed perfome with the same speed?
Thank you
February 12, 2010 at 5:19 am
There wont be any difference in the speed, Windows authentication is preferred as it can be more secure since it is controlled via the AD
February 12, 2010 at 6:07 am
yeph , i know but we have some specifyc situations in the company where we need to use this.
Thank you very much.
P.s - the connection to the server with SQL Server authentication will be encrypted (SSL) so that no one can put a sniffer on the network and see the user and pasword.
February 12, 2010 at 8:27 am
steveb. (2/12/2010)
There wont be any difference in the speed, Windows authentication is preferred as it can be more secure since it is controlled via the AD
Windows authentication in Asp.net also reduce the application capacity because AD primary task is to resolve users in a Windows network. SQL authentication allows the application to scale.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply