styleteks
asked on
MSDE Listen on Multiple Ports?
Greetings,
I have an instance of MSDE that I'd like to have listen on multiple ports. Currently it listens on 1433, but I owuld also like for it to listen on another port.
I understand that using the SQL Server Network Utility can provide the ability to allow for additional listening ports. However, I do not see that MSDE comes with this utility.
Any suggestions?
I have an instance of MSDE that I'd like to have listen on multiple ports. Currently it listens on 1433, but I owuld also like for it to listen on another port.
I understand that using the SQL Server Network Utility can provide the ability to allow for additional listening ports. However, I do not see that MSDE comes with this utility.
Any suggestions?
ASKER
We have a new application that must speak with the existing instance of SQL, but can only do so on a port other than 1433. We do not wish to change the listening port of 1433, since the other existing client applications do not allow changing the port #.
ASKER
Any luck? Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did, but the issue is that MSDE does not include the SQL Server Client Network Utility. I'm wondering if that is included in SQL Tools? Maybe, I can install SQL Tools and gain access to the utility.....
"perhaps" the shortcut just isn't created. Can you see if you have the exe.
\Program Files\Microsoft SQL Server\80\Tools\Binn\svrne tcn.exe
If you just have the engine, and no tools at all, you will need to install the tools in order to change it.
\Program Files\Microsoft SQL Server\80\Tools\Binn\svrne
If you just have the engine, and no tools at all, you will need to install the tools in order to change it.
ASKER
It was in that pathway and did the trick. I must have made a typo when searching for the file. Thanks for your help.
:)