Run the SQL Server Database Script

Run the Create Database Script

To run the “Create Database Script”, we recommend using SQL Server Management Studio.

*If you do not have SQL Server Management Studio installed, Please email support@lightningtools.com and we can provide this step as a service to you.

1. Open SQL Server Management Studio
2. When prompted, enter the SQL Server Name, authentication type, User ID, and Password that you configured when creating the SQL Server Database.

If you do not know the Fully Qualified Server Name, Username and Password, they can be found by:

1. Navigate to All Resources within the Azure Portal.
2. Scroll down and click on the SQL Server Database that you created in the previous step.
3. The Connection String is available which will display your user id. The Server name is shown above the connection string as highlighted in the below screenshot.

!You may need to create a firewall rule to allow your client machines IP address to access the SQL Server. The steps to configure the Firewall Rule can be found here: SQL Server Firewall Rule

1. Click Connect to connect to the SQL Server.
2. Click New Query to create a new SQL Query
3. Paste the Create SQL Create Database Script into the Query Window which we obtained in the previous step: Download Database Script
4. Ensure that the Social Squared SQL Server Database is selected.
5. Click Execute

Create Database Script