Forum Discussion
Unusual Warning Message when applying SQL 2019 CU24 to a server
Problem
I was recently applying SQL2019 CU24 to an SQL 2019 development server. That has SQL developer edition with CU 23 installed.
The OS is windows 2022
Integration Services was installed on the server.
After checking through the windows log following application of CU24 I spotted the following warning message
2024-01-09 14:44:51.46 spid10s Altering assemly [ISSERVER]
2024-01-09 14:44:51.48 spid10s Warning: The SQL Server client assembly 'microsoft.sqlserver.integrationservices.server, version=15.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
2024-01-09 14:44:51.60 spid10s
Can anyone advise as to what may have caused this error?
Thanks
Hi, Jon.
Technically, it's not an error that you're getting but a warning.
It sounds like the virtual machine was created using the below offering from the Azure Marketplace, in which case there's nothing you can do about this warning (as far as I'm aware) as the version monitoring (part of the wider desired configuration state of the Marketplace package) is handled by Microsoft.
While it's an educated guess only, I'd expect you won't have any functional issues with Integration Services (which is what the library registration relates to).
As a point of comparison, if you had deployed a vanilla Windows Server 2022 image from the Marketplace and then installed SQL Server separately, you wouldn't/shouldn't be getting this warning since the Microsoft-side monitoring only covers the explicit Marketplace offering, not what you install on it (such as SQL Server).
Cheers,
Lain
