• audiocool (5/24/2015)


    Is that Remote desktop connection ? If yes, we all login to SQL Server via Remote Desktop Connection.

    Well there's part of your problem.

    If this is not recommended, what will the client use to remote in.

    Err, nothing. Remoting in to a production server should be a rare event, not an everyday occurrence. SQL can be managed remotely, many things can be done remotely. The administrators (and only the administrators) should remote in only when they absolutely need to

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass