Create failed for Login SQL Server authentication
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit MohantyPosted Oct 31, 2023, 1:17 PM
Hey Naresh, are you trying to create empty login?
If we run above in the SSMS query window, we get above error message. Because login is created as [] and error clearly says that “[] are not allowed”. If we provide name, then the issue will be resolved.
For more info check the below link:
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=sql-server-2017