Re: IP-addresse

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ilya Margolin (ilya_at_unapen.com)
Date: 05/05/04


Date: Wed, 5 May 2004 11:11:15 -0400

Zeke,

IP address belongs to NIC, not SQL Server. If the server has more then one
NIC it will have more then one IP. IPCONFIG command will show that.

Ilya

"Zeke Galama" <nospam@nosmam.nu> wrote in message
news:%23IL9hAqMEHA.3232@TK2MSFTNGP11.phx.gbl...
> OK - but is always the ip-addresse for the machine that sql server runs
the
> IP-addresse of SQL server?
>
>
>
>
> "Ilya Margolin" <ilya@unapen.com> wrote in message
> news:%23Ngl23pMEHA.1392@TK2MSFTNGP09.phx.gbl...
> > Zeke,
> >
> > I am afraid you will have to parse xp_cmdshell('ipconfig') output.
> >
> > Ilya
> >
> > "Zeke Galama" <nospam@nosmam.nu> wrote in message
> > news:OvySOjpMEHA.2064@TK2MSFTNGP12.phx.gbl...
> > > Where can I check the IP-addresse of a running SQL server? Is there a
> > > difference if it is the full version or if it is the MSDE that is
> running?
> > > Can someone explain how this works...
> > > Zeke
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: Repost: Why cant access my local SQL Server from PocketPC 2003 SE Emulator
    ... Ilya, I just installed a default instance of SQL Server Express 2005 in my PC, using mixed authentication. ... using named instance "Server=VES\SQL2K" which is not going to work as devices do not support named pipes. ... If you have several instances you would need to specify port number desired instance is listening on instead of instance name. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: First row
    ... Ilya ... > I have a load of dts packages written in SQL Server 7.0, ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS Deployment
    ... Have you considered running DTEXEC on the remote PC? ... Ilya ... > My question Can we install DTEXEC.EXE (and NOT whole SQL Server 2005) on ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL-NS files (sqlns.dll) - redistributable?
    ... Read 'Distributing SQL Server with Applications' article from BOL. ... Ilya ... > If the client has a licensed copy of SQL Server, can the SQL-NS files be ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL-NS files (sqlns.dll) - redistributable?
    ... Read 'Distributing SQL Server with Applications' article from BOL. ... Ilya ... > If the client has a licensed copy of SQL Server, can the SQL-NS files be ...
    (microsoft.public.sqlserver.programming)