December 20, 2006 at 2:06 pm
I have a question in reference to installing a second SQL instance on the same server. I installed it and it looks ok on the server except when you look at the server logs it appears to be listening on shared memory and named pipes. I did specify that it be installed using TCP/IP and specified a specific port number to be used that is different from the port # of the first instance. I do not see that port # anywhere in the logs. Another problem which I believe is related to the first one is that I cannot seem to connect to it and see it on the client machine. Does anyone have any ideas how to resolve this issue?
December 21, 2006 at 7:41 am
Hi Peter
Strange. I believe that the port you defined manually is in use by another application. Normally I define Port 1434 for a second named instance.
You should see the port in the log. Try to connect through EE directly on the server and to change the post. Further you can check if a second service for the instance is running. You can also perform a port scanning to verify, that the port you defined is not in use.
Best regards,
Moreno
December 21, 2006 at 8:45 am
On the server, open Enterprise Manager. Register the instance if you haven't already. Right click on the instance and select Properties. On the General tab, click on the Network Connection 'button'. Make sure TCP/IP is in the right window. Highlight it and click on Properties. That is where you check/change the port.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply