SharePoint 2019/SQL Server 2016 Move Databases encounter error saying SQL Azure...

%3CLINGO-SUB%20id%3D%22lingo-sub-1277414%22%20slang%3D%22en-US%22%3ESharePoint%202019%2FSQL%20Server%202016%20Move%20Databases%20encounter%20error%20saying%20SQL%20Azure...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277414%22%20slang%3D%22en-US%22%3E%3CP%3EI%20installed%20a%20Single%20Server%20Farm%20of%20SharePoint%202019%2C%20on%20a%20Windows%20Server%202016%20Datacenter%20server%20for%20some%20testing%2C%20and%20the%20SQL%20Server%20is%20on%20a%20Windows%20Server%202008%20R2%20Server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%202008%20R2%20support%20is%20coming%20to%20an%20end%20so%20I%20install%20another%20SQL%20Server%202016%20instance%20on%20the%20save%20server%20with%20SharePoint%2C%20and%20followed%20instructions%20on%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fadministration%2Fmove-all-databases%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%20page%3C%2FA%3E%20to%20move%20my%20existing%20databases%20to%20the%20new%20SQL%202016%20instance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20detached%20all%20the%20SharePoint%20related%20databases%20and%20attach%20them%20in%20the%20new%20SQL%202016%20instance%2C%20and%20run%20the%20SPDatabase.ChangeDatabaseInstance%20command%20from%20SharePoint%20management%20console%2C%20to%20change%20database%20server%20to%20the%20newly%20installed%20instance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20something%20wired%20happened%20saying%26nbsp%3B%3CSTRONG%3EException%20calling%20%22ChangeDatabaseInstance%22%20with%20%221%22%20argument(s)%3A%20%22SQL%20Azure%20SQL%20does%20not%20support%20intergrated%20authentication%22%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHowever%2C%20something%20even%20more%20strange%20is%20that%2C%20when%20I%20open%20the%20SharePoint%20Products%20Configuration%20Wizard%2C%20it%20DOES%20show%20that%20the%20Database%20Server%20is%20now%20pointing%20to%20the%20new%20Instance.%20But%20when%20I%20try%20to%20run%20the%20configuration%20wizard%2C%20it%20also%20shows%20up%20the%20SQL%20Azure%20SQL%20error.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20come%20is%20this%3F%20I'm%20using%20SQL%20Server%202016!%20Why%20is%20it%20complaining%20about%20SQL%20Azure%3F%20Now%20my%20SharePoint%20environment%20is%20down%20and%20what%20can%20I%20do%20to%20bring%20it%20back%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much%20in%20advance%20and%20any%20help%20or%20suggestion%20is%20highly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1277414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I installed a Single Server Farm of SharePoint 2019, on a Windows Server 2016 Datacenter server for some testing, and the SQL Server is on a Windows Server 2008 R2 Server.

 

As 2008 R2 support is coming to an end so I install another SQL Server 2016 instance on the save server with SharePoint, and followed instructions on this page to move my existing databases to the new SQL 2016 instance.

 

I detached all the SharePoint related databases and attach them in the new SQL 2016 instance, and run the SPDatabase.ChangeDatabaseInstance command from SharePoint management console, to change database server to the newly installed instance.

 

Then something wired happened saying Exception calling "ChangeDatabaseInstance" with "1" argument(s): "SQL Azure SQL does not support intergrated authentication".

 

However, something even more strange is that, when I open the SharePoint Products Configuration Wizard, it DOES show that the Database Server is now pointing to the new Instance. But when I try to run the configuration wizard, it also shows up the SQL Azure SQL error.

 

How come is this? I'm using SQL Server 2016! Why is it complaining about SQL Azure? Now my SharePoint environment is down and what can I do to bring it back?

 

Thanks very much in advance and any help or suggestion is highly appreciated.

0 Replies