Hi Warren


Thanks for the response.
Actually, the connection side things are fine with all servers and see
eachother.

We use SP3 for SQL 2000 with build 818. And, we use both authintications.
One of our work station we did import all SQL 2000 servers in SQL 2005
client by using this option. No idea, why this time I'm getting error.

Regards

Sam G




"Warren Brunk" <wbrunk@techintsolutions.com> wrote in message
news:eHcZoTf1GHA.3516@TK2MSFTNGP06.phx.gbl...
> What service pack are your SQL 2000 databases?
>
> Have you checked all the standard things like:
> - am I using a trusted or standard connection?
> - does my SQL 2000 allow standard connections or is it NT auth only?
> - is my current windows account a trusted login on my SQL 2000 box?
> - can I ping the SQL 2000 box from here?
> - does DNS resolve the name to the right IP address?
> - is the SQL Server service currently running on my SQL 2000 box?
> - can I connect to my SQL 2000 box from any other machine?
> - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe or
> SQLEM or QA)?
> - what network protocols is my SQL 2000 box listening on?
> - what protocol am I trying to use when attempting a connection to it?
>
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
> */
>
>
> "Sam G" <anonyomous@discussions.microsoft.com> wrote in message
> news:Ou6efse1GHA.4388@TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>>
>> When I'm trying to register my SQL 2000 servers into my SQL 2005 Client,
>> then I'l getting this error.
>>
>> "Failed to import servers registered by SQL Server 2000"
>>
>>
>> Anyone knows about it???
>>
>>
>> Thanks in advance!
>>
>> Sam G
>>
>>
>
>