{"id":74,"date":"2010-02-11T10:24:49","date_gmt":"2010-02-11T15:24:49","guid":{"rendered":"http:\/\/blog.bitsofgenius.com\/?p=74"},"modified":"2010-02-14T20:43:32","modified_gmt":"2010-02-15T01:43:32","slug":"sql-server-integrated-authentication-and-to-tell-the-truth","status":"publish","type":"post","link":"https:\/\/blog.bitsofgenius.com\/?p=74","title":{"rendered":"SQL Server, Integrated Authentication, and &#8220;To Tell the Truth&#8221;"},"content":{"rendered":"<p>Moderator: &#8220;Login number one, what is your identity?&#8221;<\/p>\n<p>Number one: &#8220;I am known as jsmith&#8221;<\/p>\n<p>Moderator: &#8220;Login number two, what is your identity?&#8221;<\/p>\n<p>Number two: &#8220;I am known as jsmith&#8221;<\/p>\n<p>&#8230; and after all the contestants would make the same claim, the moderator on &#8220;To Tell the Truth&#8221; would then give some background on the contestants, and iterate &#8220;one of these login&#8217;s is the real jsmith&#8221;.<\/p>\n<p>Evidently, not in SQL Server 2005 Express.\u00a0 It just answers every contestant with, &#8220;Of course you are.\u00a0 Come on in.&#8221;<\/p>\n<p>This behavior occurs under the following set of circumstances.<\/p>\n<ul>\n<li>On the SQL server and the client machine connecting to it, you have a local NT account which has the same name on both machines.<\/li>\n<li>Both accounts use the same password (so it&#8217;s not really any serious security threat in most cases).<\/li>\n<li>Your connection is using integrated security.<\/li>\n<\/ul>\n<p>Apparently, SQL Server will compare the login as &#8220;.\\jsmith&#8221; and not as &#8220;CLIENT\\jsmith&#8221;.\u00a0 Unexpected behavior, but it has proven useful if it was intended.\u00a0 I&#8217;m only seeing the behavior in local NT access: I don&#8217;t see Domain NT access having this problem.<\/p>\n<p>I haven&#8217;t seen any hits when doing a search on Google about this.\u00a0 I&#8217;m not sure if this is by design or an oversight. In my case, I&#8217;m am number one and number two.. so it has its advantages.<\/p>\n<p>Follow-up: I found out (thanks Don Cross) that this is the behavior of Windows Workgroup mode, and is expected.\u00a0 It&#8217;s a neat little mode that I didn&#8217;t know about, and very useful for some things that I want to do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Moderator: &#8220;Login number one, what is your identity?&#8221; Number one: &#8220;I am known as jsmith&#8221; Moderator: &#8220;Login number two, what is your identity?&#8221; Number two: &#8220;I am known as jsmith&#8221; &#8230; and after all the contestants would make the same claim, the moderator on &#8220;To Tell the Truth&#8221; would then give some background on the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,17],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":0,"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bitsofgenius.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}