Sure I do it all the time.  What are you using Enterprise manager? Can
you connect via IP address? What you need to do first is go to your
Client 
Network Utility that comes with SQL server. Add the ip address, using
TCP/IP
Once you have added it you can go into enterprise manager and add a new
SQL Registration using that IP address. Of course you will have to have
a 
Login set up on that specific SQL server and use that SQL login to get
in
instead of your NT login. Hope that helps.

-----Original Message-----
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 04, 2002 8:51 PM
To: SQL
Subject: How to connect to a sql database from a different domain

Hi all,
 
I want to be able to connect to a remote sql database (not from the same
domain)? 
 
Is it possible to do?
 
thanks
 
Thanh


______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to