And what should that parameter do? What is the actual logic here? You've just given data and told us...

• This reply was modified 3 years, 11 months ago by Thom A.

If the error is saying it does,...

What about the error in the logs? As I explained before, the errors to the application aren't helpful.

If you're getting the same error in the logs, you didn't restart the...

Thanks a lot for the replies

details from the log

08/25/2021 11:05:39,Logon,Unknown,Login failed for user 'xxx'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication...

If you check the SQL Server's logs you'll see the full authentication error. What is that error? That'll tell us why the LOGIN/USER is failing to connect. Errors passed to...

• This reply was modified 4 years ago by Thom A.

I use very similar methodology to what ratbak described. 9 times out of 10 (probably more) the reason the data is missing in my line of work is because it's...

I can't say I've ever run into this problem, and I've been daily driving ADS for at least a couple years. It almost sounds like you aren't actually connected to...

This depends how you've set things up. You say, here, you're using a SQL Task which, I assume, means you aren't using data flow tasks to migrate the data from...

Any INDEX can have a filter on it, from a WHERE clause. Though, as you have seen, these are most commonly seen on UNIQUE INDEXs as they allow for behaviour...

You can define a define a UNIQUE CONSTRAINT completely separately to your other indexes, and primary key. And no, if a column isn't included in the definition of the UNIQUE...

The tone of this response has changed significantly...

Think I've worked out the problem; I didn't realise that SQLPS doesn't use the host's version of Powershell, but it's own. As we're still running 2012 on this instance, then...

Hi Jeffrey,

I'm calling a script. All that's actually in the PowerShell command window for agent is (obviously with valid parameters):

& 'C:\Powershell\Copy APM OpenAttach.ps1' -ServerInstance "SQL Server Name"...

I am having also this issue. How do I use a PowerShell script built using the Windows Active Directory module as an Active Roles Server Script Module? I am trying...

Why create a c# task to move the file, and not just use a File System Task?