Registration Problem

[yogesphu]

Hi

I am facing problem while registering a server on my local system.

We have an SQL SERVER 2005 on Windows server 2003 machine and the port is dynamic (say 1078). i am able to register the server on my local machine without any problem.

Now we have prepared one more SQL SERVER 2005 but this time on Windows server 2008 with the same dynamic port.

i am not able to register this server on my local machine.

I am getting following error message:

TITLE: New Server Registration
------------------------------

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 121)

For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I am sure about all the logins and passwords!!

is there any different option we need to choose or sth when we install SQL Server 2005 on windows server 2008 machine???

We are using TCPIP for connectivity!!
And the port mentioned above is open from my system!!

Please suggest

[rmiao]

Is sql port open on win2k8? Sql server browser service is running?

[yogesphu]

Yes, The port is open and SQL Browser service is running

[rmiao]

You used named pipes protocol, tried with tcp/ip one?

[yogesphu]

On my server named pipes are disabled for both server and client configuration. TCPIP is enabled.

During registration also i tried by changning network protocol in connection properties to TCPIP.

AND GOT THE ERROR AS BELOW::::


TITLE: New Server Registration
------------------------------

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------



CAN IT BE SOMETHING WITH WIN 2K8???

[rmiao]

What did you put in server name?

[yogesphu]

I tried ip address as well as server name. nothing worked!!!
My server name is same as sql instance name!!!

[rmiao]

Is port 1434 open on win2k8 and on network?

[yogesphu]

No it is not!!!

The port we are using is 1280!!!
and that is open on win 2k8 m/c!!

we have similar setup for win2k3 m/c with 1280 port(1434 is not open on even this win2k3 m/c) and that i am able to register without any problem!!!!

[rmiao]

When instance uses dynamic port, sql will tell client which port is used via 1434. If 1434 is not open, you have to connect with port number like instance_name,1280 or ip_address,1280.

[yogesphu]

U are awesome!!!
It worked!!!
Thanks a Lot

[rmiao]

Happy SQLing!