Solved

how to allow tech to remote in to sbs 2008 server

Posted on 2010-08-26
7
322 Views
Last Modified: 2012-05-10
I need to allow a programmer to remote onto my sbs 2008 server to work on a custom SQL application.  Should I set him up as an administrator, or use some other account?  If you could reply back with the best practice advice and also instruction on how to set him up: what to activate, what to not activate.
0
Comment
Question by:rodynetwork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 6

Expert Comment

by:thompsonwireless
ID: 33535361
Don't allow anyone to use your administrator account.  Set up an account with admin rights and you can remove it or change the password if you want.  If you start changing admin passwords there's no telling what services and/or applications may stop working.
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 33535577
Only give him sufficient rights for what is actually needed.

If admin, then a New Admin account.

I would also key  an eye on what he is doing via VNC.

Do a system state backup at a minimum before giving access, and make sure your backups are all working properly.

I hope this helps !
0
 

Author Comment

by:rodynetwork
ID: 33535705
what is VNC?
0
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

 
LVL 63

Accepted Solution

by:
SysExpert earned 250 total points
ID: 33535942
Remote control program like RDP, Free open source, but allows shared viewing  ( RDP  does not let you see what is happening at the console )

TightVNC, UltraVNC are both good.

test it and see.

0
 
LVL 6

Expert Comment

by:thompsonwireless
ID: 33535971
If he is a reputable DB administrator you may not have to babysit him.  When I left vendors into our server I don't care to watch over them.  I only want to know he did what he should have.  
0
 
LVL 58

Expert Comment

by:Cliff Galiher
ID: 33537935
Answer has already been accepted, but I'll throw this out there:
Application programmers should not need access to the server *AT ALL.* I did software development in a previous life (including SQL development) and in my current live I've supervised many servers that host custom applications.
SQL Server is inherently a client-server application. An account can be given privileges in SQL server without getting any OS-level privileges, and all database work can be done remotely inclduing very intricate stored procedures, triggers, and other code-level procedures. The applicatoin should be using APIs that any SQL client install provides (whether they use ODBC or something more low-level) and thus server access is ultimately not required for any development work.
I cannot think, in all my years, where legitimate OS access was a required part of application development.
-Cliff
 
0
 

Author Comment

by:rodynetwork
ID: 33538024
Thanks cgaliher.  I am new to watching over my server.  I appreciate your input.  I will make sure I only give permission to access SQL and the development app.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question