I have quite a strange issue at hand :0 ok so heres the information before i throw the problem at you
this is a meduim enteprise with about 30 computers and 2 servers ( one for SQL one for AD + Exchange ) all computers run windows XP and one runs Windows 7.
So the issue is that with the windows 7 machine (64bit) we cannot map a network drive to the sql server if we use its name then it says windows cant access "sqlserver" but if we use the ip address it works perfectly.
the SQL server ( runs windows sbs 2011) can map a drive to the pc using its name.
We have added a static dns entry on the dns server and set the primary dns server for the windows 7 machine to the dns server ( AD server ).
All other computers have no issues what so ever.