Skip to content
+1-888-319-3663

COMMUNITY FORUM

Initial SQL User

Chris asked 5 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.
 
Chris replied 5 years ago

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/

Answers
Patrick Roth Staff answered 5 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.
 

If you would like to submit an answer or comment, please sign in to the eOne portal.