Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

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!
0
Sokella
Asked:
Sokella
  • 4
2 Solutions
 
É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
 
SokellaAuthor Commented:
So it turns out that I missed the drop down to 'enable' TCPIP - had everything else right but not that.  Doh!
0
 
SokellaAuthor 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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now