[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot browse sql servers from PC anymore on domain

Posted on 2007-10-02
14
Medium Priority
?
214 Views
Last Modified: 2010-03-19
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.
0
Comment
Question by:mkurtzhals
  • 8
  • 6
14 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20002264
Windows firewall blocks your PC port 1433 ?

Hope this helps ...
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 20005999
nope dont have it enabled
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20008476
You can do this from another machine ?
Problem is only on that one machine ?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Author Comment

by:mkurtzhals
ID: 20142977
Just checked and this is the only machine with the issue.  

Thanks,
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20143055
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 ?
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 20171120
yes I can ping them.  Maybe another service is not running??
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20172637
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 ...
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20172647
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 ...
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 20228642
Yep I can connect via sqlcmd -S
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20228673
And what about the network questions ?
what does
    ipconfig /all
return on both the SQL Server and troubled machine ?
0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 20249681
They are one the same network, same subnet, can ping.
0
 
LVL 18

Accepted Solution

by:
Yveau earned 2000 total points
ID: 20256703
If you can connect using sqlcmd -S ... and you can ping the SQL Servers you are looking for ... I'm out of clues ...
Is there a SQL Server running on the machine as well ?
sqlcmd -Lc should report the instance running on the machine itself no matter what ...

... this is just a wild gues ... the SQL browser uses port 1434 by default ... maybe that port is needed for this functionality as well ... can you make sure this port is open on the network/firewall ... then again, it works on other machines ... Are all machines equiped with the same service pack ? You should be on 9.0.3054 ...

0
 
LVL 2

Author Comment

by:mkurtzhals
ID: 20264040
Very wierd, I did the sqlcmd -Lc and all the network sql servers showed up.. That works...
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20267811
... :-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Know the reasons and solutions to move/import EDB to New Exchange Server. Also, find out how to recover an Exchange .edb file and to restore the file back.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question