Set SQL Security Settings and Database Default Location

Set the Security Setting of the SQL Server to Mixed Mode.

1. In SQL Server Management Studio, right-click the server and select Properties.
2. In the Server Properties window, in the Select Page list, select Security and then select the SQL Server and Windows Authentication mode option.

Set the Database File Location 

Set the database location to point to the folders you created in the server folder hierarchy.

1. In SQL Server Management Studio, right-click the server and select Properties.
2. In the Server Properties window, in the Select Page list, select Database Settings. 
3. Under Database Default Locations, enter the path for the appropriate Data and Log folders on the server.

Note: The path should be the location of the SQLData folder. It could be your D: or E: drive depending on the structure of your server.

4. Save your changes, enter the server password, restart the local services, and connect.

5. Enable CLR. Run the script to avoid receiving an error stating, “Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.” Copy and paste the code below into SQL Management Studio and execute:

EXEC sp_configure 'show advanced options' , '1';

go

reconfigure;

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure;

-- Turn advanced options back off

EXEC sp_configure 'show advanced options' , '1';

Go