| Author |
Topic |
|
danaya
Starting Member
5 Posts |
 Posted - 2012-06-25 : 12:01:45
|
| Hello Group.I'm accessing SQL Server via Remote Desktop, and I'm hoping to build a DSN on my local machine that will enable me (on my local machine to the SQL server.. I have not worked with Remote desktop before.Thanks,Daniel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
danaya
Starting Member
5 Posts |
Posted - 2012-06-26 : 14:14:19
|
| Hi Tkizer,I may not have posted incorrectly. The SQL Server box resides with my client and they have provided access via remote desktop. So what I would like to do is define a connection from machine to the SQL server. I'm not running SQL Server on my machine. Can this be done? They also provided the IP address and name of the SQL server, but I suspect I cannot connect utilize that given firewalls etc. (I tried to ping the IP and it did not work). I'm used to connecting via a VPN where I can use all of the tools on machine. Thank you for your help! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-06-26 : 15:00:42
|
quote:
Originally posted by tkizer
Well you'll still need to VPN in to get the connection to their site. Install the SQL client tools locally, and after you VPN in, you'll be able to connect via ServerName\InstanceName.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Continuing on what it has been said. I have similar situation. the data i need to access is stored locally in one of a company's servers. I have created a script that collect some info from other remote servers, my script usually runs remotly using Remote desktop and then access windows command to execut a .SQL file.My situation is : At the run time of my script remotly, I will need to compare some data from the first server with data that's stored in the client databases (remote) using my local machine (Remote desktop). It is complex in away that there will be 3 machine involved. Im thinking to generate text files from my local database manually, load the same data into a the remote servers, and them run the audit from my machine.Please, any idea, thought, suggestion will be appreciated! this is SQL 2000 :)Thanks,--------------------------Get rich or die trying-------------------------- |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-06-26 : 15:10:00
|
quote:
Originally posted by xhostx
quote:
Originally posted by tkizer
Well you'll still need to VPN in to get the connection to their site. Install the SQL client tools locally, and after you VPN in, you'll be able to connect via ServerName\InstanceName.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Continuing on what it has been said. I have similar situation. the data i need to access is stored locally in one of a company's servers. I have created a script that collect some info from other remote servers, my script usually runs remotly using Remote desktop and then access windows command to execut a .SQL file.My situation is : At the run time of my script remotly, I will need to compare some data from the first server with data that's stored in the client databases (remote) using my local machine (Remote desktop). It is complex in away that there will be 3 machine involved. Im thinking to generate text files from my local database manually, load the same data into a the remote servers, and them run the audit from my machine.Please, any idea, thought, suggestion will be appreciated! this is SQL 2000 :)Thanks,--------------------------Get rich or die trying--------------------------
Please don't hijack threads. Your question is entirely unrelated to the original poster's question. Start a new thread, please.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
danaya
Starting Member
5 Posts |
Posted - 2012-06-26 : 15:55:28
|
| The client does not seem to provide VPN access. The tell me that users connect remotely is using Remote Desktop.. As for the SQL Client tools, what would you recommend installing? In most of my SQL server work, I just use MS-Access to connect via ODBC or OLE DB. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-06-26 : 16:00:45
|
| You can't use remote desktop without an established network connection. Remote desktop is just a client tool that allows you to connect to a server when a network connection has already been established. So you need some way to connect to them first, and that's almost always done via VPN.It doesn't sound like your client has much network knowledge. Do they expect you to drive there without providing VPN?I'd recommend installing the SQL Server client tools so that you can use SQL Server Management Studio.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
danaya
Starting Member
5 Posts |
Posted - 2012-06-27 : 09:10:33
|
| Hi Tara-You are correct that they do not have good network knowledge.. It is small partnership of drs. with one IT guy. I think I'm going to try to build the tool completely using remote desktop and not do any or do minimal work on my machine.. Thank you for your assistance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Access SQL Server via Remote Desktop