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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Connect to SQLServer without using Remote Desktop?

Author  Topic 

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-08-13 : 15:09:45
Hi All,

One of our new user has a Windows XP Professional on his machine. Once the user connect to our internal VPN(Cisco VPN), using windows authentication in SQL Server Managment Studio, the user needs to connect to SQL Server 2005 (our internal server), but without using remote desktop.

We have already users able to do this (they also have XP Professional and SQL Server 2005 on thier machines). But I dont know how to do this for a new user. I need to know what are the pre-requisites to do this?
For example a user should have been defined on the remote server, with such & such rights, etc etc.

Can someone list all the steps or pre-requisites to do this.
Thanks,

Zee

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-13 : 15:33:18
Well it depends on what rights they will need. You really need to provide us with more information. Remote desktop is never required for almost everyone.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-13 : 23:17:01
User should be able to connect to sql server with sql client tools.
Go to Top of Page
   

- Advertisement -