This is thorny. You can either connect using SQL Server authentication (i.e. mixed mode authentication) (to do this specify using SQL Server login and password and to not connect using the windows account) or if you have to use Windows authentication you will need to establish a "trust" relationship between the two domains. b=Your network administrator(s) should be able to set up that trust relationship if needed.

Brian Freeman

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Friday, December 19, 2003 5:45 PM
To: LazyDBA.com Discussion
Subject: ODBC Connectivity


I have SQL server 7 running on Win NT server (separate
domain). I wish to have ODBC connectivity to the said
server from Windows 2000 server in another domain.
When I try I get the followin error

SQL State : 4200
SQL Error : 18452
Reason : Not Associated with trusted SQL Server
Connection

How shall go about this

TIA


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page