Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error Setting Up ODBC Connection

Posted on 2016-07-22
2
Medium Priority
?
66 Views
Last Modified: 2016-07-22
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
Comment
Question by:itgolfer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
Eric C earned 2000 total points
ID: 41725216
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
 

Author Comment

by:itgolfer
ID: 41725225
Thank you, Eric. I allowed 1433 on the server's Windows firewall and I'm now able to setup the ODBC connection.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

664 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