I have a not every day situation with my network.
I have windows server 2008 (small business premium) and network 192.168.1.x. All the machines (desktop users) have windows xp pro and are working with no problems on this relation (server-desktop) when joined in domain.
I also have a router (zyxel) on this network which uses the same gateway as my desktop users. His job is only to establish VPN connection to another network.
So his WAN port is related to network 192.168.1.x and his LAN port creates a seperated network 192.168.6.x. I created this network for some other users and they use own DHCP.
So on this network I have one user which is conected over VPN with some private network (uses Remote desktop to connect to other server and apps) and also uses resourses on network 192.168.1.x (where my windows 2008 SBS is located).
The problem is that everyting worked great when I had Windows 2000 advance server. Now when we changed it with 2008 this client cant joint DOMAIN any more. The problem is that the computer cant find it. The router has setting to let NETBIOS broadcast over the network and that worked fine before. There was also a WINS DHCP setting on router pointing to old server and I corrected it to new IP. Doesnt help.
The old server had WINS so I also instaled it on 2008. Didnt help.
I created LMHOST entries on desktop machine...i can ping it now to correct IP but still cant join domain.
I tried maping network drive over IP and I can use "domainname/user and password" and I can map it. But this isnt enough because I also need access to SQL server which is on 2008 and I guess he doesnt work this way and needs me to join the domain so he gives me access.
What can I do?
Any other ways to join domain?
Any other ways to try to connect to SQL server? (MySQL for example gives you access also over TCP/IP with correct user/pass)