?
Solved

Server 2008 SQLEXPRESS not listening of one workstation

Posted on 2014-11-25
5
Medium Priority
?
198 Views
Last Modified: 2014-11-29
I have 5 workstations and 4 are working properly (two are Vista Ultimate and 2 are Windows 7 Pro) to run an ACCDE program on my “TED” server 2008 R2.

 Workstation #5 is “TIM” Vista Ultimate and is only one not working.   On TIM and using SYSWOW\Odbcte32.exe to test the connection I enter TED\SQLESPRESS and it fails (as if Server not listening) because if I change to add port as follows: TED\SQLEXPRESS, 1433 it will connect.  As ACCDE (is DSNLess) and uses only TED\SQLEXPRESS I would like all 5 to work the same.  

Following suggestions in article re: listening problems ….  In Windows Firewall on TIM  I added a custom inbound rule to add the IP address of my server “TED” to allow this connection.  That did not help.  I also blindly added MSACCESS.EXE outbound rule, but that did not help either.

Anybody have any ideas???   Thanks….
0
Comment
Question by:FrankBabz
[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
  • 3
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Mike
ID: 40466290
Have you tried disabling the firewall on TIM completely and testing again to see if that helps, if nothing else it would confirm the firewall to be the problem. You could also do the same on TED to rule out the firewall on that blocking connections from TIM. I am not suggesting you leave the firewall disabled, just do it as a quick test.
0
 

Author Comment

by:FrankBabz
ID: 40467245
Per your suggestion Mike...  I was very surprised to find that turning off both firewalls had no effect.  I was convinced it was a firewall issue...   Why, is because I have this same ACCDE working on four other PCs of which 2 are an identical Vista OS...  AND because all 3 matching PCs include the same User Account "JOE" that works on 2 and that should eliminate possible account issues on TED.

I did a quick check on "Joe" permissions on other PCs and they all appear to be the same.  Although.. understanding necessary permissions is not my strong suit.   I can (I think) also focus less on MSACCESS.EXE on TIM because Odbcte32.exe on TIM does not connect w/o me adding the listening port, and BTW adding listening port on other PCs is not needed.  I've been thinking ODBC should not matter because all SQLEXPRESS I/O in the ACCDE is DSNless.  Maybe TIM's ODBC does play some role in this?

Thanks your thoughts....  Frank
0
 
LVL 2

Accepted Solution

by:
Mike earned 2000 total points
ID: 40467281
Do you have a native sql driver installed on the other PCs that you don't on the one that isn't working? You can check this when you add a new data source in odbcad32.
0
 
LVL 2

Expert Comment

by:Mike
ID: 40467288
SQL driver versions
0
 

Author Closing Comment

by:FrankBabz
ID: 40471856
Getting right driver was the fix...
Thanks...  Frank
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses

770 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