Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • 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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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