RE: Network Configuration...

anonymous_at_discussions.microsoft.com
Date: 01/15/04 

Date: Thu, 15 Jan 2004 08:12:23 -0800

Thank you very much! I found my port information. I do
have another question. Do you know if there is a way to
change the port to the default port 1433? Do you see any
problems with doing this?

>-----Original Message-----
>Typically, the admin on the machine would be
viewing/chaning the ports SQL
>is listening on.
>
>You need to be able to read the following registry key;
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLSe
rver\SuperSocketNet
>Lib\Tcp
>
>After SQL Server starts, you can determine what port it
is using by
>reviewing the SQL Errorlogs and the NT Application
Eventlogs.
>Also, running netstat -an will give you the port
information as well.
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>

Relevant Pages

  • Re: TCP socket question
    ... when I try to connect to that port from my non-C# program I am getting ... application using port information, which all of the solutions are free. ... You can also use netstat /? ... that can be used and the information returned by using those parms. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TCP socket question
    ... And this is the C# code that was working fine but I have a program that connects to the port my C# program is listening to and it worked fine. ... There is also TCPView, ActivePorts and Currports that give port and application using port information, which all of the solutions are free. ... You can also use netstat /? ... to display netstat's help and shows the parms that can be used and the information returned by using those parms. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TCP socket question
    ... And this is the C# code that was working fine (I did not use netstat though ... when I try to connect to that port from my non-C# program I am getting ... application using port information, which all of the solutions are free. ... do a telnet localhost ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TCP socket question
    ... There is also TCPView, ActivePorts and Currports that give port and application using port information, which all of the solutions are free. ... to display netstat's help and shows the parms that can be used and the information returned by using those parms. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)