Post reply

SQL Mgmt Studio "Application attempted to perform an operation not allowed by the security policy"

  • August 5, 2011 at 1:34 am

    #1364129

    Enable auditing of policies on the box and then check the event viewer. That would at least tell you exactly what permission was denied.

    -- Gianluca Sartori

  • August 5, 2011 at 2:28 am

    #1364143

    Don't know if this will help, but SQL Server recognises domain logins by their Windows SIDs. When the domain user account was recreated it would have been created with a different SID from that of the original domain user account. Did you try dropping/adding the login for that account in SQL Server?

  • August 5, 2011 at 2:37 am

    #1364147

    Problem resolved !!

    Not entirely sure what my main IT guy's did but it's working again now, even though yesterday they couldn't figure out hence the need for me to post.

    Thanks to all that replied appreciate it.

  • August 5, 2011 at 2:48 am

    #1364152

    It would have been very helpful to find the root cause, just in case it happened again.

    However, glad you sorted it out.

    -- Gianluca Sartori

Viewing 4 posts - 1 through 5 (of 5 total)

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