• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

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?
0
styleteks
Asked:
styleteks
  • 4
  • 4
1 Solution
 
BrandonGalderisiCommented:
I will look ASAP but I have to ask the question... why do you need this?

:)
0
 
styleteksAuthor Commented:
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 #.
0
 
styleteksAuthor Commented:
Any luck?  Thanks in advance.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
BrandonGalderisiCommented:
I don't have MSDE to test this, and it says it's only std, dev and ent, but have you tried this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294453

0
 
styleteksAuthor Commented:
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.....
0
 
BrandonGalderisiCommented:
"perhaps" the shortcut just isn't created.  Can you see if you have the exe.

\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe

If you just have the engine, and no tools at all, you will need to install the tools in order to change it.
0
 
BrandonGalderisiCommented:
0
 
styleteksAuthor Commented:
It was in that pathway and did the trick.  I must have made a typo when searching for the file.  Thanks for your help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now