patternsqlMajor
SQL Server is started but didn't listen on any port
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:
I got:
in which 5668 I think is the PID. And then to get PID = "5668" is listening to which port:
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
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.
tasklist|find /I "sql"I got:
sqlservr.exe 5668 Services 0 40,112 Kin 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
-
Check your configuration with
TCP connections on port 1433 was the following...- Configuration Tools / SQL Server Configuration Manager
- click the instance name in SQL Server Network Configuration
- enable
TCPcommunication
- Right-click the
TCPcommunication entry, chooseProperties
- Click the IP addresses tab
- Enable all non-VMnet IP addresses and enter 1433 in the
Portentry 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 LISTENINGCode Snippets
C:\>netstat -an | find "1433"
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP [::]:1433 [::]:0 LISTENINGContext
StackExchange Database Administrators Q#54767, answer score: 23
Revisions (0)
No revisions yet.