|
|
|
|
problem about register a remote sql server
hello
my pc is in LAN , os: win2000 server sp4 ,sql server:sql server2000 sp3
remote pc : win2000 server sp4 ,sql server 2000 sp3
I can connect to remote sql server using osql. when I register the remote
sql server by enterprise manager .the error occur :
connectionread{recv{}} general network error
I capture the packet and find :
the TDS language command:
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
return the "sa", that's ok.but the next command :
if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec
master.dbo.sp_MSSQLDMO80_version else if (object_id
('master.dbo.sp_MSSQLDMO70_version') is not null) exec
master.dbo.sp_MSSQLDMO70_version else select 0
no response
anthor pc in the same LAN can register the remote sql server successfully.
what's the problem ? how to resolve it?
thanks and sorry for my poor english.
Wed, 12 Jan 2005 11:04:49 +0800
"creek"
|
|