ArticlesArticles Most Popular ArticlesMost Popular Articles
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon 2019 Official Holidays & Support Schedule
DrillDown Icon IMPORTANT: End of Life of SHA1 on Windows Server 2003
DrillDown Icon IMPORTANT: Supported Operating Systems
DrillDown Icon PLEASE READ: Our Update Server IPs Have Changed
DrillDown Icon Support
DrillDown Icon modusGate for Microsoft Azure
DrillDown Icon modusCloud
DrillDown Icon Alleviating Spam – Best Practices
DrillDown Icon directQuarantine Technical Information
DrillDown Icon modusMail & modusGate Technical Information
DrillDown Icon Documentation & Release Information
DrillDown Icon Known Issues (non-release related)
DrillDown Icon Configuration Information
DrillDown Icon modusGate & modusMail
DrillDown Icon modusGate Only
DrillDown Icon modusMail Only
DrillDown Icon SQL Server Information
DrillDown Icon How-To: Enable Full Text Indexing for SQL Server Express
DrillDown Icon Known Issue: SQL Server Express Setup Problems on Windows 2000 Server
DrillDown Icon Info: Extended Database Format for ModusMail
DrillDown Icon How-To: Configure the SieveStore Database in SQL Server
DrillDown Icon How-To: Use SQL Server Instead of the Built-in MDB Database for Quarantine storage
DrillDown Icon How-to: Prevent Quarantine-Related Problems
DrillDown Icon How-To: Configure SQL TCP stack
DrillDown Icon How-To: Move SQL database from one server to another
DrillDown Icon MySQL Information
DrillDown Icon Security
DrillDown Icon Sieve
DrillDown Icon Spam and False-Positives
DrillDown Icon Statistics and Monitoring Section
DrillDown Icon Web Components
DrillDown Icon Troubleshooting
DrillDown Icon Hardware & OS System Requirements
DrillDown Icon Tools
DrillDown Icon Other Product Technical Information
DrillDown Icon Professional Services
DrillDown Icon Newsletters
  Email This ArticlePrint PreviewPrint Current Article/Category and All Sub-Articles/Categories
 
How-To: Configure SQL TCP stack
 

Product: All

Version & Build: All 

 

 

Symptoms:

 

At times Modus WebAdmin would fail to authenticate due to a connection or TCP stack error with the SQL server. The SQL TCP stack needs to reflect the information of the local server network configuration.  

 

 

Procedure:

 

Here are the steps to ensure the SQL TCP stack is configured correctly:


     1- For Windows server 2008R2 and lower, Open configuration manager under START - PROGRAMS - MICROSOFT SQL SERVER 20xx - CONFIGURATION TOOLS - SQL SERVER CONFIGURATION MANAGER.

  •  For Windows server 2012R2 and higher, On the desktop Right-Click on the start button and select SEARCH, in the search field type "SQL SERVER CONFIGURATION MANAGER"
  • Then from the list Right-Click on your select and choose "Run as Administrator on the list.

     2- In the SQL Configuration Manager expand the following SQL Server Network Configuration menu and Right-Click on TCP/IP and select properties.

     3- In the TCP/IP Properties page select the IP addresses tab and ensure that all the IP addresses listed represent the same local IP addresses of the server and ensure all interfaces are Active and Enabled.



     4- Once that is done restart SQL express agent so that the changes will take effect.



 
Modified 9/28/2015
Keywords: SQL TCP Stack
Article ID: 1900