client server encryption

  • Good morning all ,

    how can I check if SSL encryption is enabled on my SQL server, I only have SSMS access on server

    I have no RDP access on the server

    I cannot access the service configuration manager to see if this option enabled

    my problem comes during the installation phase of the application I have this error message

    Failed to start data source EXPLOIT.

    Failed to start server instances on machine gixxxxxxxx

    Failed to initialize server configured on machine gixxxxxxxx

    Encryption not supported on the client

    thanks

  • sys.dm_exec_connections will tell you if anything is connected using an encrypted session

    but if that returns false for all the connections you would need to ask someone with access to configuration manager to check if encrypted connections are enabled or not and provide you with the correct access methods etc for the SQL instance

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply