# SQL Gateway - The \`Service Name\` expected status was Running, but the actual status is Stopped

**URL:** <https://community.cdata.com/t/sql-gateway-the-service-name-expected-status-was-running-but-the-actual-status-is-stopped/432>\
**Category:** Editions\
**Tags:** article, sql-gateway, odbc, service\
**Created:** [October 4, 2023, 7:03pm UTC](https://community.cdata.com/t/sql-gateway-the-service-name-expected-status-was-running-but-the-actual-status-is-stopped/432 "2023-10-04T19:03:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Skerdian\_Shehaj](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/skerdian_shehaj/32/1243_2.png) [@Skerdian\_Shehaj](https://community.cdata.com/u/Skerdian_Shehaj)\
**Post date:** [October 4, 2023, 7:04pm UTC](https://community.cdata.com/t/sql-gateway-the-service-name-expected-status-was-running-but-the-actual-status-is-stopped/432/1 "2023-10-04T19:04:08Z")

</div>

The error message, _"The_ _Service Name_ _expected status was Running, but the actual status is Stopped",_ typically indicates that the SQL Gateway service is attempting to operate on a port that is already in use.

 ![a8638c69-37eb-426b-b649-57f1d6b990ba.png](https://us1.discourse-cdn.com/cdata/original/1X/1c55544b77677756c3582dd9f9eaad48e1689b6c.png)

 ![e74efbee-060b-4919-929a-a12ea5f1cdce.png](https://us1.discourse-cdn.com/cdata/original/2X/3/3e23564b2579a8e3e171e706ed1dea54adb435d0.png)

To ensure the availability of a port, you can execute the following command in the command prompt to identify the currently occupied ports:

_netstat -ano_

 ![fbd69783-d423-4c5c-9bf2-4745686654bd.png](https://us1.discourse-cdn.com/cdata/original/2X/b/badd3a8ec870c8b2f6601a74f202065d7ab446e9.png)

You can resolve this issue by changing the port to one that is not in use. I recommend trying with port numbers starting with values near the default port (which is 1433).

 ![3636ec3b-18fe-46f7-9aff-1c1938e9150b.png](https://us1.discourse-cdn.com/cdata/original/2X/3/3c1b841f1c1c7fa4a35890b2c56d8b777f70c4a3.png)

 ![e2a42a8e-5ec9-4a8e-9106-4744926c165e.png](https://us1.discourse-cdn.com/cdata/original/1X/51ff552733e5678c957d64f40c0a29ad5daeabc5.png)

If this solution does not resolve the problem, please do not hesitate to contact support at [support@cdata.com](mailto:support@cdata.com).