# 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FhlvOOhMqWNjnAeBwLJN0%2FInvalid%20Server%20Setting.png?alt=media&#x26;token=44e87553-cc3e-438b-8f88-da48fbbcc3b2" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FpMAfXZgghTmuM7zmmQ88%2FTest%20Connection%20Failed.png?alt=media&#x26;token=3ac47364-c9f8-4fd4-8938-2837a84c438b" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FXE6fM6YUTcsn9QR20g1U%2FSQL%20Server%20Name.png?alt=media&#x26;token=469ce723-9cf4-479d-9f53-d228d5770d6f" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FRQvRB9CYBO52FgdY7rDm%2FServer%20Name.png?alt=media&#x26;token=7d3fb2c8-4c25-4238-8bc1-c4d843f122ac" alt=""><figcaption></figcaption></figure>

* Click **Test Connection**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FArLKZxk50ijFyHOEYFxl%2FTest%20Connection%20Successfull.png?alt=media&#x26;token=7dd0abca-9b71-43d3-a388-44dc1868e970" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FXjUnYPNE2fFxJxOPWe5k%2FLogic%20Updation%20Service.png?alt=media&#x26;token=9e42e259-75d2-4ee4-a1ba-efeb9e57b88e" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FtjBfobr0wI3fkhktbT8w%2FManual%20Database%20Settings.png?alt=media&#x26;token=8dcc25bf-25b9-4f18-9469-e16beb87c9a5" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FsOIiLAPTgyxejIBOFjbF%2FCompany%20List.png?alt=media&#x26;token=246ff313-b597-4271-a3c2-0716fa2f600d" 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