Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to connect to sql instace using an intermediate sql server Expand / Collapse
Author
Message
Posted Saturday, July 13, 2013 11:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 17, 2013 10:49 AM
Points: 2, Visits: 10
Hi,

I have a rare case need. I don't have direct access to one our clients sql server(cannot connect) I can remote into another server and from there I can. But, I want to connect using C# code for some debugging purpose. This case I need to coonect from my local machine to target server using an intermediate server. Is this possible at all. please advise idea..

Thank you
Manju
Post #1473303
Posted Monday, July 15, 2013 7:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
what do you mean by "cannot connect"?

Is it on different domain or something else?


Regards
Durai Nagarajan
Post #1473636
Posted Monday, July 15, 2013 8:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 17, 2013 10:49 AM
Points: 2, Visits: 10
Yes, that is on a different domain. Even then I have access to the database with my domain authentication(windows logon) when I am on the domain network. But, when I try it through VPN I cannot connect to it. So, I always logon(RDC) to a remote server and and then use sql management studio to connect from there. When I want to connect from code remote server is not of any help.
Post #1473672
Posted Monday, July 15, 2013 8:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 13,302, Visits: 12,168
If you can't connect to the sql box from your machine you won't be able to connect to it through an application either. The application you want to run MUST be able to make a connection to the sql server. Maybe you can build the application and run it from the machine you are connecting with RDP?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1473697
Posted Wednesday, July 17, 2013 2:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 29, 2014 2:46 AM
Points: 14, Visits: 166
Dear,

If it is on the different domain, try using the sql user instead of domain user account (windows login).
Post #1474440
Posted Wednesday, July 17, 2013 3:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
have you tried using ip and sql authentication from local system whether it is connecting or not.

Regards
Durai Nagarajan
Post #1474470
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse