> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/troubleshooting/sql-server/invalid-server-settings.md).

# Invalid Server Settings

**YouTube:** [Invalid server settings error while login (SQL)](https://www.youtube.com/watch?v=GarNdIUICW0\&t=8s)

In this tutorial, we will guide you through resolving the **"Invalid Server Settings"** error that can occur while launching the Logic ERP software. This issue typically arises due to incorrect **SQL server details** like server name, username, or password.

***

### **Issue Overview**

* **Error:** *Invalid Server Settings*

<figure><img src="/files/8FJWgdp4RfMLBRpxx0IQ" alt=""><figcaption></figcaption></figure>

* **Cause:** Incorrect or missing SQL Server configuration such as:
  * Server name
  * Username
  * Password

***

### **Step-by-Step Solution**

**1. Test the SQL Connection**

* On the login screen, click **Test Connection** to verify connectivity with SQL Server.
* If the test fails, it indicates incorrect server details.

<figure><img src="/files/tQ7GuidQ1BvEcHmtBbQ0" alt=""><figcaption></figcaption></figure>

* Proceed to verify your SQL Server credentials.

***

**2. Check SQL Server Details in SSMS**

* Open the **Start Menu** and launch **SQL Server Management Studio (SSMS)**.
* In SSMS:
  * Confirm the **Server Name**

<figure><img src="/files/zuyUPSBBWYZswnzcoBvn" alt=""><figcaption></figcaption></figure>

* Click **Connect** to ensure SQL Server is accessible
* If successful, copy the exact server's name

***

**3. Retry Test Connection**

* Return to the Logic login/test screen
* **Paste** the correct server's name
* Enter the appropriate **Username** and **Password**

<figure><img src="/files/hx0pCsogxbxmFEOOaoBK" alt=""><figcaption></figcaption></figure>

* Click **Test Connection**

<figure><img src="/files/VbLaHb7ASD1uchSen2MS" alt=""><figcaption></figcaption></figure>

* If successful, click **OK** to proceed

***

**4. Save SQL Server Settings Permanently**

* Open **Logic Update Manager**
* Click on **Options**
* Because the earlier test failed, company Settings might be empty

<figure><img src="/files/6SjBp7ytLlPlPr16LpAr" alt=""><figcaption></figcaption></figure>

***

**5. Enter Database Details Manually**

* Locate and select the **source file** from the Logic installation folder
* Enter:
  * **Correct Server Name**
  * **Username**
  * **Password**

<figure><img src="/files/adOgtBVxoI141qDVgkJe" alt=""><figcaption></figcaption></figure>

* Click on **Save Settings**

***

**6. Wait for Connection to Establish**

* The software will take a few seconds to connect
* Once successful, the **list of companies** will appear

<figure><img src="/files/0mQCUaHYayaBJPLbrN9j" alt=""><figcaption></figcaption></figure>

* This confirms the server connection is now active

***

#### 7. **Log Into the Software**

* Save all configurations
* Try logging in to Logic ERP again
* The error should now be resolved

***

### **Still Not Working?**

* Double-check credentials and SQL Server service status
* If the issue persists, feel free to **raise a support ticket** for further assistance


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/troubleshooting/sql-server/invalid-server-settings.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.