Failed to register instance from Windows 2003 server

Hi,
We have a Windows 2000 server (domain server) as suport for our database,
with two instances of SQL Server 2000 (one sensitive and one insensitive) and
decided to move the sensitive instance on a Windows 2003 server.
When I try to make the registration of the instance from Windows 2003
Server on Enterprise Manager from Windows 2000 Server it fail with time out
message.
I need to make a link server on instance from Windows 2000 but it seems
Windows 2003 has a security setting that stop me from doing this.
Any idea would be appreciated."You may not be able to connect to an instance of SQL Server 2000 Service
Pack 2 or earlier that is installed on a Windows Server 2003 computer
through the TCP/IP port"
http://support.microsoft.com/default.aspx?scid=kb;en-us;884012
Cristian Lefter, SQL Server MVP
"Traian" <Traian@.discussions.microsoft.com> wrote in message
news:EB5D2A03-5282-472C-A7C2-4A16FE38F964@.microsoft.com...
> Hi,
> We have a Windows 2000 server (domain server) as suport for our database,
> with two instances of SQL Server 2000 (one sensitive and one insensitive)
> and
> decided to move the sensitive instance on a Windows 2003 server.
> When I try to make the registration of the instance from Windows 2003
> Server on Enterprise Manager from Windows 2000 Server it fail with time
> out
> message.
> I need to make a link server on instance from Windows 2000 but it seems
> Windows 2003 has a security setting that stop me from doing this.
> Any idea would be appreciated.
>|||Thank you, but on both systems SQL Server instances are with Service Pack 3
installed. Windows 2000 server is with Service Pack 4 installed.
"Cristian Lefter" wrote:
> "You may not be able to connect to an instance of SQL Server 2000 Service
> Pack 2 or earlier that is installed on a Windows Server 2003 computer
> through the TCP/IP port"
> http://support.microsoft.com/default.aspx?scid=kb;en-us;884012
> Cristian Lefter, SQL Server MVP
> "Traian" <Traian@.discussions.microsoft.com> wrote in message
> news:EB5D2A03-5282-472C-A7C2-4A16FE38F964@.microsoft.com...
> > Hi,
> > We have a Windows 2000 server (domain server) as suport for our database,
> > with two instances of SQL Server 2000 (one sensitive and one insensitive)
> > and
> > decided to move the sensitive instance on a Windows 2003 server.
> > When I try to make the registration of the instance from Windows 2003
> > Server on Enterprise Manager from Windows 2000 Server it fail with time
> > out
> > message.
> > I need to make a link server on instance from Windows 2000 but it seems
> > Windows 2003 has a security setting that stop me from doing this.
> >
> > Any idea would be appreciated.
> >
>
>|||By default when you install win2k3 all network connections are firewalled so
I think you must enable tcp port 1433 in your firewall.
Right click on LAN connection, chose properties then chose advanced tab, on
services tab click add button and Write name and description of service,
chose Tcp, and put 1433 in both textboxes.
Regards,
Daniel
"Traian" <Traian@.discussions.microsoft.com> wrote in message
news:EB5D2A03-5282-472C-A7C2-4A16FE38F964@.microsoft.com...
> Hi,
> We have a Windows 2000 server (domain server) as suport for our database,
> with two instances of SQL Server 2000 (one sensitive and one insensitive)
and
> decided to move the sensitive instance on a Windows 2003 server.
> When I try to make the registration of the instance from Windows 2003
> Server on Enterprise Manager from Windows 2000 Server it fail with time
out
> message.
> I need to make a link server on instance from Windows 2000 but it seems
> Windows 2003 has a security setting that stop me from doing this.
> Any idea would be appreciated.
>|||Thank you, I'll try your tip. I didn't do this because the firewall option
was unchecked. But it could be active some other way.
"Daniel Joskovski" wrote:
> By default when you install win2k3 all network connections are firewalled so
> I think you must enable tcp port 1433 in your firewall.
> Right click on LAN connection, chose properties then chose advanced tab, on
> services tab click add button and Write name and description of service,
> chose Tcp, and put 1433 in both textboxes.
> Regards,
> Daniel
> "Traian" <Traian@.discussions.microsoft.com> wrote in message
> news:EB5D2A03-5282-472C-A7C2-4A16FE38F964@.microsoft.com...
> > Hi,
> > We have a Windows 2000 server (domain server) as suport for our database,
> > with two instances of SQL Server 2000 (one sensitive and one insensitive)
> and
> > decided to move the sensitive instance on a Windows 2003 server.
> > When I try to make the registration of the instance from Windows 2003
> > Server on Enterprise Manager from Windows 2000 Server it fail with time
> out
> > message.
> > I need to make a link server on instance from Windows 2000 but it seems
> > Windows 2003 has a security setting that stop me from doing this.
> >
> > Any idea would be appreciated.
> >
>
>