Create failed for user sa Microsoft SQLserver smo error 15405 can be resolved with this fix by our experts. 

At Bobcares, we offer solutions for every query, big and small, as a part of our SQL  Server Support Services.

Let’s take a look at how our SQL Server Support Team is ready to help customers with Create failed for user sa error 15405 error.

Create failed for user sa Microsoft SQLserver smo error 15405

As the error message indicates, Error 15405 prevents creating explicit DB users for user sa. Here, sa is the System Administrator, with unlimited permission in SQL Server. Since we do not assign any extra permissions to user sa, resulting in the error 15405 messages.

Fortunately, our SQL Server experts have come up with an easy resolution for this specific issue. It involves ensuring that the user responsible for updating the database has at least dbowner permission on the MS SQL Server or instance.

Additionally, the Create failed for user sa Microsoft SQLserver smo error 15405 error is often a result of a user without sufficient privileges attempting to upgrade the relevant tables in the database.

Furthermore, if we are not sure whether the user currently updating the database has sufficient privileges, we can log in with Windows authentication mode and ensure that sa authentication is enabled in the server to avoid Create failed for user sa error 15405 error.

We can do this by right-clicking the Server in the SQL Server Management Studio and navigating to Properties > Security> and selecting SQL Server and Windows Authentication mode.

Then click OK and enable the sa login with the following steps:

1. Head to Security section on your server and then select Logins.
2. Then, right-click sa and select Properties.
3. Next, head to Status and choose Enabled under Login and click Ok.

After that, restart SQL and we are ready to go. We will no longer come across Create failed for user sa error 15405 error.

[Need assistance with a different issue? We are available 24/7.]

Conclusion

In a nutshell, our skilled SQL Server Support Engineers at Bobcares demonstrated how to resolve Error 15405.