2 sql servers SS2K and SS2K5 on same server windows 2003

Question

2 sql servers SS2K and SS2K5 on same server windows 2003

forsqlserver

SSCoach

Points: 18902
More actions
June 3, 2009 at 3:45 am

#103751

Dear All,
I have 2 sql servers SS2K and SS2K5 on same server windows 2003.I have problem with SS2k
SS2k5:It is working on port 1433.It is default.
SS2k:It has named instance.In server n/w utility the port for tcp/ip is 4042.If I have changed it to 1433 then query analyzer ,profiler nothing is connecting.In client n/w utility the tcp port is set as 1433.
Question1: I am not understanding why my ss2k server has 4042 port in server n/w utility.
Question2: I am not able to attach linked server from ss2k5 to ss2k I am getting error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
OLE DB provider "SQLNCLI" for linked server "AJAYG\AJAYG2000" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "AJAYG\AJAYG2000" returned message "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.". (Microsoft SQL Server, Error: 65535)
Please do the needful
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Each instance must have it's own port number. You cannot use port 1433 for both.

By default the default instance uses port 1433 and named instances use a dynamic portnumber, which can change whenever the instance is restarted.

If you need to use a fixed port number you can configure this for SQL 2000 in the server network utility. But as said before it must be a different on as for the other instance.

[font="Verdana"]Markus Bohse[/font]

Kruti Kansara Hall of Fame Points: 3118 More actions · Answer 2

Question2: I am not able to attach linked server from ss2k5 to ss2k I am getting error:

I doubt if this is possible. I was having the same problem when i was using SS2K as my client and SS2K5 as server; but didnt try any solution as i switch to SS2K5.

Are you really need to have both server on the same machine?

"Don't limit your challenges, challenge your limits"

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

kruti (6/3/2009)
Question2: I am not able to attach linked server from ss2k5 to ss2k I am getting error:
I doubt if this is possible. I was having the same problem when i was using SS2K as my client and SS2K5 as server; but didnt try any solution as i switch to SS2K5.
Are you really need to have both server on the same machine?

Yes, that is possible. I've done lots of times.

One common problem is described in this KB article

http://support.microsoft.com/?id=906954

[font="Verdana"]Markus Bohse[/font]

Kruti Kansara Hall of Fame Points: 3118 More actions · Answer 4

Thanks Markus...

as i told earlier, i had left to try to solve my problem as i switched to SS2K5; but i would like to apply this solution now. Though, i dont hv any instance of SS2K with me right now, but will arrange soon.

Thanks again..

"Don't limit your challenges, challenge your limits"