setting port in adp

[Mike Schwarz]

hi

just wondering where i can set a different port in adp connection than
standard 1433 ?

thankx for any hints

mike schwarz

www.ctek.ch

 

[Lyle Fairfield]

hi

just wondering where i can set a different port in adp connection than
standard 1433 ?

thankx for any hints

mike schwarz

www.ctek.ch

enter a comma and the port number after the server name in the datalink
connection properties dialog (File->Connection)

mssql05.someserver.net,1433

(this should work for 1433)

or

mssql05.someserver.net,5057

for port 5057