Solved

Unable to connect to SQLExpress 08 R2 on Port 1433

Posted on 2013-06-27
6
286 Views
Last Modified: 2013-07-08
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
0
Comment
Question by:t38
6 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 39281947
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39281955
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39282141
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:t38
ID: 39283727
Thanks for your input, will check each of the above asap and report back..
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39283743
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
 

Author Closing Comment

by:t38
ID: 39307744
Thanks, in this instance the procedure outlined in the link resolved my problem.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question