Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

8 other pcs are connected through DSN, but.. Expand / Collapse
Author
Message
Posted Friday, October 05, 2012 1:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2012 8:16 AM
Points: 16, Visits: 20
I have 8 pcs that are working off of the sql 2008 server, but have another pc that connecting on and off, a laptop that won't connect and a DC that won't connect through a dsn connection. Any ideas? Error message attached.

Thanks


  Post Attachments 
sqlerror.png (15 views, 29.99 KB)
Post #1369290
Posted Friday, October 05, 2012 2:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:07 AM
Points: 42, Visits: 392
Does it happen right after you restart your sql service?
download sqlcon32.exe , it's good tool to test ODBC connectivity. Post the results.
Post #1369303
Posted Monday, October 08, 2012 6:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2012 8:16 AM
Points: 16, Visits: 20
EvilDba (10/5/2012)
Does it happen right after you restart your sql service?
download sqlcon32.exe , it's good tool to test ODBC connectivity. Post the results.


I figured out what another tech did... It didn't make since that's why I didn't check the firewall. However, he setup the connections to only public and not domain. Everyone and the servers are on a domain. I don't know what he was thinking. Thanks for the help
Post #1369756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse