Article View: comp.databases.ms-sqlserver
Article #114Re: SQL 7, registering another....
From: Dan Guzman
Date: Tue, 23 May 2000 00:00
Date: Tue, 23 May 2000 00:00
23 lines
1895 bytes
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-mailReferences:
<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