Am i forced to use SQL port 1433 for applications between VB.net and SQL server? i would like to use a different port, is this possible? and where can i set it?

Also does anyone have a FAQ on encrypting the data betweent he application and the SQL server?

Many thanks

Ryan

As for sql server 2000, you can modifty the port as following steps.

1) Open "server network utility"

2) In the "Enable protocols" choose "TCP/IP" and click "properties"

3) You can set the port in the popup windows.

4) Open "client network utility"

5) Choose "Alias" tab and click "Add" button

6) In the window "Add network library configuration", choose the"network libraries" as "TCP/IP"

7) You can input the server alias and the server name and ensure "dynamically determine port" is clicked. That means if the default porthasn't been found, it can choose another port dynmaically.

You can infer the links.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9okz.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_77g3.asp

Yes. UseSQL Server Configuration Manager.

As for sql server 2000, you can modifty the port as following steps.

1) Open "server network utility"

2) In the "Enable protocols" choose "TCP/IP" and click "properties"

3) You can set the port in the popup windows.

4) Open "client network utility"

5) Choose "Alias" tab and click "Add" button

6) In the window "Add network library configuration", choose the"network libraries" as "TCP/IP"

7) You can input the server alias and the server name and ensure "dynamically determine port" is clicked. That means if the default porthasn't been found, it can choose another port dynmaically.

You can infer the links.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9okz.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_77g3.asp

thank you both for your prompt responses and i have set the SQL server to be the new port, im using visual stuido 2005, where do i set the configuration to the new port for my application?

im unsure what you mean by "client network utility"

many thanks

Ryan

You can find it in this way: Start -> All programs -> Microsoft SQL Server -> "client network utility" .

ok ignore my Noobness.

i found the client network utility and set it as you described, but i get no connectivity at all now :(

Am i missing something?

thanks Again

Ryan