July 2, 2010 at 5:39 am
I have set up SQL Server 2008 (64-bit) on a Windows Server Standard 2008 64 bit machine.
This machine has dual NIC's, NIC 'a' get's it's IP address from a DHCP server (the address is reserved so it won't change), and NIC 'b' has a static address set.
The NIC's use different subnets, and connect to different routers to go out via different ISP's.
I can do an ODBC connection fine to NIC 'a', but when I try to do an ODBC connection to NIC 'b', I get the following error...
Connection failed:
SQL State '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen
(Connect())
Connection failed:
SQL State '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.
I've turned Windows firewall off, and checked the firewall log on router 'b' - it shows the packets on port 1433 being passed through to the PC.
How can I get the SQL server to respond to connections from NIC 'b'?
July 2, 2010 at 5:46 am
...extra information I forgot to add....
If I disable NIC 'a', then I can connect using NIC 'b'. But as soon as NIC 'a' is re-enabled, I can no longer connect over NIC 'b'.
hopefully this helps........
July 7, 2010 at 7:32 am
Update....
I've fixed it - I set NIC 'a' with a static IP and subnet, then left the gateway and dns fields blank.
This was after I read an article about how SQL server goes to the default gateway, so I thought I would only give it one gateway.....
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply