Strip the MM:SS from the datetime using dateadd a couple times then join it to the HR date

Something like the below would do it

select
id,
in_datetime,
date_hr
from #data d
inner join...

You should have all the projects needed to recreate the reports in a source control system somewhere, the quickest way to migrate is to redeploy from your master source.

If for...

You can look at the deadlock graph which is part of the system health extended event session.

that will tell you what objects the two spids had along with the queries...

Seems it doesn’t like it for some reason if it can’t load the right assemblies.

Reboot and run VS as admin otherwise I’d be tempted to uninstall the extensions and reinstall...

Have you installed SSDT and the right extensions from the marketplace?

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-visual-studio-2019

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio

No, no way at all.

The resources used by the role must be independent of other roles resources.

Each FCI **MUST** have its own storage, its own VNN, its own IP.

Best practise...

An alternative would be to use DBATools and use their permission scripting capabilities, which do a lot more than the script you have provided.

Would be a case of wrapping it in a sp_msforeachdb or using something like this wrapper I have for per DB executions.

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = (
SELECT...

You need to present all fresh storage.  You cannot use the existing storage which has been provisioned and presented to INSTANCE1.

You then need a new computer object in AD for...

Your missing a )

Remember to count the number of ( you have and then ensure you have the same amount of )

Also stop cross posting and creating duplicate posts, this...

This should give you all that you need

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15

https://docs.microsoft.com/en-us/powershell/module/nettcpip/test-netconnection?view=windowsserver2019-ps

https://www.habaneroconsulting.com/stories/insights/2015/tcpip-is-disabled-by-default-in-microsoft-sql-server-2014

once you establish that you can telnet/tnc to vmB then you should be good to establish a connection in ssms

SQL2008?  Well I have to say it that has been out of any support now for over 2 years so you really need to get that upgraded to 2019 and...

What about the other points I mentioned?

Ok so you can ping which means they can see each other.

The screen shot says your using a named instance of SQL, so you...

I take it both are domain joined machines?

can you ping VMb from VMa?

can you telnet or use powershells TNC cmdlet to connect from VMa to VMb on the sql port?...

Yes I get that.

But have you ever administered a 2014 or below instance?  If yes, then best practise was to put T1118 on.

So as it was best practise in the...