Initial SQL User
Chris asked 6 years ago
Are there any instructions on how to create the initial SQL user for configuration? I’m getting an error trying to use a windows account and am unsure how to correctly set up an SQL user.
Answers
Patrick Roth Staff answered 6 years ago
Chris,
You shouldn’t need to set up an “initial SQL user”, the SmartConnect install will do that for you.
But yes, your SQL server does need to be set up to allow SQL Server authentication.
But you would have to have that because the SC install only allows SQL Server Auth and so in order to login to the install as “sa”, you’d have to have that set.
You shouldn’t need to set up an “initial SQL user”, the SmartConnect install will do that for you.
But yes, your SQL server does need to be set up to allow SQL Server authentication.
But you would have to have that because the SC install only allows SQL Server Auth and so in order to login to the install as “sa”, you’d have to have that set.
For anyone else, I found the issue on SQL server only allowing Windows Authentication: https://bjtechnews.org/2012/03/20/microsoft-sql-server-error-18456-login-failed-for-user/