use psinfo tools ...

1) install it on your local box or laptop on C:\

2) now in CMD line

c:> psinfo \\serveryouneedinformation -d

😉 simple...

I had same issue , SSMS 2008 was not connecting to SQL 2000 server (Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) failed with server not found...

Hi

Did you try installing SP4 for 2005 . See if that can help.

Hi

We love the way you reply for all issues , but can you give little bit more details , I show you all posts , all are shorts...