asked on

Unable to connect to SQLExpress 08 R2 on Port 1433

Hi,
As per the title, I've installed the s/w on a Windows 08 Server (firewall on same disabled) but can't connect to it.
I'm not very familiar with SQLExpress so would appreciate some advice on how to troubleshoot.
Thanks

ASKER CERTIFIED SOLUTION

Paul Jackson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

didnthaveaname

Also, make sure you're specifying the SQLEXPRESS instance (which is the default instance name, unless you changed it during the install), so it would be servername\SQLEXPRESS (which, will not be on the 1433 port). If you open SQL Server Configuration Manager (which I think should still install in express), and go to SQL Server Network Configuration > Protocols for instanceName > Right click TCP/IP > go to properties > IP Addresses tab > and look for the TCP port in there. Named instances default to dynamic ports, also, so you may want to use the instanceName or change the port to a static value here as well. If it's not that, I would try to connect locally on the server and see if you can successfully do that

Edited: to add some additional information...

Dave Baldwin

To connect to an 'instance name', you need to have the 'sqlbrowser.exe' service running on port 1434. If you have SQLEXPRESS configuration setup for remote access with TCP/IP, you also need the port defined in the setup to connect directly with an IP address. I have both things set up on my installations so I can connect by name or IP address.

t38

ASKER

Thanks for your input, will check each of the above asap and report back..

Dave Baldwin

Also on other machines, you may need to have the SQL Native Client installed and TCP/IP enabled in it too. SQL Native Client is installed with the server on that machine.

t38

ASKER

Thanks, in this instance the procedure outlined in the link resolved my problem.