Login status

  • for sql server logins, there is a property menu of status that I can disble the login, and deny permission to connect to database engine.

    What does it mean: when a login is disabled. or denied .

    Can the user can still connect to the database?

    I have a SSRS report, data source is setup to connect to db using this user account , I found even I disabled the login, it can still connect to the database.

    Thanks

  • What connection does sp_who2 show is connecting to the SSRS database?

    Joie Andrew
    "Since 1982"

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

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