Hang on, I didn't explain properly. That sets the port used on the remote SQL Server, doesn't it? I want to set the local (.NET application) port used on the local machine running the .NET application.
Stephen On Tue, 10 Jan 2006 08:21:13 +0100, Frans Bouma <[EMAIL PROTECTED]> wrote: >> I need to connect to a remote SQL Server, but would like to >> specify the port used on the local machine running the application. > > oh in that case, go to the sqlserver programs in windows start menu and start client network utility. > > On the alias tab, click add, specify a name, TCP/IP and at the right the server name and the port. Then in the connection >string, use the alias. > > Normally you don't have to specify the port, as sqlserver has a discover service running. > > FB > >> >> >> On Mon, 9 Jan 2006 09:47:16 +0100, Frans Bouma >> <[EMAIL PROTECTED]> wrote: >> >> >> Can anyone tell me how to set the local port when using a >> >> SqlConnection (not the remote port, as set by "Network >> Address=" in >> >> the connection string)? >> > >> > If you want to connect to the local service, simply specify >> (local) as servername. Sqlserver doesn't have a 'local' port or >> >'remote port'. just 1 port for connections and 1 for a listener. >> > >> > FB >> > >> >=================================== >> >This list is hosted by DevelopMentorR http://www.develop.com >> > >> >View archives and manage your subscription(s) at >> http://discuss.develop.com >> >> =================================== >> This list is hosted by DevelopMentorR http://www.develop.com >> >> View archives and manage your subscription(s) at >> http://discuss.develop.com >> >> > >=================================== >This list is hosted by DevelopMentor® http://www.develop.com > >View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
