8 other pcs are connected through DSN, but..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » 8 other pcs are connected through DSN, but..

8 other pcs are connected through DSN, but..

Rate Topic

Display Mode

Topic Options

Author

Message

54.69.6d.20

Posted Friday, October 05, 2012 1:32 PM

Grasshopper

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

iaminyourhead

Posted Friday, October 05, 2012 2:26 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 1:51 PM
Points: 28, Visits: 309

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

54.69.6d.20

Posted Monday, October 08, 2012 6:11 AM

Grasshopper

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 »

Permissions