Unable to connect to SQL database using MS Access. Getting data link error.


We have a Windows 2008 SBS which is hosting a SQL database. The database itself is running and can be accessed using a web browser from any of the networked workstations. For order processing our contracted database administrator created an MS Access file that can connect to the database so that information can be filtered for client orders. This file used to connect without issue and is no longer working.

I have attached a screen capture of the error that is received while attempting to connect to the database using MS Access. No passwords have change nor has anything on the server.

Any advice regarding this issue will be most appreciated.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Check if the SQL Server service and SQL Server Browser are running in the server machine. If not, start them and try again.
Spike99On-Site IT TechnicianCommented:
Are all users having  this issue on different computers or is it just a problem on one computer or with one user?

If it's just with one user, have you confirmed that the user account in question isn't locked out or have an expired password? Even though the user may be logged on to the PC, if the password has expired or if the account is locked out, the user will have issues connecting to online resources such as DBs, printers, shared drives, etc.
Poly11Author Commented:
Thank you for your responses. The services are running on the server and the problem is happening for all users on the network on different workstations.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Just two thoughts:
- check your TCP/IP connection (try to connect to port 1433 of your server):
telnet YOURSERVERIP 1433 

Open in new window

- check your server's firewall configuration (temporarily disable Windows firewall and check if MS Access client can connect)

You can find more information about connectivity troubleshooting in MS378845 article.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, MSSQL port can be blocked in the firewall. Please confirm that.
Poly11Author Commented:
Thank you for your responses. Port 1433 is open in the Windows FIrewall, however netstat -a does not show 1433 in the listing. When I try the telnet command it responds that it could not open the connection to the host.

With the firewall disabled and virus protection disabled the problem still continues. I checked the running services and do so SQL Server, SQL Server Agent, SQL Server Analysis Services, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services, SQL Server Reporting Services and SQL Server VSS Writer are running. There is 1 SQL service that is not running which is SQL Server Active Directory Helper.

Any other suggestions will be appreciated.

Thanks again
Try to telnet SERVERIP 1433 from that server. If it connects, it means that problem is on the LAN. Maybe somebody played with VLAN configuration on switches?

You said that you've tried to telnet from another station. Have you telneted with IP or Server name? Maybe something is wrong with DNS?

And check tracert SERVERIP - maybe something is wrong here?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Which user is defined for the SQL Server service account?
Poly11Author Commented:
Sorry for the delay. We found that the port was blocked.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.