Best way to verify Windows Account Access

  • Ok, so this seems simple... but for some reason I have never had to do this until now. I am having issues with a windows account and access to SQL 2005. I want to test the account and see if it has access. What is the best way to do this?

    If I use SSMS it will run as my account (not the windows account I want to test). If I use OSQL command line and pass it domain\username it fails. So how/what is the best way to test this?

    I created a cmd window using the runas command and that user. Then I established an OSQL -E connection. Is this the best way?

  • You might be able to do a RUN AS when you start SSMS and start it as that user, but you can't fool the tools into believing you are that person without logining in as them. Thats kind of the point of integrated security. Try right clicking on the SSMS icon and see if it offers RUN AS..

    CEWII

  • Hello,

    A right-click and then "Run As" of SSMS will indeed let you test as the Windows Account (assuming you have access to the password), but what specific issues are you experiencing with the Login? (There might be better methods for diagnosis).

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

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

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