Windows 10: Fix: Cannot find server certificate with thumbprint while restoring SQL database

Discus and support Fix: Cannot find server certificate with thumbprint while restoring SQL database in Windows 10 Tutorials to solve the problem; When restoring a database you might get the below error. System.Data.SqlClient.SQLError: Cannot find server certificate with thumbprint [ATTACH]... Discussion in 'Windows 10 Tutorials' started by Noel, Oct 19, 2018.

  1. Noel New Member

    Fix: Cannot find server certificate with thumbprint while restoring SQL database


    When restoring a database you might get the below error.

    System.Data.SqlClient.SQLError: Cannot find server certificate with thumbprint

    Fix: Cannot find server certificate with thumbprint while restoring SQL database sqlrestoretde.jpg

    This is because the database was encrypted with Transparent Data Encryption (TDE) and you will not be able to restore it until you get the Certificate, the Private key and the password from the supplier of the database.

    After you collect the required items above, open a new SQL query as the server admin on the database master.

    First we need to create the master cerificate on the server by using

    USE master
    GO
    CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<MyComplexPassword>'
    GO

    Now that the master certificate has been installed you will need to install the certificate provided by the owner of the database

    CREATE CERTIFICATE MyServerCert
    FROM FILE = 'C:\TDECert\Cert.cer'
    WITH PRIVATE KEY (FILE = 'C:\TDECert\key.pvk',
    DECRYPTION BY PASSWORD = '<PasswordProvidedByTheSupplier>');

    Once this is done and executed you will be allowed to restore the database.

    (0)

    read more...
     
  2. JLP1 Win User

    Running sql server 2005 and have restored several databases from backups using commands

    Original Title: sql server 2005

    I have a windows 10 computer running SQL server 2005 and have restored several databases from backups that were created using the following command:

    BACKUP DATABASE @name TO DISK = @fileName WITH INIT

    After restoring those databases, everything seems to run fine, but sys.dm_db_index_usage_stats is not being updated effectively. I can only get the stats to show up for 1 database at a time, and it only seems to be temporary. They are removed as soon as
    the next database is updated. The last updated database will only stay there temporarily too. I am not detaching the databases or restarting the server or doing anything else that should reset the statistics. Any ideas?
     
  3. SQL Server Files

    Hi RalphHead,

    Sorry for the inconvenience caused to you and thank you for your valuable question please, Before attempting reload of Windows 10 I would suggest you to please see the below mentioned article and see if it helps, If the issue persists kindly let me know,waiting
    for your kind reply please.

    https://docs.microsoft.com/en-us/sql/relational...

    Please let me know, if that helps and feel free to ask back any question.

    Kind Regards:

    Yasir
     
    MALIK YASIRNAWAZ, Oct 19, 2018
    #3
  4. Brink Win User

    Fix: Cannot find server certificate with thumbprint while restoring SQL database

    Always Encrypted now generally available in Azure SQL Database


    Source: Always Encrypted now generally available in Azure SQL Database | Blog | Microsoft Azure
     
    Brink, Oct 19, 2018
    #4
Thema:

Fix: Cannot find server certificate with thumbprint while restoring SQL database

Loading...
  1. Fix: Cannot find server certificate with thumbprint while restoring SQL database - Similar Threads - Fix Cannot find

  2. Looking for someone that understands SQL databases

    in Windows 10 Software and Apps
    Looking for someone that understands SQL databases: I an having to use a propriety SQL database, this owner of the program insist that he can not add a module for print set up of the multiple forms that need to be printed at times. The results of this are when printing landscape on 8.5 x 11 paper I always get two pages of each...
  3. Restart sql server

    in Windows 10 Customization
    Restart sql server: Having trouble restarting sql server to allow me to run my ACT program https://answers.microsoft.com/en-us/windows/forum/all/restart-sql-server/bfbf18a3-3866-4f2a-8855-e8fcf24ad19a
  4. Fix: SharePoint error Cannot generate SSPI context for SQL Server

    in Windows 10 Tutorials
    Fix: SharePoint error Cannot generate SSPI context for SQL Server: When having a SharePoint setup you might get the following error in your event viewer. Event ID 5586 – Unknown SQL Exception 0 occurred. Additional error information from SQL Server is included below. The target principal name is incorrect. Cannot generate SSPI context. The...
  5. SQL Server 2017 database mailing not triggering databasemail.exe to send out emails.

    in Windows 10 Installation and Upgrade
    SQL Server 2017 database mailing not triggering databasemail.exe to send out emails.: Good day All, After a certain update installed on my microsoft sql server 2017 my database mailing no longer works. I installed the latest CU 5 for sql server 2017 as this was suggested to resolve the issue online. After installing the update the databse mailing still...
  6. Thumbprint of a Certificate help

    in Windows 10 Support
    Thumbprint of a Certificate help: Hello Before doing a format on my computer and a fresh install i copied the things i wanted to save to an external hard drive. Now that i have the installation done, i can access everything except all the pictures that i had. They appear with a lock on the top right, when i...
  7. thumbprint

    in Windows 10 BSOD Crashes and Debugging
    thumbprint: Certificate for local system with Thumbprint c6 e7 54 db 47 b0 9f d2 d0 2c 0c 2b 27 f1 04 5a d5 97 48 8b is about to expire or already expired. https://answers.microsoft.com/en-us/windows/forum/windows_10-performance/thumbprint/d837a9b0-97d2-4194-9733-6eb562316fbc
  8. Microsoft SQL Server

    in Windows 10 Installation and Upgrade
    Microsoft SQL Server: I have just had to upgrade from Windows 10 Home to Pro in order to install the update of a Tax program I use. The reason for the upgrade was because the Home edition would not allow the installation of Microsoft SQL Server. So the Pro edition lets it run through to the end...
  9. Microsoft SQL Server

    in Windows 10 Customization
    Microsoft SQL Server: I have just had to upgrade from Windows 10 Home to Pro in order to install the update of a Tax program I use. The reason for the upgrade was because the Home edition would not allow the installation of Microsoft SQL Server. So the Pro edition lets it run through to the end...
  10. SQL Server error?

    in Windows 10 Network and Sharing
    SQL Server error?: How can I make this SQL Server error go away? [img] 65169

Users found this page by searching for:

  1. cannot find server certificate with thumbprint

    ,
  2. cannot find server certificate thumbprint sql

    ,
  3. cannot find certificate with thumbprint

    ,
  4. cant find server certificate with thumbprint,
  5. System.Data.SqlClient.SqlError: Cannot find server certificate with thumbprint,
  6. SQL Server cannot find server certificate with thumbprint,
  7. SqlError: Cannot find server certificate with thumbprint,
  8. sql restore cannot find server certificate with thumbprint,
  9. cannot find server certificate with thumbprint sql server,
  10. sqlerror cannot find server certificate with thumbprint,
  11. cannot restore sql db certificate thumbprint,
  12. cannon find server certificate with thumbprint sql 2012,
  13. cannot find server certificate thumbprint,
  14. Certificate for local system with Thumbprint,
  15. system.data.sqlclient.sqlerror: cannot find server certificate with thumprint