sql 2008 express not listening on port 1433

Question

I installed sql 2008 express on 2008R2 but it is not listening on port 1433.

I check configuration for tcp and enabled that already. also started sql browser service.

any idea?

Answer 1

Hello,

Please check the SQL Server log file, at the beginning there is noted if the SQL Server is listening on TCP/IP protocoll and on which port.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

where is the log file?

I followed this exactly step by step but still doesnt want to listen on 1433. I cannot even login via sql studio express

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

Answer 3

I installed sql 2008 express on 2008R2 but it is not listening on port 1433.

I check configuration for tcp and enabled that already. also started sql browser service.

any idea?

by default SQL Server Express does not enable Remote Connections.

Could you check the following:

1) check that the SQL Express is running (SQL Server Configuration Tool)

2) log onto the box containing the SQL Server and try to connect with SSMS to the SQL Express instance. Try tcp/ip and/or shared memory to connect.
   if you can successfully login check that the SQL Server does allow Remote Connections

3) Firewall does not block incoming connections

4) does the DNS server name resolve to the correct ip address of the SQL Server ?

Answer 4

You can open the log from SSMS => Management => SQL Server Logs.

Or you can open it from Windows Explorer, it' as simple text file. You will find it in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 5

hi, the below link ma help you out.

http://support.microsoft.com/kb/823938

Answer 6

Solved it.  I went to Protocols for SQLExpress, IP Address and then at the very bottom, set IPALL to 1433.  Restart SQL service.  Whala.  What a pain but works now.