Jump to content


dfpjopo

Fail to create SQL Server Certificate

By dfpjopo, in Configuration Manager 2012

Recommended Posts

dfpjopo Newbie

dfpjopo

Posted
Posted

Hi,

 

I have a small problem with SQL server certificate. I have installed 1 central administration site. Now i want to instal primery Site server.

 

 

51994497.png

 

78829457.png

 

NFO: Found SQL Server common language runtime <Microsoft.SqlServer.SqlClrProvider,fileVersion="10.0.1600.22",version="10.0.0.00000",culture="neutral",publicKeyToken="89845DCD8080CC91",processorArchitecture="MSIL">.  $$<Configuration Manager Setup><11-14-2011 12:17:38.487-60><thread=3872 (0xF20)>
INFO: Found SQL Server SMO <Microsoft.SqlServer.Smo,fileVersion="10.0.4064.0",version="10.0.0.0000",culture="neutral",publicKeyToken="89845DCD8080CC91",processorArchitecture="MSIL">.  $$<Configuration Manager Setup><11-14-2011 12:17:38.488-60><thread=3872 (0xF20)>
INFO: SQL Server Native Client, SQL Server SMO and SQL Server Common Language Runtime types had been installed already.  $$<Configuration Manager Setup><11-14-2011 12:17:38.489-60><thread=3872 (0xF20)>
INFO: Stored SQL Server computer certificate for Server [VHSSCENTER01.singelland.local] successfully on [VHSSCENTER01.singelland.local].  $$<Configuration Manager Setup><11-14-2011 12:17:38.600-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:38.605-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:38.605-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:41.606-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:41.606-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:44.606-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:44.606-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:47.606-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:47.606-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:50.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:50.607-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:53.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:53.607-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:56.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:56.607-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:17:59.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:17:59.607-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:18:02.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:18:02.607-60><thread=3872 (0xF20)>
CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><11-14-2011 12:18:05.607-60><thread=3872 (0xF20)>
ERROR:  SQL Connection failed. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:18:05.607-60><thread=3872 (0xF20)>
INFO: Registered type CCAR_DB_ACCESS for VHSSCENTER01.singelland.local CM_SLD  $$<Configuration Manager Setup><11-14-2011 12:18:08.607-60><thread=3872 (0xF20)>
INFO:  SQL Connection succeeded. Connection: CCAR_DB_ACCESS, Type: Unsecure  $$<Configuration Manager Setup><11-14-2011 12:18:08.608-60><thread=3872 (0xF20)>
INFO: Read CAS SQL information, stored CAS SQL Server certificate and registered the connection to the CAS database.  $$<Configuration Manager Setup><11-14-2011 12:18:08.610-60><thread=3872 (0xF20)>
INFO:  SQL Connection succeeded. Connection: CCAR_DB_ACCESS, Type: Secure  $$<Configuration Manager Setup><11-14-2011 12:18:08.627-60><thread=3872 (0xF20)>
INFO: CAS: VHSCENTRAL01.singelland.local is ready to be attached by this site: VHSSCENTER01.singelland.local from CAS: (null).  $$<Configuration Manager Setup><11-14-2011 12:18:08.628-60><thread=3872 (0xF20)>
INFO: CAS is active. We will install Primary site.  $$<Configuration Manager Setup><11-14-2011 12:18:08.628-60><thread=3872 (0xF20)>
INFO: 64-Bit Visual C++ Redistributable package is already installed. Will skip installation.  $$<Configuration Manager Setup><11-14-2011 12:18:08.639-60><thread=3872 (0xF20)>
INFO: 32-Bit Visual C++ Redistributable package is already installed. Will skip installation.  $$<Configuration Manager Setup><11-14-2011 12:18:08.640-60><thread=3872 (0xF20)>
ERROR: Failed to get Exchange Public key.  $$<Configuration Manager Setup><11-14-2011 12:18:16.404-60><thread=3872 (0xF20)>
INFO: Setting -T8295 SQL Server Param already exists.  $$<Configuration Manager Setup><11-14-2011 12:18:16.405-60><thread=3872 (0xF20)>
INFO: Setting -T4199 SQL Server Param already exists.  $$<Configuration Manager Setup><11-14-2011 12:18:16.405-60><thread=3872 (0xF20)>
INFO: Creating SQL Server machine certificate for Server [VHSSCENTER01.singelland.local]...  $$<Configuration Manager Setup><11-14-2011 12:18:16.405-60><thread=3872 (0xF20)>
INFO: 'VHSSCENTER01.singelland.local' is a valid FQDN.  $$<Configuration Manager Setup><11-14-2011 12:18:16.405-60><thread=3872 (0xF20)>
Certificate (0x1e5a9920) is Exportable  $$<Configuration Manager Setup><11-14-2011 12:18:16.423-60><thread=3872 (0xF20)>
ERROR: Failed to encrypt serialized certificate (VHSSCENTER01.singelland.local)(LastError=0)  $$<Configuration Manager Setup><11-14-2011 12:18:16.455-60><thread=3872 (0xF20)>

Share this post

Link to post
Share on other sites
Johno2518 Newbie

Johno2518

Posted
Posted

I had the same problem and didn't want to re-install everything. The solution is simple:

 

Go to C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys

 

Delete (or move for backup purposes) any files that were created/modified on the days where you installed/stuffed up/Uninstalled SCCM 2012.

 

Go to C:\ProgramData\Microsoft\Crypto\RSA and browse the other sub directories that exist (if any) and perform the same procedure of deleting (or moving) the files.

 

Re-run the installation and it should work properly.

 

NOTE: I did delete the SMS registry key as well as ODBC System DSNs for SCCM, any directories created by SCCM in the program files directory and log files (to make sure it was a clean install).

 

Hope this helps someone who doesn't want to re-install windows/sql server. I did have the luxury of doing so but why do it when you don't need to ;)

Share this post

Link to post
Share on other sites
shieldsit Newbie

shieldsit

Posted
Posted

I had the same problem and didn't want to re-install everything. The solution is simple:

 

Go to C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys

 

Delete (or move for backup purposes) any files that were created/modified on the days where you installed/stuffed up/Uninstalled SCCM 2012.

 

Go to C:\ProgramData\Microsoft\Crypto\RSA and browse the other sub directories that exist (if any) and perform the same procedure of deleting (or moving) the files.

 

Re-run the installation and it should work properly.

 

NOTE: I did delete the SMS registry key as well as ODBC System DSNs for SCCM, any directories created by SCCM in the program files directory and log files (to make sure it was a clean install).

 

Hope this helps someone who doesn't want to re-install windows/sql server. I did have the luxury of doing so but why do it when you don't need to ;)

 

Just wanted to post a thanks for this. It saved me from reinstalling.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.