October 11, 2014 at 1:07 pm
CREATE LOGIN [DOMAIN\SERVERHOSTNAME$] FROM WINDOWS
Error Windows NT user or group 'DOMAIN\SERVERHOSTNAME$' not found.
October 11, 2014 at 1:34 pm
alexrjordan (10/11/2014)
CREATE LOGIN [DOMAIN\SERVERHOSTNAME$] FROM WINDOWSError Windows NT user or group 'DOMAIN\SERVERHOSTNAME$' not found.
That is not an issue with the dollar sign it means SQL Server cannot find that login within Active Directory either by permission or the login actually does not exist.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 11, 2014 at 9:28 pm
I created 2 other dollar sign ($) logins with no problems. Any other ways of adding login without doing a Active Directory check?
October 11, 2014 at 9:32 pm
alexrjordan (10/11/2014)
I created 2 other dollar sign ($) logins with no problems. Any other ways of adding login without doing a Active Directory check?
Not that I am aware of, however what good will that do if SQL Server cannot validate the login it will never authenticate it and allow access to the instance.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply