I'm getting:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/qam/MasterDocumentationList.asp, line 98

Which is pretty much the same error I'm getting when i was trying to make a DSN connection. So this doesn't make sense. Like I mentioned, i have 14 other pcs connected to server2. For what I understand, 64bit and 32bit machines should be able to talk. Server1 is the DC and it's trusted and can ping\connect to it.

Could it be a firewall issue? Last week had some issues with a few pcs connecting to server2. 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...

LOL... Thanks for the help again. I figured i'd check that firewall again. I found by default is was to block everything on inbound connections (domain profile) in the windows firewall properties (of course unless specified). <<< Shaking head... trying to figure out what the other IT guy was doing with his time. Certainly knowing or learning how to setup servers!

Love this site.. My not get the answer, but gives me a chance to bounce ideas so I can find the right answer. PLUS.. people actually respond in a good amount of time 🙂