sql 2008 express connection problems

Question

I've just installed a fresh copy of SQL 2008 Express. before I did anything I opened Management Studio and successfully connected using Window Authentication.

However I tried to run the following on the command line "telnet localhost 1433" and got the error "Could not open connection to the host, on port 1433: Connect failed"

I checked netstat and there is nothing listening on port 1433.

Before I go any further, is there a problem with the install?

thanks, Shane

Fred · Accepted Answer · 2009-12-16 17:15:03Z

2

did you check if the tcp/ip protocol is enabled? It's disabled by default if I remember correctly.

answered Dec 16, 2009 at 17:15

Fred

1,2343 gold badges11 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ShaneH Over a year ago

it was disabled, so I enabled it and started the SQL browser service, still no change

Fred Over a year ago

check this, msdn.microsoft.com/en-us/library/ms177440.aspx by default it's using dynamic ports for sql server instance.

ram · Accepted Answer · 2009-12-16 17:17:20Z

1

are you telling your SQL Server to listen on TCP/IP

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

answered Dec 16, 2009 at 17:17

ram

11.7k16 gold badges67 silver badges89 bronze badges

1 Comment

ShaneH Over a year ago

this link referred to sql 2005 express, I found this, linglom.com/2009/03/28/… the instructions were more-or-less the same. I followed them but I am still getting the same problem

justin w · Accepted Answer · 2010-05-08 02:30:23Z

0

The port number isn't guaranteed to be 1433.

In Sql Server Configuration Manager, make sure: (1) SQL Server is running (2) SQL Server Browser is running. (3) In the Protocols for SQLEXPRESS that TCP/IP is on. You can check the port inside there.

Alternately get the port by finding the PID of sqlservr.exe in Task Manager and then typing: netstat -ano | findstr PID

Prior to these steps I couldn't connect via 127.0.0.1 myself, now I can connect even from a remote machine on my LAN. (Note: for LAN access you'll need to add firewall exceptions for sqlservr.exe and sqlbrowser.exe)

answered May 8, 2010 at 2:30

justin w

6231 gold badge6 silver badges6 bronze badges

Collectives™ on Stack Overflow

sql 2008 express connection problems

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related