MetaFrame modifications for changing the SQL port

RoyATokeshi
February 26, 2004 9:48 pm

Citrix states in their article: CTX103325

CTX103325 - MetaFrame modifications for changing the SQL port

This document was published at: http://support.citrix.com/kb/entry.jspa?externalID=CTX103325

Document ID: CTX103325, Created on: Feb 11, 2004, Updated: Feb 13, 2004

Products: Citrix MetaFrame XP 1.0 for Microsoft Windows 2003, Citrix MetaFrame XP 1.0 for Microsoft Windows 2000, Citrix MetaFrame XP 1.0 for Microsoft NT 4.0 Server Terminal Server Edition

Question / How To

For heightend security, some organizations change the port that SQL uses to communicate. The default SQL port is 1433.

What needs to be done within a MetaFrame XP environment to ensure continual SQL communication if the SQL port is changed?

Resolution

The port the SQL driver uses to communicate is in the Mf20.dsn file. There are two ways to change the file to reflect the TCP port change:

• Run ODBC and configure the Mf20.dsn file located in Program Files\Citrix\Independent Management Architecture\ by default. Select Client Configuration in the wizard and change the TCP/IP port.

— or —

• Change the Mf20.dsn file. In a text editor, manually add a field “address” followed by the SQL by the SQL server name and the port number; for example: Address=HQSQL,2433.

Additional Information

Microsoft will support this.

See the following article in the Microsoft online knowledgebase for additional information: KB815146 – How to: Configure a .NET-Connected Application and SQL Server to Use an Alternate Port Number for Network Communications



Primary links

Custom Search

User login

Who's new

  • Cachleferah
  • Weedbacuupe
  • vororourn
  • vDonellaCandrah
  • SnnaSusi

Who's online

There are currently 0 users and 5 guests online.

KrissysCorner.com RuthSwensonLaw.com CreativeLizardProductions.com

DISCLAIMER:

None of this has anything to do with us, someone else is responsible for the entire thing, and we have no idea who or why. We do not know anything about it. It may be alien life forms for all we know: we haven't a clue. You cannot blame us for anything that may result from your visit. That was entirely your own personal choice, made by you of your own volition, and without our knowledge. We do not, after all, have any control over you and cannot by any stretch of the imagination be expected to accept or acknowledge, be it legally or morally, any accountability for decisions made by you on an independent basis, utilizing your own free will, and without our intervention. We are therefore in no way, shape, or form answerable to anyone for any consequences arising from the aforementioned or indeed any other actions, similar or otherwise, because it was not us that did, or did not do anything. It is not even remotely our fault, and we are in no way prepared or willing to accept any liability, not even slightly, ever. We are, in fact completely and utterly blameless, in that it is definitely not our concern, and no blame can possibly be laid at our doorstep, even if we had one, the possession of which we hereby reserve as being entirely our own free choice. The onus is not on us at all, and furthermore, never has been. The entire matter is wholly beyond our control, and completely out of our hands, each of which are washed scrupulously clean of the whole business. We are not accountable for anything at all, and we hereby categorically deny all responsibility for all that has ever, or will ever happen. Our innocence is therefore wholly beyond doubt and absolutely unimpeachable, and so cannot, under even the remotest or unlikeliest circumstances, be brought into question. By clicking either on a link on this site, clicking on a link that leads to this site, or by arriving at this site by natural or supernatural means, you are in effect accepting responsibility for the fact that it is all entirely your own fault, down to the most miniscule detail, and that you are wholly accountable for whatever outcome may arise as a consequence of the aforementioned action or actions insofar as they were undertaken personally by you on an entirely voluntary basis and without any persuasion, coercion or influence from any party or parties other than yourself. Don't come sniveling to us, we are only figments of your imagination. I also agree that if I am ever with a contributor to this website during mealtimes I agree to pay for any super-sizing of their meal, or at least a nice dessert or one of those foo-foo drinks with an umbrella or a monkey. By admitting to have seen the worthless spineless drivel on this website (also known as content)

I Agree Wholeheartedly and Without Reservation to the above. (Except maybe for that part about the monkey.)

All Your Base Are Belong To Us.

Soylent Green Is People!

Never make a bet with a Sicilian when Death is on the Line!

No. Really, I do agree.