| Author |
 Topic  |
|
|
danaya
Starting Member
USA
5 Posts |
 Posted - 06/25/2012 : 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
USA
35007 Posts |
|
|
danaya
Starting Member
USA
5 Posts |
Posted - 06/26/2012 : 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
USA
35007 Posts |
|
|
xhostx
Constraint Violating Yak Guru
USA
261 Posts |
Posted - 06/26/2012 : 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://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
-------------------------- |
Edited by - xhostx on 06/26/2012 15:04:06 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 06/26/2012 : 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
|
|
|
danaya
Starting Member
USA
5 Posts |
Posted - 06/26/2012 : 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
USA
35007 Posts |
Posted - 06/26/2012 : 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
|
|
|
danaya
Starting Member
USA
5 Posts |
Posted - 06/27/2012 : 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
USA
35007 Posts |
|
| |
Topic |
|
Access SQL Server via Remote Desktop
