Create Sql Server RockUser Login - SparkDevNetwork/Rock GitHub Wiki

You will need to create a SQL Server Login called RockUser. You will need to use SQL Server Management Studio do to this (which would have been installed when you did the Install SQL Server step, or if you add the Management Tools feature to an existing SQL Server install.

On the Login Page, choose localhost for the server name and Windows Authentication for Authentication, then press Connect.

After logging in, in the Object Explorer window, navigate to localhost | Security | Logins. Next, right-click on Logins and click "New Login..."

On the Login - New page, put RockUser as the Login name and choose SQL Server authentication. For the password, copy and paste the password from your Web.ConnectionStrings.config (see Installing-rock-chms#step-3) file in your RockWeb directory. You'll also probably want to uncheck the "Enforce password" and "User must change password" checkboxes. Don't press OK yet, do the next step (Server Roles) first!

Now, while still on the Login - New page, select "Server Roles" and grant "dbcreater" and "public" as shown. Now you can press OK, and your SQL Server RockUser login is created.

Now, you probably already did this when you installed SQL Server, but you should really double-check that your SQL Server instance is setup for mixed-mode auth. To do that, in the Object Explorer window right-click on "localhost" and choose Properties.

Now select the "Security" page (on the left) and make sure Server authentication is set up as shown "SQL Server and Windows Authentication mode"), then press OK.