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 6, 2021.

  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.

    (10479)

    read more...
     
    Noel, Oct 6, 2021
    #1

  2. SQL Server 2017 Express Issue with 3 Tier database access.

    Hi, I am facing an issue with SQL Server 2017 Express.

    My client is on PC1, SQL server is configured on PC2 and the database is on PC3. I could successfully connect to SQL server on PC2 through client on PC1, but if I try to access the database on PC 3 using client on PC1, I get following error...

    "Msg 5120, Level 16, State 101, Line 2

    Unable to open the physical file "\\MD1Z549C.ad001.siemens.net\Database_DT\Products\ProductDB.mdf". Operating system error 5: "5(Access is denied.)".

    Msg 1802, Level 16, State 7, Line 2

    CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

    When i access the database on PC2 there is no Issue. or if i use other SQL server from PC1 then I could access database database on PC3 as well. (here no intermediate PC2 is used)

    So issue is when I have Client, SQL Server and Database on 3 different machines. (it gives above errro message)

    The same scenario used to work well with SQL server 2008 R2 Express.

    The same issue is reproducible with SQL server 2017 full version and SQL server 2019.

    All the three PCs, shared drives and SQL server are configured well, which used to work with SQL server 2008 R2 express.

    Is there any limitation or restriction introduced with the latest version of SQL server ? OR anything I need to try out to make the scenario work on three different machine.

    Thanks a lot in advance.
     
    AnilTalnikar, Oct 6, 2021
    #2
  3. SQL server 2016 database audit specification problem

    I install Sql server 2016 on standard mode.

    now I want to configuration on auditing on SQL server database. I enable audit and server audit specification.

    But I can not create database audit specification........

    How can i do this ......

    it shows that, this audit is not available for that sql server.
     
    A k m rezaul karim sumon, Oct 6, 2021
    #3
  4. JLP1 Win User

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

    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?
     
    JLP1, Oct 6, 2021
    #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. 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...
  3. SQL Server, Shrink Database Maintenance Task Failing

    in Windows 10 BSOD Crashes and Debugging
    SQL Server, Shrink Database Maintenance Task Failing: Hello.I am experiencing problems with my script at the second to last line: Exec @SQL4. I would very much appreciate help and assistance to get this running. Thank you so much. DECLARE @db1 varchar20Declare @SQL1 VarChar500Declare @SQL2 VarChar1000Declare @SQL3...
  4. SQL Server Updates

    in Windows 10 Installation and Upgrade
    SQL Server Updates: Hi, Do Cumulative Updates contain previously released Security Updates, or are these separate, such that I have to install both? https://answers.microsoft.com/en-us/windows/forum/all/sql-server-updates/8e4241fb-93bc-4f98-b9d5-774c18e80cec
  5. Version of SQL Server - how to find?

    in Windows 10 Installation and Upgrade
    Version of SQL Server - how to find?: Windows 10 - how to find the version of the installed SQL-Server? [moved from German forums] https://answers.microsoft.com/en-us/windows/forum/all/version-of-sql-server-how-to-find/9a351dca-c410-4dd2-9c44-07e72910f52a
  6. 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...
  7. 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...
  8. Fix: Cannot find server certificate with thumbprint while restoring SQL database

    in Windows 10 Tutorials
    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 [ATTACH] This is because the database was encrypted with Transparent Data Encryption (TDE) and you will not be able to restore it until...
  9. 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...
  10. 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...