Directly Connected servers via Cross over LAN

[TalentedFool]

Hi all

I'm trying to setup a test case in my lab whereby I have one server on the network via normal LAN and another server with SQL 2000 loaded all working etc directly to the 1st server via a 2nd NIC and cross over cable.

I can see the 2nd server in explorer no problem but when I try to connect to the SQL server database it comes back with "SQL Server does not exists or access denied". I'm thinking that it's pushing the traffic down the other NIC rather than the direct connection NIC.

Or is there some setting I need in SQL on the direct server to open it up?

Cheers

~ Remember - Nothing is Fool Proof to a Talented Fool ~

 

[DrSql]

Here are few directions to troubleshoot.
Is the user trying to access server 2 have have enough login permissions.
Quick test

from Server A
Start==>run==> \\servername\c$\
If you can acess then you have to try to access the folder.
Also this Server part of same Domian or Work Group?
Ping servername
if you get a negative results verfiy your DNS.
I think both server are in two network, eventhought you have connected in one network.


Dr.Sql
Good Luck.

 

[mrdenny]

What are you IP settings for both nics on the LAN server, and for the NIC on the 2nd server?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[TalentedFool]

Thanks both

I checked the IP settings and me being a bit crazy at the end of the day yesterday. I gave them both (direct connected LAN's) an IP on the main network.

I've now taken them out of the subnet and onto their own subnet and everything works fine.



~ Remember - Nothing is Fool Proof to a Talented Fool ~