Article View: comp.databases.ms-sqlserver
Article #119SQL 7, registering another....
From: Silverbrain
Date: Thu, 18 May 2000 00:00
Date: Thu, 18 May 2000 00:00
34 lines
1908 bytes
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-mailShow 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