Solved

Unable to connect to SQLExpress 08 R2 on Port 1433

Posted on 2013-06-27
6
285 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Contained Database Collations 6 28
t-sql splitting name column 5 40
Usage Scenarios for Extended Events? 1 25
SQL compatability in SQL 2016 2 31
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now