🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

SQL 7, registering another....

#119
From: Silverbrain
Date: Thu, 18 May 2000 00:00
34 lines
1908 bytes
Here is the synopsis of the network.

WinNT 4.0 Server SP5; SQL 7.0 SP1; IP 128.10.10.2 (Domain A)

Win2K Server; SQL 7.0 SP2; IP 128.15.15.15 (Domain B)
  OLAP is not installed on this machine.

Both go to a Cisco router. Both have a trust relationship between them.
With the router in place, both Servers can
A) Ping
B) Telnet
C) HTTP
D) FTP
E) Browse and attatch to shared resources.

So we know the router is doing it's job.  Now what I  did is on SQL, checked
that all services are started on both Servers.  I do the register SQL
server.  No wizard, i put the IP address in the server column.  I use SQKL
Server auth, with the login name sa and no password.  I click OK, and an
error comes back at me....

SQL Server registration failed because of the connection failure displayed
below. Do you wish to Register anyway?
Client unable to establish connection
ConnectionOpen (CreateFile())

Also, there is a third box, WinNT 4.0 SP 4 SQL 7 SP1, on the 128.10.10.x ip
scheme, but in another domain.  The first box was able to register this box
just fine.




What am i not doing here, and what can i try?  Thanks in advance, Jason
Technical Details
Message-ID: <39246a38$0$26042@news.execpc.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff490,b01b170a47e5d1cf,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,b01b170a47e5d1cf,start
X-Google-Attributes: gid104de1,public
From: "Silverbrain" <silverbrain@nospam.hotmail.com>
Subject: SQL 7, registering another....
Date: 2000/05/18
Message-ID: <39246a38$0$26042@news.execpc.com>
X-Deja-AN: 625169102
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: abuse@execpc.com
X-Trace: Tl\okXWcmL7I5[332>a9Y;bfNiaEHUgJ7RYcgIRLSUE=?J@K4\CG<b7F9C_>YCcE13lD=NV0VOVD5><n_P@HcTf>
Organization: ExecPC Internet - Milwaukee, WI
X-MSMail-Priority: Normal
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql