Home Forums SQL Server 2008 SQL Server 2008 Administration Is RDP Access Needed for a SQL Server Administrator? RE: Is RDP Access Needed for a SQL Server Administrator?

  • December 16, 2013 at 3:40 pm

    #1673896

    defyant_2004 (12/16/2013)

    We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in the past and it seems to provide everything our DBAs should need to maintain our SQL Servers without logging onto the server itself and messing things up. We have a 90% uptime we must keep. We also want to prevent any risk for corrupting our Windows Server installations.

    this sounds more like you want to keep people away from what you perceive is your responsibility, rather than making sure the company's needs are best served.

    try to get away from putting barriers between you and the DBA's; think of working together instead.

    turn your question around: what business do YOU have touching the SQL Server without the DBA knowing about it?

    when you think of it that way, maybe you'll think, oh yeah, we need to talk to each other before we install updates/take server offline/defrag disks, etc., and they would do the same when they run out of disk space from backups and other things.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!