And that's the thing.
Reed Porter (816) 739-2491 [email protected] <[email protected]> On Wed, Aug 21, 2013 at 2:47 PM, Jason Sandys <[email protected]> wrote: > Hopefully that’s it – it’s easy to forget because it’s not really a > ConfigMgr “thing” – it’s not really a SQL Server “thing” either.**** > > ** ** > > J**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Thomas Gonzalez > *Sent:* Wednesday, August 21, 2013 2:31 PM > > *To:* [email protected] > *Subject:* [mssms] RE: move of sql db**** > > ** ** > > Geez….:*( totally forgot…thanks jason**** > > ** ** > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Jason Sandys > *Sent:* Wednesday, August 21, 2013 2:21 PM > > *To:* [email protected] > *Subject:* [mssms] RE: move of sql db**** > > ** ** > > Have you set up/verified your SPN for the new SQL Server instance?**** > > ** ** > > J**** > > ** ** > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Thomas Gonzalez > *Sent:* Wednesday, August 21, 2013 2: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] <[email protected]>] *On > Behalf Of *Dzikowski, Michael > *Sent:* Wednesday, August 21, 2013 2:07 PM > *To:* [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] <[email protected]>] *On > Behalf Of *Thomas Gonzalez > *Sent:* Wednesday, August 21, 2013 2:53 PM > *To:* [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,**** > > ** ** > > ** ** > > [image: signature]**** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > >
<<image001.png>>
