Errors:
‘Error message “-2147217900” incorrect syntax near the keyword FOR. Error occurred in routine createuser.’
‘Error message “-2147217900” incorrect syntax near ‘xxxx’. Error occurred in routine addSqlServerMemberToRole.’
‘Error message “-2147217900” incorrect syntax near ‘xxxx’.Error occurred in routine grantAlterLoginAlterUserAlterRole’
If you're getting an error message when creating a user in Admin tools, it's usually caused by the data being added to the fields.
Here are some things to look out for:
Numbers in letter fields.
Spaces in fields.
📌 Note: Only an admin can create users for the database.