Prior to connecting the SQL Server Database, follow the platform specific instructions on whitelisting Periscope's IPs.
To connect to a SQL Server database, please ensure that Periscope can talk to the database over TCP. Periscope will check that the port is accessible through the firewall, that it responds to TCP, that Periscope can login, and that the server is accessible from Periscope.
These steps are modeled after Microsoft Azure's SQL Server guide, which offers even more information about securely connecting to a SQL Server database.
Windows Firewall with Advanced Security, in the left pane, right-click
Inbound Rules, and then click
New Rule in the action pane.
New Inbound Rule Wizard dialog box, under
Rule Type, select
Port, and then click
Protocol and Portsdialog, use the default
TCP. In the
Specific local portsbox, type the port number of the Database Engine (
1433for the default).
Actiondialog box, select
Allow the connection, and then click
Profiledialog box, select
Public, Private, and Domain. Then click
Namedialog box, type a name and description for this rule, and then click
SQL Server Configuration Managerand hit ENTER.
SQL Server Network Configuration.
Protocols for MSSQLSERVER(the default instance name.) In the details pane, right-click TCP, it should be Enabled for the gallery images by default. For custom images, click
Enable(if its status is Disabled.)
In the console pane, click
SQL Server Services. In the details pane, right-click
SQL Server (instance name) (the default instance is
SQL Server (MSSQLSERVER)), and then click
Restart, to stop and restart the instance of SQL Server.
To connect to the Database Engine from another computer, create at least one SQL Server authentication login.
Securityfolder, point to
New, and select
Login - New dialog box, on the
General page, enter the name of the new user in the
Login name box.
SQL Server authentication.
Passwordbox, enter a password for the new user. Enter that password again into the
Enforce password policy(recommended). This is a default option when SQL Server authentication is selected.
Default databaselist, select a default database for the login.
masteris the default for this option. If a user database has not yet been created, leave this set to
The SQL Server Database Engine cannot use Windows Authentication without domain environment. To connect to the Database Engine from Periscope, configure SQL Server for mixed mode authentication. Mixed mode authentication allows both SQL Server Authentication and Windows Authentication.
Security page, under
Server authentication, select
SQL Server and Windows Authentication mode, and then click
In Object Explorer, right-click the server, and then click
Restart. (If SQL Server Agent is running, it must also be restarted.)
Finally, follow the instructions on granting table permissions so that Periscope can query the tables.