Is the SSRS 2019 site in their single-signon internetzone? Browsers don't allow single signon by default

For IE it would be Security -  Local Intranet ( Verification of user: only automatic...

You could use

https://docs.dbatools.io/Copy-DbaDbTableData

with a query as a source.

Or export/import the data as csv from a restored backup

https://learnsql.com/blog/how-to-export-csv-from-sql-query/

4th wave is in full effect. Luckily most are vaccinated and have lower hopitalization needs.

Back to telework for a month

Where is the DDL of ExtractReports.dbo.TAllData and [ExtractReports].[dbo].[TradeCodesInsert] ? I only see [Parts].[TradeCodes]

Is there any sample data to work on?

Thanks Jeff Moden for the extensive reasoning. Bookmarked this post.

Most of our non-guid indexes are fillfactor 100. If I understand correctly I'll better stop the index maintenance for now and...

Why don't you script out the command instead of doing it through the GUI.

Do it once in the GUI but before applying choose "Script".

I agree. TDE = encryption at rest. If SQL Server is not running, you can't make sense of the data looking at the file

Always encrypted: encryption is specific to the...

I'm interested also if this is possible. I believe not because SSRS is rendering it as Excel.

I think in

rsreportserver.config

SSLCertificateConfiguration

• This reply was modified 4 years ago by Jo Pattyn. Reason: misread, is about ssrs certificate
• This reply was modified 4 years ago by Jo Pattyn.

Can't help you with it. Are you using the latest SSMS?

What do you mean by "there is a small difference in DNS between VM and SQL hostname"

What software do you use for the connection?

Do you connect using the fully qualified...

Haven't read it, but I wouldn't buy a book regarding SQL 2012 today.

The current version is 2019 and there was a major change with version 2016, you would miss out...

The update query still takes an exclusive lock to make the necessary modifications.

Under pessimistic locking your select query waits till the exclusive lock is released.

Without the tabledefinitions ,query, queryplants it...

If jobdatestart is a date or datetime, compare it with a date(time) instead of a string regarding [jobdatestart] > '6/1/2021'

Wat are the instance/database collactions of the 2012 reporting server? Reinstall the 2019 server using the 2012 collations?