Solved

Server 2008 SQLEXPRESS not listening of one workstation

Posted on 2014-11-25
5
178 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
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 500 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

932 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