Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,050,852 hits
  • Select GETDATE()

    May 2014
    M T W T F S S

5 Responses to “SQL Internals – How to map login SID to domain account?”

  1. mj said


    Can we make use of suser_sid function to perform basic check whether actual SID for login named “SQLPAPA\blakhani” is same as the one stored in sys.syslogins/server_principals?

    SELECT name FROM sys.server_principals WHERE sid = SUSER_SID(“SQLPAPA\blakhani”);

    • blakhani said

      No. SUSER_SID won’t help. If the login is present is sys.server_principals it would show the value stored in table not the one which we saw using PsGetSid

  2. NIshad ak said

    blakhani : i need a favor ! i think you could help me. please contact me ASAP

  3. […] I have had a blog post having script to convert the varbinary to well known format. So I have used that to convert […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: