Solved

Server 2008 SQLEXPRESS not listening of one workstation

Posted on 2014-11-25
5
175 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
  • 3
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Mike
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
SQL driver versions
0
 

Author Closing Comment

by:FrankBabz
Comment Utility
Getting right driver was the fix...
Thanks...  Frank
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Let’s list some of the technologies that enable smooth teleworking. 
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now