Connection String Security Options

Last post 09-08-2009, 7:23 PM by MaxxTheAxe. 2 replies.
Sort Posts: Previous Next
  •  08-10-2009, 2:19 AM 54596

    Connection String Security Options

    is there a way i can change the connection string security to Integrated Security=True? The problem is I cant connect my sql express using sql server authentication, I can only use windows authentication in order for me to install the cute chat database. Thank You.
  •  08-10-2009, 10:52 AM 54612 in reply to 54596

    Re: Connection String Security Options

    You can change the identity of the AppPool to a trusted account and then use SSPI. Only flaw is that that means the whole app is running as that user should it ever be compromised. I'm sure the Cutesoft guys have taken that into account.
  •  09-08-2009, 7:23 PM 55450 in reply to 54596

    Re: Connection String Security Options

    I had this same problem. The solution was to put "Trusted_Connection=True;" in the connection string if you do not use a password to connect to SQL Express.
    Filed under: ,
View as RSS news feed in XML