Improve company productivity with a Business Account.Sign Up

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

Error Setting Up ODBC Connection

I have a new SQL 2012 install and I'm trying to setup an ODBC connection to it. I am unable to connect to it on a number of PCs so I don't believe it's PC related. I type in the data source and server name and enter the sa credentials and then it tells me that the SQL server does not exist or access denied. I can ping the SQL server successfully so I know I have a connection to it, I'm just not sure what's blocking it. Any suggestions?
0
itgolfer
Asked:
itgolfer
1 Solution
 
Eric CIT Director / Project ManagerCommented:
two things to check:

1. make sure sql server is configured to allow remote connections (in SSMS, right-click on the server and go to properties, then click on 'connections')

2. make sure the appropriate ports (1433, possibly others) are open on the firewall
0
 
itgolferAuthor Commented:
Thank you, Eric. I allowed 1433 on the server's Windows firewall and I'm now able to setup the ODBC connection.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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