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

How to call job step X from job step Y:

I have a SQL Server Agent job with multiple steps. I want
to be able to goto a specific job steps by choice from a
step within the job. How do I make a acll to another step
from a job step.
For example, based on data returned in step 5, I could go
to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
good enough in the given scenario. I don't want to use
sp_start_job to start the job at a specific step because
the job is already running and I just want to set the
control-of-flow to a different step.
Thanks
Abdul Gill
DBA/Royal Caribbean Cruise LimitedHi Abdul
Job Step control does limit your options for controlling process flow, so
how about using a DTS package? DTS gives you easy control over process flow
& can be scheduled into a SQL Agent Job as well. The tools for implementing
complex processes are far more advanced in DTS, there's even a GUI to
support visualisation of the process logic..
Regards,
Greg Linwood
SQL Server MVP
"Abdul M. Gill" <agill@.rccl.com> wrote in message
news:1474e01c41381$3b8f6a20$a101280a@.phx
.gbl...
> I have a SQL Server Agent job with multiple steps. I want
> to be able to goto a specific job steps by choice from a
> step within the job. How do I make a acll to another step
> from a job step.
> For example, based on data returned in step 5, I could go
> to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
> good enough in the given scenario. I don't want to use
> sp_start_job to start the job at a specific step because
> the job is already running and I just want to set the
> control-of-flow to a different step.
> Thanks
> Abdul Gill
> DBA/Royal Caribbean Cruise Limited