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
 General SQL Server Forums
 New to SQL Server Programming
 How to connect to SQL DATABASE outside the server

Author  Topic 

shivlok
Starting Member

1 Post

Posted - 2014-12-20 : 16:53:10
Hi Team,

Our SAP Sql server is on a cloud. I am currently able to access the SQL server from Remote Desktop Connection. I would like to know if I can connect to the Database server without the remote desktop.
Basically I am trying to develop Access Database queries on local computer and I want to pull the data from Remote Server. There is a firewall that is blocking the external ip address.
I would like to know if there is a workaround to set up the connection to first access the "Remote desktop" link and then the SQL server.

Appreciate your help.

Thanks,
Lokesh

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-20 : 22:06:58
talk to the firewall staff and ask about getting a port open for your connection, default is 1433
Go to Top of Page

nextaxtion
Yak Posting Veteran

54 Posts

Posted - 2014-12-21 : 11:33:44
go to sql configuration and check via tcp option there.

prithvi nath pandey
Go to Top of Page
   

- Advertisement -