<div>
Check if the SQL Server service and SQL Server Browser are running in the server machine. If not, start them and try again.
</div>


<div>
Are all users having &nbsp;this issue on different computers or is it just a problem on one computer or with one user?<br />
<br />
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.
</div>


<div>
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.
</div>


<div>
Just two thoughts:<br />
- check your TCP/IP connection (try to connect to port 1433 of your server):<br />

<pre><code class="code-1 nolinks" id="code-20-41444184-1"><span>telnet YOURSERVERIP 1433 </span>
</code></pre>
- check your server's firewall configuration (temporarily disable Windows firewall and check if MS Access client can connect)<br />
<br />
You can find more information about connectivity troubleshooting in <a href="https://msdn.microsoft.com/en-us/library/ms378845(v=sql.110).aspx" rel="ugc">MS378845</a> article.
</div>


<div>
Yes, MSSQL port can be blocked in the firewall. Please confirm that.
</div>


<div>
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.<br />
<br />
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.<br />
<br />
Any other suggestions will be appreciated.<br />
<br />
Thanks again
</div>


<div>
Which user is defined for the SQL Server service account?
</div>


<div>
Sorry for the delay. We found that the port was blocked.
</div>


<div>
<div class="content wysiwyg-content">
Greetings.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Any advice regarding this issue will be most appreciated.<br />
<br />
Thanks<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w06/1079016/EE-DB-Error-1.jpg" target="_blank" class="file-inline" title="EE-DB-Error-1.jpg (261 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>EE-DB-Error-1.jpg</a>
</div>
</div>


EE-DB-Error-1.jpg

Greetings.

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.

Thanks

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.