In the time of placing 2012 online, our db has grown quite a bit, why?! No idea, but I'm up to a 150 gig DB. I found a link that describes the process on moving the db to a new server. All of the process has been conducted, backup, restore, SPs executed, and CLR enabled. Now when I go into site reset, I select the sql db, provide the new name of the server and during the process (wpf) I see this in the log file:
*** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.~~ $$<Configuration Manager Setup><08-21-2013 12:55:22.716+300><thread=3208 (0xC88)> *** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection $$<Configuration Manager Setup><08-21-2013 12:55:22.723+300><thread=3208 (0xC88)> *** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<Configuration Manager Setup><08-21-2013 12:55:22.730+300><thread=3208 (0xC88)> INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure $$<Configuration Manager Setup><08-21-2013 12:55:22.737+300><thread=3208 (0xC88)> *** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.~~ $$<Configuration Manager Setup><08-21-2013 12:55:25.879+300><thread=3208 (0xC88)> *** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection $$<Configuration Manager Setup><08-21-2013 12:55:25.886+300><thread=3208 (0xC88)> *** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<Configuration Manager Setup><08-21-2013 12:55:25.894+300><thread=3208 (0xC88)> INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure $$<Configuration Manager Setup><08-21-2013 12:55:25.900+300><thread=3208 (0xC88)> I've verified that the computer account is in the local admins, but when I look at the certs on the primary I see the configmgr sql cert and on the new server, there is no configmrg sql cert only a client cert. I didn't see in the link about creating a cert. Here's the link I went by: http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx Thanks, [signature]
<<inline: image001.png>>
