Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How to run tsql in sql server 2000?

Author  Topic 

aex
Yak Posting Veteran

60 Posts

Posted - 2006-06-14 : 06:15:27
I want to run tsql from the sql server 2005 in another sql server 2000 (in other machine). When I attempt to connect, the error message shows that the sql server does not allow remote connection. I have already enabled remote connection in sql server 2000 and already created a login. But I still fail to connect to sql server 2000 from sql server 2005 using the login.

Any solution for this? Thanks for any reply.

aex
   

- Advertisement -