How to change Default port in MS SQL server (2005) and Use it with Pro* C

Hi,
My application is using Pro* c to connect MS SQL SERVER. Now i want
to change default port for SQL SERVER. How can i do that? and does this
make any impact on my Pro*c application connection?(there's no
parameter for PORT in Pro*c connect statement). How can i configure for
this? Please reply.I'm Using MS SQL SERVER 2005. Please specify whether i need any
Registry editing for that.
Thanks in Advance
Umesh|||These may help.
http://support.microsoft.com/kb/823938/
and in BOL;
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2276a5ed-ae3f-4855-96d8-f5bf01890640.htm
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
<umeshcg@.gmail.com> wrote:
| Hi,
|
| My application is using Pro* c to connect MS SQL SERVER. Now i want
| to change default port for SQL SERVER. How can i do that? and does this
| make any impact on my Pro*c application connection?(there's no
| parameter for PORT in Pro*c connect statement). How can i configure for
| this? Please reply.
||||Dear Dave,
Thanks for ur reply. But i'm facing a peculiar problem when i
change tcp port of SQL server 2005.
I have changed the default port of 1433 to 1844 through "SQL SERVER
CONFIGURATION MANAGER" and it is visible in registry too As,
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll]
Display Name = Any IP Address
TcpDynamicPorts=[Blank]
TcpPort=1844
Then i restarted the service. when i tried to netstat it does
not show 1844 port. Then i checked errorLOG(both Manually and through
Query) it says:
"Server is listening on [ 127.0.0.1 <ipv4> 1434]"
and its true too. i can see it when i connect with telnet
localhost 1434. How can ii solve this? one more thing.. how can i
enable SQL SERVER 2005 for remote connection? Default is disabled.
Please Reply.
Thanks in Advance,
Umesh.C.G
Dave Patrick wrote:
> These may help.
> http://support.microsoft.com/kb/823938/
> and in BOL;
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2276a5ed-ae3f-4855-96d8-f5bf01890640.htm
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> <umeshcg@.gmail.com> wrote:
> | Hi,
> |
> | My application is using Pro* c to connect MS SQL SERVER. Now i want
> | to change default port for SQL SERVER. How can i do that? and does this
> | make any impact on my Pro*c application connection?(there's no
> | parameter for PORT in Pro*c connect statement). How can i configure for
> | this? Please reply.
> ||||It works for me. Be sure the dynamic port is blank for IP1, IP2, IPAll
Before;
Starting portqry.exe -n 127.0.0.1 -e 1433 -p TCP ...
Querying target system called:
127.0.0.1
Attempting to resolve IP address to a name...
IP address resolved to localhost
querying...
TCP port 1433 (ms-sql-s service): LISTENING
portqry.exe -n 127.0.0.1 -e 1433 -p TCP exits with return code 0x00000000.
----
Starting portqry.exe -n 127.0.0.1 -e 1966 -p TCP ...
Querying target system called:
127.0.0.1
Attempting to resolve IP address to a name...
IP address resolved to localhost
querying...
TCP port 1966 (unknown service): NOT LISTENING
portqry.exe -n 127.0.0.1 -e 1966 -p TCP exits with return code 0x00000001.
----
After;
Starting portqry.exe -n 127.0.0.1 -e 1966 -p TCP ...
Querying target system called:
127.0.0.1
Attempting to resolve IP address to a name...
IP address resolved to localhost
querying...
TCP port 1966 (unknown service): LISTENING
portqry.exe -n 127.0.0.1 -e 1966 -p TCP exits with return code 0x00000000.
Also this article may help.
http://support.microsoft.com/default.aspx?scid=kb;[LN];914277
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"invy" wrote:
| Dear Dave,
| Thanks for ur reply. But i'm facing a peculiar problem when i
| change tcp port of SQL server 2005.
|
| I have changed the default port of 1433 to 1844 through "SQL SERVER
| CONFIGURATION MANAGER" and it is visible in registry too As,
|
| [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
| Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll]
|
| Display Name = Any IP Address
| TcpDynamicPorts=[Blank]
| TcpPort=1844
|
| Then i restarted the service. when i tried to netstat it does
| not show 1844 port. Then i checked errorLOG(both Manually and through
| Query) it says:
|
| "Server is listening on [ 127.0.0.1 <ipv4> 1434]"
|
| and its true too. i can see it when i connect with telnet
| localhost 1434. How can ii solve this? one more thing.. how can i
| enable SQL SERVER 2005 for remote connection? Default is disabled.
| Please Reply.
|
|
| Thanks in Advance,
| Umesh.C.G