Thanks for posting back the error message - that really does make a difference as it's an issue with permissions when trying to connect to the database, even though the...

Glad it's all working now - and thanks a lot for following up and posting back. It really helps when people do that.

Sue

If the data source connects to a instances with TLS, Try adding Encrypt=yes to the connection string. Depending on different configurations, you may also have t include trustServerCertificate=true. The following...

It might help if you post the exact error message the user gets. If the user doesn't have permissions, the error is typically: select permission denied on the object...etc. An...

If it's all users in the domain you can use the Authenticated Users group. Otherwise, I don't know enough about your AD groups to say. But groups and roles are...

That would be normal if those tables are in the cdc schema with a _CT appended to the name

Sue

There is a default location you set in the same area where you went to Tools...Options and results to Text. On the General section under default destination for results. Below...

In a blob column (imageval) in sys.sysobjvalues that you would need to connect with the DAC to query. And then you just have the blob and could probably get some...

Usually the error is due to issues with date formats. Compare the regional settings, DST settings on the servers and also check the default language for the agent account.

Sue

There are some similar errors with some versions of SSMS. Try to use t-sql instead of SSMS and see if it works. If it errors, you should get more information...

A logical read is an 8K page. Divide the reads by 128 to get the MB. Divide by 1024 to get GB.

Sue

When using the Oracle client, make  sure to install Oracle Services for Microsoft Transaction Server

Installing Oracle Services for Microsoft Transaction Server

Sue

The looks like the query SSRS fires when someone views My Subscriptions, usually with a parameter at the end for the user. I never followed it enough in any trace...

Just running sp_configure (with or without using reconfigure) won't necessarily change the config block in master which is what DBCC CONFIG reports. It's often not flushed to disk until a...

Yes. The last two options can be set in a single alter database. But once the query store is enabled, you really need to monitor things to make sure the...