Re: BizTalk SQL port change

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nick Malik (nickmalik_at_hotmail.nospam.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 14:41:55 GMT

Having not been in this precise position before, I can offer "similar"
advice and hope it helps.

While working on a client-server app a couple of years ago, the IT
department decided to change the port for SQL. Our clients didn't have a
setting for the port and the connection string didn't have one either. The
trick we used was to install SQL Tools on the client machine, and open up a
tool called the Client Configuration Tool. That allowed us to specify the
preferred method of communication for ANY SQL Server client on that machine
(including our little VB apps). We chose TCP/IP and set the port. All
worked.

You may need to do the same on your Biztalk server.

I have NO idea if this is all you need, but it was all we needed in that
other situation.
I hope this information is helpful.

--- Nick

"jeremy wollard" <anonymous@discussions.microsoft.com> wrote in message
news:F1DF8C4A-D034-4CAC-89CC-11EEB6C6326A@microsoft.com...
> Our SQL group is changing the port in which SQL server currently uses from
1434 to 1350. Does anyone know the potential impact to BizTalk? Will the
BizTalk service only need to be stopped and restarted after the port change?
I have searched the registry on only saw one incidence of the port being
referenced, but that appeared to be from SQL enterprise manager making an
initial connection to the SQL database.
>
> Any input would be appreciated.
> Jeremy

Relevant Pages

  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)
  • RE: ensure port is free upon failover
    ... You can create alias for Sql server instance name on client PC. ... obtain the necessary TCP port number. ...
    (microsoft.public.sqlserver.clustering)
  • =?ISO-8859-15?Q?Re=3A_Keine_SQL-Serverregistrierung_ausser?= =?ISO-8859-15?Q?hal
    ... > dieser stellt eine kurzzeitige Verbindung auf den Socket mit Port 1433 des ... z.B. Firewall, SQL Server ist nicht auf Port 1433 gebunden, die ... D.h. Server und Client müssen ...
    (microsoft.public.de.sqlserver)
  • Re: Verbindung zu SQL Server Express 2005 klappt nicht
    ... ich habe jetzt bei dem SQL Server die Protokollnamen Shared Memory, ... Named Pipes, TCP/IP aktiviert, das gleiche auf dem Client. ... Druckerfreigabe, TCP Port 1433, UDP Port 1434. ...
    (microsoft.public.de.sqlserver)
  • Re: thin client com ports
    ... I'm glad that you got at least one more client working! ... MCSE, CCEA, Microsoft MVP - Terminal Server ... the COM port settings? ... I am testing several thin clients. ...
    (microsoft.public.windows.terminal_services)