Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't see second sql2000 any idea ?

Status
Not open for further replies.

tdong

Programmer
Mar 12, 2004
112
CA
Hi
We have two server running two different sql2000 server. Everyone log into domain1 can see the sql2000server1 but they can't see the sql2000server2 at all. in the server1 for enterprise manager I can add the sql2000server2 no problem and register it active directory. I can see it on my local but today no it kinda work and then doesn't work. Remove from active directory of server1 (everyone loginto this domain) and add it back sometime it works again sometimes no. Right now it doesn't work. I can ping etc and have access to sql2000 server2 from server2 but not from workstations which loginto server1
 
Are the two servers in the same domain? If not, what kind of domains do you have, Windows NT, Windows 2000 native or Windows 2000 mixed?

If so, have you checked the Event Logs on machine that can't connect to the second machine and on the second machine itself for service problems? What kind of network set up do you have? Are the machines both on the same side of the hub\switch or different sides of the hub\switch?

Have you verified the SQL Server error logs also?

The obvious answer is that this is a network issue rather than a SQL Server issue. Of course, obvious isn't always the correct answer, but if you haven't checked all possible log files yet, that would be the first place to start.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
 
both server2003.the server1 ip is 192.168.68.2 and the server2 192.168.68.3 and they are trusted server they are on two different domain but in the same network. my workstation can log into both and can see both on the network. They are on the same switch. Event log show no error. I have share files on both server and I can access both
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top