1
kudos
spam Kudos Remove

SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format

published 1025 days, 22 hours, 44 minutes ago posted by sasa 1028 days, 21 hours, 4 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Tuesday, July 28, 2009 1:51:51 PM GMT

You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain account you have to use the pre-Windows 2000 format [domain\login]. Did you also notice that there's a limitation of 20 characters on the login portion of this format? Let's pretend that you use nice descriptive names for application accounts, for example:Sales.ReportUtil.ProdServiceSales.ReportUtil.ProdWebuser When you try to add these logins the 20 character limit cuts them both off at "Sales.ReportUt...

category: Security | clicked: 1 | | source: kendalvandyke.blogspot.com | show counter code
tags: Login, Security

No comments yet, be the first one to post comment.

To post your comment please login or signup