Multiple sessions using a single database sign-on

  • When using a single database account for fetching data from a BI-tool we experience that one developer can use this way to sign-on, but others can not use this account.

    Is there any reason why SQL server will refuse the use of multiple connections. Or will it only allow a limited number of sessions/processes for one account?

  • Nope, no limits on accounts. Must be something else, though I'm not sure what.

    What is the error in connecting? Can the 2nd person connect with other credentials?

  • The error received is returned through the BI-tool and is no more then a hint to contact the database administrator.

    Tried to replicate the error message this morning , but to no avail. Currently the situation looks cured. Will post the exact error message when we run into the problem again..

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

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