Skip to content
logo Knowledgebase

Error: "Error 27502. Could not connect to Microsoft SQL Server. [DBNETLIB]{ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (17)"

Created on  | Last modified on 

Resolution

 CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that arise from changes to these settings. Ensure you back up all system and application databases necessary for a complete restoration. It's advisable to contact a certified consultant or your system administrator for assistance.
CAUTION: This solution needs advanced Operating System knowledge. Consult your system administrator for help. Sage isn't liable for issues caused by improper changes to the Windows Registry. Always back up your data before applying advanced solutions.

1. Open port in Windows firewall for TCP Access

  1. Open Administrative Tools, Windows Firewall with Advanced Security console
  2. In the left pane of the console, select Inbound Rules
  3. Right-click select New Rule
  4. Select Port and click Next
  5. In the Protocol and Ports dialog box, select TCP.
  6. Select Specific Port Numbers and then type the port numbers: 1433, 1434
  7. Select Next until get to 'Specify the name and Description of this Rule" screen
  8. Enter name for Inbound Rule (for instance SQL - TCP)
  9. Select Finish

2. Open port in Windows firewall for UDP Access 

  1. Open Administrative Tools, Windows Firewall with Advanced Security console
  2. In the left pane of the console, select Inbound Rules
  3. Right-click select New Rule
  4. Select Port and click Next
  5. In the Protocol and Ports dialog box, select UDP.
  6. Select Specific Port Numbers and then type the port numbers: 1434 
  7. Select Next until get to 'Specify the name and Description of this Rule" screen
  8. Enter name for Inbound Rule (for instance SQL - UDP)
  9. Select Finish
  10. Try installing Sage 100 Premium again

 

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

  1. In the left pane of the console, select Inbound Rules
  2. Right-click select New Rule
  3. Select Program and click Next
  4. In the Program dialog box, select 'This program path.' Select Browse and navigate to Instance of SQL Server that you want to access through firewall, and then click Open. (Example: C:\Program Files\Microsoft SQL Server\MSSQL11\Instance_Name\MSSQL\Binn\Sqlserv,exe) 
  5. Select Next until get to 'Specify the name and Description of this Rule" screen
  6. Enter name for Inbound Rule (for instance SQL - Dynamic)
  7. Select Finish