Post reply

Changed my app connection string from windows to SQL Server authentication

  • February 12, 2010 at 4:36 am

    #141280

    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

    #1117960

    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

    #1117971

    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

    #1118068

    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