Re: can't connect to SQL 6.5 server in different domain

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 11/15/04 

Date: Sun, 14 Nov 2004 19:53:04 -0600

Hi,

Can you create a alias name using "CLIENT NETWORK UTILITY" from your WIN XP System by providing the

1. Protocol as TCP/IP
2. Provide the SQL 6.5 IP address
3. Define the Port number

Then use the ALIAS server name to connect. 

-- 
Thanks
Hari
SQL Server MVP
  "Charles MacLean" <charlesmaclean@sbcglobal.net> wrote in message news:ziWkd.18733$Rf1.10698@newssvr19.news.prodigy.com...
  Is there any trick to setting up a System DSN to connect to a SQL 6.5 Sever that is in a different domain.  The domains are trusted.  I've tried every type of authentication but my Win XP system just can't get a DSN to connect again the SQL Server that is running Win NT4 SP6.  Is there a trick? 
  Thanks,
  Chuck

Relevant Pages

  • Re: Serious errors with Create view command
    ... Either you open each view as needed with a different alias and assign this ... stored in the database, ... Edit Stored Procedures opens a code editing window and saves the code you ... can't paste it INTO the view designer sql view window as that's Read ...
    (microsoft.public.fox.helpwanted)
  • Re: Ranking - dealing with ties
    ... I didn't think until too late just to post the SQL - sorry. ... qryDivScore has fields Score and Div. ... Alias Scor1) ... Alias has to be used instead of the actual query name, ...
    (microsoft.public.access.formscoding)
  • Re: Apostrophe in SQL string
    ... The security hole you open up with dynamic sql strings would ... > rights.Please do not send email directly to this alias. ... sometimes there are customers with ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help - Backup not working after trying to get ISA 2004 to log to SQL
    ... On the Alias tab, ... there was an alias set up that had <servername> as the alias, ... I did a lot of restarting the SQL, WSUS and VSS services, but didn't make ... Backup log file shows this error: ...
    (microsoft.public.windows.server.sbs)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... You will have to undo the manual allowed nodes settings and then follow the instructions in "maintaining a failover cluster" for recovery from failure scenario 1. ... SQL 2000 on Windows Server 2003 allows up to four nodes in a cluster so you should be good to go. ... > Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)