🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: SQL 7, registering another....

#114
From: Dan Guzman
Date: Tue, 23 May 2000 00:00
23 lines
1895 bytes
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: <VlmW4.21772$S31.460991@newsread2.prod.itd.earthlink.net>
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>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,b01b170a47e5d1cf
X-Google-Attributes: gid104de1,public
X-Google-Thread: ff490,b01b170a47e5d1cf
X-Google-Attributes: gidff490,public
From: "Dan Guzman" <DGuzman@nospamplease-earthlink.net>
Subject: Re: SQL 7, registering another....
Date: 2000/05/23
Message-ID: <VlmW4.21772$S31.460991@newsread2.prod.itd.earthlink.net>
X-Deja-AN: 626108321
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>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread2.prod.itd.earthlink.net 959050229 24.217.53.74 (Mon, 22 May 2000 19:50:29 PDT)
Organization: EarthLink Inc. -- http://www.EarthLink.net
X-MSMail-Priority: Normal
NNTP-Posting-Date: Mon, 22 May 2000 19:50:29 PDT
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql