Connection to remote database

This forum focus on project portfolio risk management theory and RiskyProject Enterprise software. Submit any questions about enterprise risk management, and qualitative / quantitative risk analysis for multiple projects. This forum also includes discussions about project risk analysis on the enterprise level.

Moderator: Intaver Support

Post Reply
KerryMiller
Posts: 23
Joined: Tue Dec 18, 2007 3:39 pm
Location: USA, MI

Connection to remote database

Post by KerryMiller » Fri Jan 12, 2018 6:05 pm

How to connect RiskyProject Enterprise to remote database?
Project Engineer

Intaver Support
Posts: 992
Joined: Wed Nov 09, 2005 9:55 am

Re: Connection to remote database

Post by Intaver Support » Fri Jan 12, 2018 6:16 pm

1. On the server Start Microsoft SQL Server Management Studio
2. Right click on the server and select the Properties option.
3. In the Server Properties dialog under the Connections tab check the Allow remote connections to this server option:

Image

4. Go to Start->Programs->Microsoft SQL Server 2005/2008/… ->Configuration Tools and select the SQL Server Configuration Manager
5. Under the SQL Server Network Configuration select Protocols for <your server name>:

Image

Make sure that TCP/IP protocol is enabled and right click on TCP/IP and select the Properties option. In the TCP/IP Properties dialog select the IP Addresses tab and scroll down to IPAII. If the TCP Dynamic Ports dialog box contains 0, which indicates that the Database Engine is listening on dynamic ports, delete the 0 and set the TCP Dynamic Ports to blank and TCP Port to 1433. Port 1433 is the default instance that SQL Server uses:

Image

6. When you click the OK button you will be prompted with a message to restart the service. In the left pane of SQL Server Configuration Manager click SQL Server Services, right-click SQL Server<instance_name>, and click Restart:

Image

7. You also need to configure a Windows Firewall for Database Engine Access. To add a firewall exception for the 1433 port go to Programs -> Administrative Tools select the Windows Firewall with Advanced Security option.
8. In the Windows Firewall with Advanced Security dialog click on the Inbound Rules option and select the New Rule command:

Image

9. In the New Inbound Rule wizard select the Port option and click Next
10. In the Protocols and Ports window specify the protocols and ports to which a rule applies. Select the TCP option, in the Specific local ports text box enter the 1433 port, and click Next.
11. In the Action window select the Allow the connection to specify the action to be taken when a connection matches the conditions specified in the rule.
12. Specify the profiles for which the rule applies in the Profile window, and click Next. You can now see the created rule in the list of inbound rules.
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Post Reply