Allow logins for Windows domain accounts to be created using UPN format
When creating logins that are mapped from a Windows domain account you are required touse the pre-Windows 2000 format for the username (<domainName><loginName>). This is annoying as the maximum length of a login in this format is 20 characters.
Upvotes: 49<=-=Aug 4 2009 1:31PM=-=>
Thank you for your feedback. We’ll keep your suggestion and consider it for a future release of SQL Server.
This would be fantastic for shared hosts, right now we can’t reliably use the customer’s domain name as a login because of the 20 character limit, this is a limitation also found in MySQL for username length – never the less – a fix with this would be great for both convenience and consistency with most newer microsoft products using the userPrincipalName/UPN<=-=May 9 2013 5:40PM=-=>
Hi, Thank you for providing your feedback. You suggestion is something that we have already started thinking about. It’s unfortunately too late to add any new features to this release but we’ll definitely consider it for a future version of SQL Server.<=-=Dec 23 2016 10:15AM=-=>
Is there an update on which version this may be included with?<=-=Mar 22 2017 6:18AM=-=>
Are there any Updates about this? We really need this, since we mainly work with the UPN and some of our UPNs are longer than 20 characters.