Link to home
Start Free TrialLog in
Avatar of mkurtzhals
mkurtzhals

asked on

Cannot browse sql servers from PC anymore on domain

Cannot browse sql servers from PC anymore on domain.  I am running management studio and when I browse network for other servers it does not populate any.  Also I tried running sqlcmd -L from command prompt and cannot get any.  I checked all servcies and they are running.. Any ideas.
Avatar of Yveau
Yveau
Flag of Netherlands image

Windows firewall blocks your PC port 1433 ?

Hope this helps ...
Avatar of mkurtzhals
mkurtzhals

ASKER

nope dont have it enabled
You can do this from another machine ?
Problem is only on that one machine ?
Just checked and this is the only machine with the issue.  

Thanks,
something wrong with the NIC/IP address ? Is the machine still part of the domain ?
Can you ping the SQL Server on its IP address from that one machine ?
yes I can ping them.  Maybe another service is not running??
Is the machine in the same VLAN ? What about the IP addresses of the machine causing the headache and the server. Both IP addresses should look the same, except for the alst number. If a default subnet mask of 255.255.255.0 is valid at your site ...

Hope this helps ...
And if you can ping the machine, can you connet to it using its IP address ?
something like:
    sqlcmd -S 192.168.0.100 -U sa -P p@ssw0rd

Hope this helps ...
Yep I can connect via sqlcmd -S
And what about the network questions ?
what does
    ipconfig /all
return on both the SQL Server and troubled machine ?
They are one the same network, same subnet, can ping.
ASKER CERTIFIED SOLUTION
Avatar of Yveau
Yveau
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Very wierd, I did the sqlcmd -Lc and all the network sql servers showed up.. That works...
... :-)