Linked Server Lock up on : MS-SQL Server 2000(SP3a) + Windows Server 2003 STD

Linked Server Lock up on : MS-SQL Server 2000(SP3a) + Windows Server 2003 STD

Post by Manit » Thu, 05 Aug 2004 16:36:20


Dear All,

I needed someone help, here is the problem:

[1] I have another Windows 2000 Server Std+SP4, running MS-SQL 2000 Std +
SP3a

[2] I did the clean installation my new server using Windows Server 2003 Std
with MS-SQL 2000 Std + SP3a, joining a domain with normal TCP/IP configure
with no simple_firewall.

During an MS-SQL installation I got only the warning screen informed that
its version is not compatible with Windows 2003 and everying runs fine
including SP3a upgrade patch.

Everything runs fine accepted...

Normally we use the linked server to link up both server,
before we got no problem since [Server2.] was a Windows 2000+MS-SQL
SP3a.

But it hangs up when any machine click on any resources under the linked
server name
(using SQL Server Enterprise Manager)

Please help, Thanks
/Manit I.