Post reply

limit on connections using approle?

  • November 24, 2003 at 7:29 am

    #101769

    we have a web based application using an approle. We have set OLE DB Services = -2 to turn off resource pooling. When we get a large number of connections via the app we begin to see permission denied and various other errors.

    Is there a limit to the number of connections when using app roles? If so what is it? Can it be increased? Do we have to use another means of authentication?

    Thanks,

    Jim

  • December 2, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • December 3, 2003 at 9:38 am

    #484467

    Not aware of a limit on app roles specifically. Two limits you could hit would be max connection pool or max connections to the box. Bill Vaughn had a couple recent articles about pooling in SQL Mag.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply