Showing posts with label pro. Show all posts
Showing posts with label pro. Show all posts

Friday, March 23, 2012

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-f5bf
01890640.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,
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
Server\MSSQL. 1\MSSQLServer\SuperSocketNetLib\Tcp\IPAl
l]
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-f5
bf01890640.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/defaul...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,
|
| & #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
| Server\MSSQL. 1\MSSQLServer\SuperSocketNetLib\Tcp\IPAl
l]
|
| 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
Posted by towerghjb at 3:30 AM 0 comments
Labels: , , , , , , , , , , , ,

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
Posted by towerghjb at 3:30 AM 0 comments
Labels: , , , , , , , , , ,
Subscribe to: Posts (Atom)