2007? resetkeyinformation=true
what happens if you re-deploy the client with that setting? From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Gonzalez Sent: Wednesday, August 21, 2013 3:15 PM To: [email protected] Subject: [mssms] RE: move of sql db I'm touching quite a bit of our environment, internal to external....can't say numbers but it's high and being the only sccm person, this has me on the edge and trying to train two internal with no SCCM experience...god help me. So I did all of that Michael, but that client looking for a signed cert on the new server, it just doesn't exist. I assumed after the site reset and pointing SCCM to the server, the cert would be created. But I am not sure... From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dzikowski, Michael Sent: Wednesday, August 21, 2013 2:07 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: move of sql db Wow. How many clients? http://technet.microsoft.com/en-us/library/bb680707.aspx From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Thomas Gonzalez Sent: Wednesday, August 21, 2013 2:53 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] move of sql db 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>>
