🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-sqlserver
Article #116

Re: SQL 7, registering another....

#116
From: Silverbrain
Date: Tue, 23 May 2000 00:00
39 lines
2313 bytes
Hey I tried to do what you suggested, but instead of the IP (which didn't
work) I did it by the name and it went right in!  So I tried to register it
by name and it went right in!  I don't know why (maybe WINS finally kicked
in)  Thank you for your help.


"Dan Guzman" <DGuzman@nospamplease-earthlink.net> wrote in message
news:VlmW4.21772$S31.460991@newsread2.prod.itd.earthlink.net...
> I don't believe the SP level should make a difference.  Since you are
using
> SQL auth, the domains should not matter either,
>
> You mentioned that you can ping the IP address.  With the default SQL
client
> net library set to TCP/IP,  you should be able to open Query Analyzer and
> connect using SQL Authentication with the IP address specified as the
server
> name.  This assumes the SQL Server is configured to listen on port 1433
(the
> default).
>
> If this fails, please post the error message.
>
>
>
>
> Silverbrain <silverbrain@nospam.hotmail.com> wrote in message
> news:3929913d$0$63128@news.execpc.com...
> > I have modified both Servers to reflect the tcp/ip with their own
> respective
> > IP addresses.  I have tried going both ways, and get the same error.
You
> > say the SP level shouldn't affect them, how about the domains.
> >
> >
> >
>
>
>
Technical Details
Message-ID: <392ad6c5$0$17498@news.execpc.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <39246a38$0$26042@news.execpc.com> <jN0V4.2917$S31.46716@newsread2.prod.itd.earthlink.net> <392542ba$0$8661@news.execpc.com> <WgnV4.7554$T41.164129@newsread1.prod.itd.earthlink.net> <3929913d$0$63128@news.execpc.com> <VlmW4.21772$S31.460991@newsread2.prod.itd.earthlink.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff490,b01b170a47e5d1cf
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,b01b170a47e5d1cf
X-Google-Attributes: gid104de1,public
From: "Silverbrain" <silverbrain@nospam.hotmail.com>
Subject: Re: SQL 7, registering another....
Date: 2000/05/23
Message-ID: <392ad6c5$0$17498@news.execpc.com>
X-Deja-AN: 626391758
References: <39246a38$0$26042@news.execpc.com> <jN0V4.2917$S31.46716@newsread2.prod.itd.earthlink.net> <392542ba$0$8661@news.execpc.com> <WgnV4.7554$T41.164129@newsread1.prod.itd.earthlink.net> <3929913d$0$63128@news.execpc.com> <VlmW4.21772$S31.460991@newsread2.prod.itd.earthlink.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: abuse@execpc.com
X-Trace: Tl\okXWcmLGI5[332>a9YKbfNiaEHUgJGRYcgIRLSUEMEPF\FmSSLELQBlDNLGKJ7K:\YZeYBnTHL><n_P@HcTfN
Organization: ExecPC Internet - Milwaukee, WI
X-MSMail-Priority: Normal
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql