HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

SQL Server is started but didn't listen on any port

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
didnstartedsqllistenbutanyportserver

Problem

I newly installed SQL Server 2012. No database created yet. And I can open the Management Studio with sa/password. The Binn\sqlservr.exe is started as a service and I can see it started in the service list. However, it didn't listening the 1433 port, or even, not listening any port by default, as I checked as below:

tasklist|find /I "sql"


I got:

sqlservr.exe                  5668 Services                   0     40,112 K


in which 5668 I think is the PID. And then to get PID = "5668" is listening to which port:

netstat -ano | find /I "5668"


but I got nothing except blank. On the other hand, after searching posts in this site, I double-checked my SQL Server's configuration: start->All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> SQL Server Configuration Manager-> SQL Server SQL Native Client 11.0 Configuration -> Client Protocols -> TCP/IP ->Default Port 1433. There're 3 services, SQL Server(MyInstanceName), SQL Server Agent(MyInstanceName) and SQL Server Browser. The last two is stopped.

SQL Server Configuration Manager-> SQL Server Network Configuration->Protocols for MyInstanceName -> TCP/IP is disabled by default, after I enabled it and restart the service and repeat the netstat -ano | find /I "newPIDNum" command I found the

TCP    0.0.0.0:52395          0.0.0.0:0              LISTENING  5668(newPIDNum)


Why 52395 instead of 1433? And I failed to create the DSN using Windows ODBC Data Source administrator which returns me an error: specified SQL server not found.
Any help for me? Thanks.

Solution

What made my SQL server listen for TCP connections on port 1433 was the following...

  • Configuration Tools / SQL Server Configuration Manager



  • click the instance name in SQL Server Network Configuration



  • enable TCP communication



  • Right-click the TCP communication entry, choose Properties



  • Click the IP addresses tab



  • Enable all non-VMnet IP addresses and enter 1433 in the Port entry for "IPAll".



  • Restart the SQL Server on SQL Server Services tab



-
Check your configuration with netstat -an:

C:\>netstat -an | find "1433"
  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
  TCP    [::]:1433              [::]:0                 LISTENING

Code Snippets

C:\>netstat -an | find "1433"
  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
  TCP    [::]:1433              [::]:0                 LISTENING

Context

StackExchange Database Administrators Q#54767, answer score: 23

Revisions (0)

No revisions yet.