How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

      Comments Off on How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

If you would like to upgrade Citrix Virtual Apps server from Citrix Virtual Apps 7 1912 LTSR version to the newer version, it might happen error messages “We cannot determine which SQL Server version is current installed” and “The SQL Server LocalDB version is lower than the minimum supported version”.

011122 0105 Howtoreplac1 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

011122 0105 Howtoreplac2 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

This is because the server was upgrade from XenApp to Virtual Apps, the SQL Server Express version is 2014.

011122 0105 Howtoreplac3 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

As we know, the SQL Express 2014 is not longer support after Virtual Apps 7 1912 LTSR version.

011122 0105 Howtoreplac4 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

Today, I am going to show you how to replace SQL Server Express LocalDB to the newest version.

1.Login to Virtual Apps delivery Controller server.

2.Download Microsoft SQL Server 2019 Express via below link.

https://www.microsoft.com/en-us/download/details.aspx?id=101064

011122 0105 Howtoreplac5 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

3.Run SQL2019-SSEI-Expr.exe file.

011122 0105 Howtoreplac6 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

4.On the User Account Control page, click Yes.

011122 0105 Howtoreplac7 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

5.On the Select an installation type page, click Basic.

011122 0105 Howtoreplac8 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

6.On the Microsoft SQL Server License Terms page, click Accept.

011122 0105 Howtoreplac9 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

7.On the Specify SQL Server install location page, click Install.

011122 0105 Howtoreplac10 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

8.It might take few minutes to completed download and installation.

011122 0105 Howtoreplac11 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

9.On the Installation has completed successfully page, take note for instance name and all information, click Install SSMS.

011122 0105 Howtoreplac12 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

10.On the Download SQL Server Management Studio (SSMS) page, click Free Download for the SQL Server Management Studio (SSMS) 18.10.

011122 0105 Howtoreplac13 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

11.Run SSMS-Setup-ENU.exe.

011122 0105 Howtoreplac14 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

12.On the User Account Control page, click Yes.

011122 0105 Howtoreplac15 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

13.On the Welcome page, click Install.

011122 0105 Howtoreplac16 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

14. It might take few minutes to completed download and installation.

011122 0105 Howtoreplac17 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

15.On the Setup Completed page, click Close.

011122 0105 Howtoreplac18 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

16.On the Installation has completed successfully page, click Close.

011122 0105 Howtoreplac19 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

17.On the exit confirm page, click Yes.

011122 0105 Howtoreplac20 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

18.Login to Citrix Virtual Apps Delivery Controller server as local administrator.

19.Stop Citrix services.

20.Open SSMS, Select the old instance name as Server name click Connect. In my case, it’s CGY-XENEXEC03\SQLEXPRESS.

011122 0105 Howtoreplac21 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

21.On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreLogging, select Properties.

011122 0105 Howtoreplac22 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

22.On the Database Properties – CitrixStoreLogging page, select Files.

011122 0105 Howtoreplac23 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

23.On the Files page, take note for the path and file name of Database files.

011122 0105 Howtoreplac24 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

011122 0105 Howtoreplac25 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

24. On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreMonitoring, select Properties.

011122 0105 Howtoreplac26 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

25.On the Database Properties – CitrixStoreMonitoring page, select Files.

011122 0105 Howtoreplac27 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

26. On the Files page, take note for the path and file name of Database files.

011122 0105 Howtoreplac28 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

011122 0105 Howtoreplac29 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

27. On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreSite, select Properties.

011122 0105 Howtoreplac30 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

28. On the Database Properties – CitrixStoreSite page, select Files.

011122 0105 Howtoreplac31 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

29. On the Files page, take note for the path and file name of Database files.

011122 0105 Howtoreplac32 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

011122 0105 Howtoreplac33 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

31.On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreLogging, select Detach.

011122 0105 Howtoreplac34 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

32.On the Database to detach page, select Drop Connections, select Update Statistics, click OK.

011122 0105 Howtoreplac35 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

33. On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreMonitoring, select Detach.

011122 0105 Howtoreplac36 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

34. On the Database to detach page, select Drop Connections, select Update Statistics, click OK.

011122 0105 Howtoreplac37 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

35. On the Object Explorer page, expand the instance, expand Databases, right-click CitrixStoreSite, select Detach.

011122 0105 Howtoreplac38 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

36. On the Database to detach page, select Drop Connections, select Update Statistics, click OK.

011122 0105 Howtoreplac39 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

37.Close SSMS.

38.Re-open SSMS, select the new instance name as Server name click Connect. In my case, it’s CGY-XENEXEC03\SQLEXPRESS01.

011122 0105 Howtoreplac40 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

39. On the Object Explorer page, expand the instance, right-click Databases, select Attach.

011122 0105 Howtoreplac41 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

40.On the Database to attach page, click Add.

011122 0105 Howtoreplac42 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

41.Select CitrixStoreLogging.mdf from previsouly noted path, click OK.

011122 0105 Howtoreplac43 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

42.On the Attach Database page, click OK.

011122 0105 Howtoreplac44 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

43. On the Object Explorer page, expand the instance, right-click Databases, select Attach.

011122 0105 Howtoreplac45 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

44. On the Database to attach page, click Add.

011122 0105 Howtoreplac46 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

45. Select CitrixStoreMonitoring.mdf from previsouly noted path, click OK.

011122 0105 Howtoreplac47 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

46. On the Attach Database page, click OK.

011122 0105 Howtoreplac48 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

47.On the Object Explorer page, expand the instance, right-click Databases, select Attach.

011122 0105 Howtoreplac49 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

48. On the Database to attach page, click Add.

011122 0105 Howtoreplac50 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

49. Select CitrixStoreSite.mdf from previsouly noted file path, click OK.

011122 0105 Howtoreplac51 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

50. On the Attach Database page, click OK.

011122 0105 Howtoreplac52 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

011122 0105 Howtoreplac53 - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

Hope you enjoy this post.

Cary Sun

Twitter: @SifuSun

Web Site: carysun.com

Blog Site: checkyourlogs.net

Blog Site: gooddealmart.com

ca16fbd3199de5f66b829b87082fb970?s=80&d=retro&r=g - How to replace SQL Server Express LocalDB for Citrix Virtual Apps server

Author: Cary Sun

Cary Sun is an Principal Consultant, He has a strong background specializing in datacenter and deployment solutions, and has spent over 20 years in the planning, design, and implementation of network technologies and Management and system integration.He hold CISCO CERTIFIED INTERNETWORK EXPERT (CCIE No.4531) from 1997.Cary is also a Microsoft Most Valuable Professional (MVP) and Cisco Champion, He is a published author with serveral titles, include blogs on Checkyourlogs.net, author for many books. Specialties: CCIE /CCNA / MCSE / MCITP / MCTS / MCSA / Solution Expert / CCA
Blog:
http://www.carysun.com http://www.checkyourlogs.net
Twitter:@SifuSun

About Cary Sun

Cary Sun is an Principal Consultant, He has a strong background specializing in datacenter and deployment solutions, and has spent over 20 years in the planning, design, and implementation of network technologies and Management and system integration.He hold CISCO CERTIFIED INTERNETWORK EXPERT (CCIE No.4531) from 1997.Cary is also a Microsoft Most Valuable Professional (MVP) and Cisco Champion, He is a published author with serveral titles, include blogs on Checkyourlogs.net, author for many books. Specialties: CCIE /CCNA / MCSE / MCITP / MCTS / MCSA / Solution Expert / CCA Blog: http://www.carysun.com http://www.checkyourlogs.net Twitter:@SifuSun