CODEWITHSUNDEEP
databasesql-server-2008-express
ShaneH
ShaneH

Reputation: 385

sql 2008 express connection problems

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

Upvotes: 1

Views: 1656

Answers (3)

justin w
justin w

Reputation: 623

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)

Upvotes: 0

ram
ram

Reputation: 11626

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

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

Upvotes: 1

Fred
Fred

Reputation: 1234

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

Upvotes: 2

Related Questions