connect to a server on different domain from a sto

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

connect to a server on different domain from a sto

Author

Topic

dino2dino
Starting Member

2 Posts

Posted - 2009-02-11 : 22:38:23

Hi,

I am hoping tha some one can clarify.

I have a sqlserver 2005 db on domain A.
And I am trying to connect to a server like http://servername. which is on domain B.

How to I do this through Stored procedure?
I have a CLR procedure which call a c# method. c# method connects to this http://servername and logs in.
Currently i get server not available error.

Please Help.

heavymind
Posting Yak Master

115 Posts

Posted - 2009-02-13 : 08:42:18

Are you able to connect http://servername from sql server machine using IE for instance?

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

dino2dino
Starting Member

2 Posts

Posted - 2009-02-13 : 12:57:38

Thanks for ur reply!

Yes Iam.

I have added the Ipaddress followed by the server name in the hosts file at system32\drivres\etc.

Is there soemthing like this I can do for access from sql?

Thanks again!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources