Error when trying to create new Login user for SQL 2012

Question

I'm trying to follow the procedures described in this link here but if I enter IIS APPPOOL\AppPoolName as the login name (as in step 3) it throws an error saying that it is not a valid name because it contains invalid characters. I'm using SSMS for SQL 2012.

UPDATE: Just to clarify: The "Invalid character" error was b/c I was trying to enter the user on "SQL Server Authentication" when it must be "Windows Authentication".

Answer 1

I had the same problem when creating a Windows domain user in SSMS.

This solved it:

https://social.msdn.microsoft.com/Forums/en-US/8f084029-b0cf-4e7d-bb07-a11e31363660/tsd03072-xxxxxxx-is-not-a-valid-name-because-it-contains-invalid-characters?forum=vstsdb

Synopsis: The error message is misleading, the error case is that the for the situation where you have a Windows login and the (userName != loginName). The code does not take casing into consideration right now, so they have to be an exact match.

Answer 2

Ben answered his own question:

UPDATE: Just to clarify: The "Invalid character" error was b/c I was trying to enter the user on "SQL Server Authentication" when it must be "Windows Authentication".