July 13, 2013 at 11:57 am
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
July 15, 2013 at 7:03 am
what do you mean by "cannot connect"?
Is it on different domain or something else?
Regards
Durai Nagarajan
July 15, 2013 at 8:16 am
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.
July 15, 2013 at 8:52 am
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 17, 2013 at 2:17 am
Dear,
If it is on the different domain, try using the sql user instead of domain user account (windows login).
July 17, 2013 at 3:35 am
have you tried using ip and sql authentication from local system whether it is connecting or not.
Regards
Durai Nagarajan
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply