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.
ASKER
nope dont have it enabled
You can do this from another machine ?
Problem is only on that one machine ?
Problem is only on that one machine ?
ASKER
Just checked and this is the only machine with the issue.
Thanks,
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 ?
Can you ping the SQL Server on its IP address from that one machine ?
ASKER
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 ...
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 ...
something like:
sqlcmd -S 192.168.0.100 -U sa -P p@ssw0rd
Hope this helps ...
ASKER
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 ?
what does
ipconfig /all
return on both the SQL Server and troubled machine ?
ASKER
They are one the same network, same subnet, can ping.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very wierd, I did the sqlcmd -Lc and all the network sql servers showed up.. That works...
... :-)
Hope this helps ...