Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

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

  1. mj said

    Hi,

    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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

 
%d bloggers like this: