Remote Connection to SQL Express 2012

I know this has been asked before and I have tried the previous solutions and still have an issue.

I have installed SQL Express 2012 on a server which also has an instance of SQL Server 2005 and possibly an Express 2008 instance as well.

I can connect to the instance SERVERNAME\SQLEXPRESS locally, however am unable to connect remotely.

I have tried the following:
Enabled remote connections
Configured TCPIP to port 1434 (the 2005 instance has 1433)
Allowed TCP 1434 and 1433 incoming in the firewall on the SQL Server box
Started the SQL Server Browser
Tried both Windows Authentication and Standard logins
Tried to create an ODBC connection

Nothing has had any effect.  Please help!
SokellaAsked:
Who is Participating?
 
SokellaConnect With a Mentor Author Commented:
So it turns out that I missed the drop down to 'enable' TCPIP - had everything else right but not that.  Doh!
0
 
Éric MoreauSenior .Net ConsultantCommented:
by remote, do you mean from within a network (as opposed to through the Internet)?

have you tried shutting down the firewall for the time of your test? Also check http://msdn.microsoft.com/en-us/library/ms175043.aspx
0
 
SokellaAuthor Commented:
Remote within the network yes.

I haven't completely shut the firewall down.  Will try that.
0
 
SokellaConnect With a Mentor Author Commented:
Also had to add the port to the oledb connection using <instance name>,<port name>
0
 
SokellaAuthor Commented:
It wasn't a firewall issue
0
All Courses

From novice to tech pro — start learning today.