Share via

SQL SERVER Confisuration manager can't change TCP/IP option

DefautlyBoi 96 Reputation points
2021-06-22T14:39:34.3+00:00

I am trying to connect a JDBC connection to SQL Server, and uppon digging it appears that I need to enable the option "TCP/IP" in the "SQL Server Network Configuration" section of the program Sql Server Configuration Manager. What was unexpected to me was that the dropdown has no options for either enable or disable, it is just a blank dropdown and I can not enter my own text.

I have already tried running the config manager as admin, and it is a locally ran database so I should be the owner of the said database.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,149 questions
0 comments
Accepted answer
  1. DefautlyBoi 96 Reputation points
    2021-06-22T16:17:51.58+00:00

    The issue was I was running the executable found inside of System32, however I needed to run the exe found inside of C:\Windows\SysWOW64

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 26,201 Reputation points
    2021-06-22T16:08:36.36+00:00

    Hi @DefautlyBoi ,

    Please check that you are trying to do it like on the screen shot below.

    108255-screenshot-2021-06-22-120649.png

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.