Changeing Remote ports

I have two instances of SQl 2005 running on a server. One I'm going to allow outside remote access to. But I don't want to do it on the default port. though I have it allowing remote and that seems to be working. I can seem to find where to change the default listening port.

and I scimmed the help and topics I saw. But didn't see one relevant to this question.

Open the Server Configuration Manager > Protocols for [InstanceName] > TCP/IP Properties > TCP Port > Restart the service

Jens K. Suessmeyer.

http://www.sqlserver2005.de

change pwd disconnects remote server

Hello,
I have sql personal server installed on my xp machine and have registered a
remote server called pccm-nt. I have login permissions to the server and I'm
a database user for all of the databases.
I connect to the remote sql server with my windows domain account username a
nd password. When I change my pwd I can no longer connect to the remote serv
er, pccm-nt, I usually have to remove the server and re-register it. Would s
omeone be able to tell me w
hy changing my domain password is causing this conflict?
Thanks,
ChiekoYour security token is now invalid. Logout of the domain and log back in ag
ain.|||Okay,
I'll try that but I think that I did log off and log on again.
Thanks for the help,
Chieko

Change password to sa user from remote client

Hello,
We need to change passwords to sa users from remote clients. The
problem is of course that we need to encrypt the password.
What is the best way to do this?
We read about applying a secure connection with sql server using SSL,
IPSec, multiprotocol. We implement them but we would like to know if
there is a way (maybe an api) that allow to change passwords and
encrypt them.
Yaron Paryanty
Cyber Ark CompanyI hope your asking about encrypting a session, and not using 'sa' for your
application...
By default if there is a Server certificate installed on SQL, we do encrypt
the logins on the wire. To be more secure you can Force Protocol
encryption on the client, which will encrypt all the traffic on the wire.
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||First of all thank you for your answer.
I am asking about encrypting the session but after i logon to the
mssql server i want to alter the password of sa user (or any other
user). If i sent the new password as is it will send by plained text.
I implement SSL and it works fine but i wanted to know if there is
something easier - like an API which change the password and send it
encrypted.
Thanks,
Yaron Paryanty
Cyber-Ark|||Protocol encryption is the way to do this safely. We' re able to encrypt
over all the protocols in SQL 2000. In previous versions we could only
encrypt the data using Multiprotocol.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.