How to change the default port number

hai all,
I need to change the default port number of the SQL server from 1433 to some other port number. i know that it can be done thru SERVER NETWORK UTILITY. Can some one confirm that. It will be helpful.
Also i want to make sure that port to given is free port. how can i find that particular port is free.

Thanking in Advance, awaiting Quick response.

Signing Off
Venkatesh.VYes, SERVER NETWORK UTILITY can do it.
U can make a program to test if the port is not be used.sql

How to change port number of mssql2000?

Hi,
May I ask how to change the default listening port of MSSQL2000?
ThanksHi,
From SQL server program groups, select "Server network utility". Click TCPIP
and select properties to change port number. After changing the port stop
and start MSSQL server service.
Thanks
Hari
MCDBA
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Hi -
Please refer to KB Article
http://support.microsoft.com/defaul...kb;EN-US;815146
Thanks
-Surajit
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Enabled Protocols and Tom
As long as you are using TCP/IP You can change the port number by using the
SQL Server network utility.
You need to be logged on to the server where SQL server is running. Click s
tart, then programs, then Microsoft SQL server, then server network utility
(not client network utility). Choose the instance you want to change. High
light TCP/IP from enabled p
roperties and click on properties. You can change the port number there.
Hope this helps
Johnsql

How to change port number of mssql2000?

Hi,
May I ask how to change the default listening port of MSSQL2000?
ThanksHi,
From SQL server program groups, select "Server network utility". Click TCPIP
and select properties to change port number. After changing the port stop
and start MSSQL server service.
Thanks
Hari
MCDBA
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Hi -
Please refer to KB Article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;815146
Thanks
-Surajit
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Enabled Protocols and Tom
As long as you are using TCP/IP You can change the port number by using the SQL Server network utility.
You need to be logged on to the server where SQL server is running. Click start, then programs, then Microsoft SQL server, then server network utility (not client network utility). Choose the instance you want to change. Highlight TCP/IP from enabled properties and click on properties. You can change the port number there.
Hope this helps
John

How to change port number of mssql2000?

Hi,
May I ask how to change the default listening port of MSSQL2000?
Thanks
Hi,
From SQL server program groups, select "Server network utility". Click TCPIP
and select properties to change port number. After changing the port stop
and start MSSQL server service.
Thanks
Hari
MCDBA
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks
|||Hi -
Please refer to KB Article
http://support.microsoft.com/default...b;EN-US;815146
Thanks
-Surajit
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks
|||Enabled Protocols and Tom
As long as you are using TCP/IP You can change the port number by using the SQL Server network utility.
You need to be logged on to the server where SQL server is running. Click start, then programs, then Microsoft SQL server, then server network utility (not client network utility). Choose the instance you want to change. Highlight TCP/IP from enabled p
roperties and click on properties. You can change the port number there.
Hope this helps
John

How to change db schema name in DSV?

We have number of cubes which built under ‘abc’ database schema, but recently database schema has changed to ‘xyz’ (table names still are same), so every dimension tables, fact table need delete not change when refresh in DSV (BI Studio SQL server2005). If delete tables in DSV, means rebuild dimensions, and cube in the BI Studio. Is there a way to change schema name in DSV instead of rebuild cube from scratch?

Thanks in advance for advice.

Hello!

Open your DVS and select xml source and directly replace DbSchemaName="abc" with DbSchemaName="xyz".

Hth,

Radim
|||Great! It works.

Thank you so much Radim.
sql

How to capture Error Messages in script

I know how to capture the error number using @.@.ERROR, but I don't know how
to capture the actual text. It is easy to do so via an application that uses
a database driver (BDE, ADO .NET etc...), but I just want to capture the
error text in SQL script and log it to a table.
Please Note:
'select description from master.dbo.sysmessages' alone is not sufficientThe current version of SQL Server does not provide a method to get error
message text in Transact-SQL. This functionality is planned for SQL 2005,
though.
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <nospam@.nospam.com> wrote in message
news:eRXqGcYjFHA.3448@.TK2MSFTNGP10.phx.gbl...
>I know how to capture the error number using @.@.ERROR, but I don't know how
> to capture the actual text. It is easy to do so via an application that
> uses
> a database driver (BDE, ADO .NET etc...), but I just want to capture the
> error text in SQL script and log it to a table.
> Please Note:
> 'select description from master.dbo.sysmessages' alone is not sufficient
>

How to calculate number of occurances of a character in a string

Is there a string function in T-sql which tells us that the number of occurances of a character in a string?
eg. abracadabra
no. of a's in the string : 5
Any Help is appreciated.select len(@.YourString)- len(replace(@.YourString, 'a', ''))

blindman