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
t38Asked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
0
 
didnthaveanameCommented:
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...
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
t38Author Commented:
Thanks for your input, will check each of the above asap and report back..
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
 
t38Author Commented:
Thanks, in this instance the procedure outlined in the link resolved my problem.
0
All Courses

From novice to tech pro — start learning today.