SQLServerCentral.com / SQL Server 2008 / SQL Server 2008 Administration / Length limitation on domain accounts? / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 18:38:42 GMT20RE: Length limitation on domain accounts?http://www.sqlservercentral.com/Forums/Topic1438014-1550-1.aspxEvidently it's a limitation of the SAM Account Name attribute in order to be backwards compatible with older clients - [url]http://msdn.microsoft.com/en-us/library/ms679635.aspx[/url].Wed, 03 Apr 2013 02:47:55 GMTtafountainLength limitation on domain accounts?http://www.sqlservercentral.com/Forums/Topic1438014-1550-1.aspxI'm attempting to create a login from a Windows account like so:[code="sql"]USE [master]GOCREATE LOGIN [DOMAIN\MyLongerThan20CharacterServiceAccount] FROM WINDOWS WITH DEFAULT_DATABASE=[master];GO[/code]But this fails with the error:[i][b]Msg 15401, Level 16, State 1, Line 1Windows NT user or group 'DOMAIN\MyLongerThan20CharacterServiceAccountnot found. Check the name again.[/b][/i]This account however does exist. If I attempt to shorten it to 20 characters (pre-Windows 2000 format) it works![code="sql"]USE [master]GOCREATE LOGIN [DOMAIN\MyLongerThan20Charac] FROM WINDOWS WITH DEFAULT_DATABASE=[master];GO[/code]Has anyone ran across this 20 character limitation before? I'm assuming there is a simple fix or configuration setting to correct this behavior but I'm hoping someone can chime in on what that is.Tue, 02 Apr 2013 11:11:29 GMTtafountain