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. How to check SQL server certificate information

    in Windows 10 Gaming
    How to check SQL server certificate information: We have a software running with SQL server 2012 Express embedded.We check "sys.dm_exec_connections", and find that the connection between the software and the SQL server has been encrypted "encrypt_option"="TRUE".Now we want to know the SSL certificate information for the...
  3. How to check SQL server certificate information

    in Windows 10 Software and Apps
    How to check SQL server certificate information: We have a software running with SQL server 2012 Express embedded.We check "sys.dm_exec_connections", and find that the connection between the software and the SQL server has been encrypted "encrypt_option"="TRUE".Now we want to know the SSL certificate information for the...
  4. SQL Server Database Connectivity Issues

    in Windows 10 Gaming
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  5. SQL Server Database Connectivity Issues

    in Windows 10 Software and Apps
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  6. SQL Server Database Connectivity Issues

    in Windows 10 Customization
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  7. Inplace upgrade of Server OS on a SQL 2012 Database server

    in Windows 10 Gaming
    Inplace upgrade of Server OS on a SQL 2012 Database server: We have an SQL database server version 2012 which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to version 2016.Wanted to know whether it was safe to do an inplace upgrade of the server OS 2012R2 to Server OS 2019. Is this...
  8. Inplace upgrade of Server OS on a SQL 2012 Database server

    in Windows 10 Software and Apps
    Inplace upgrade of Server OS on a SQL 2012 Database server: We have an SQL database server version 2012 which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to version 2016.Wanted to know whether it was safe to do an inplace upgrade of the server OS 2012R2 to Server OS 2019. Is this...
  9. 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...
  10. 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...