SEI: Error 27502. Could not connect to Microsoft SQL Server
Summary
When Installing the SEI Licnese Server we get the error, Error 27502. Could not connect to Microsoft SQL Server ‘SERVERNAME\X3’. [DBNETLIB]ConnectionOpen (Connect().SQL Server does not exist or access denied. (I7)
Resolution #1
Open port in Windows firewall for TCP Access
- Open Administrative Tools, Windows Firewall with Advanced Security console
- In the left pane of the console, select Inbound Rules
- Right-click select New Rule
- Select Port and click Next
- In the Protocol and Ports dialog box, select TCP.
- Select Specific Port Numbers and then type the port numbers: 1433, 1434
- Select Next until get to “Specify the name and Description of this Rule” screen
- Enter name for Inbound Rule (for instance SQL – TCP)
- Select Finish
Resolution #2
If the above does not resolve the issue follow the steps below to open access to SQL Server through Windows Dynamic Ports
Open Administrative Tools, Windows Firewall with Advanced Security console
- In the left pane of the console, select Inbound Rules
- Right-click select New Rule
- Select Program and click Next
- In the Program dialog box, select ‘This program path.’ Select Browse and navigate to Instance of SQL Server that you want to access through the firewall, and then click Open. (Example: C:\Program Files\Microsoft SQL Server\MSSQL11\Instance_Name\MSSQL\Binn\Sqlserv,exe)
- Select Next until get to “Specify the name and Description of this Rule” screen
- Enter name for Inbound Rule (for instance SQL – Dynamic)
- Select Finish