Do you have the same issue if you use the ACE.OLEDB driver or is it a different error?

Or failing that, what about the Visual Fox ODBC driver?  It looks like...

• This reply was modified 4 years, 3 months ago by Mr. Brian Gale.

I agree the post is old, but the information is still relevant.

I would check things like it suggests with process monitor to see if MAYBE there is some access denied...

As a thought - are you able to see ANY data or does it return no rows or does it give you an error?

I am not 100% certain, but I...

I would reach out to the company that provided you the driver.  Quick google, a "dbf" file is a dBase file.

Quick bit more of googling and I came across a...

Pretty sure that REPLACE is going to be the best way to approach that, without changing the underlying data structure and manipulating the data.  I prefer to store my addresses...

My opinion - with it being on a SAN, there isn't a lot of need to put it on separate disks UNLESS your SAN admin can guarantee that the separate...

Is there a reason you NEED to do this in powershell?  it feels like it is the wrong tool to me when SQL Server can handle this without the need...

Thinking this link will help:

https://feedback.azure.com/forums/908035-sql-server/suggestions/32902288-time-out-during-bacpac-import-of-data-tier-applica

To paraphrase the important part - your execution timeout period is too short.  You will need to specify a longer timeout period.  Depending on the size...

I would recommend downloading this:

https://www.microsoft.com/en-us/download/details.aspx?id=50731

That is the LATEST CU for 2012 SP2 which includes the TLS 1.2 stuff.  Feels to me like a much safer bet than downloading an older...

For SQL Server 2012, TLS 1.2 (transport layer security 1.2) depends on your SP version.  For SP2, it is CU10.  For SP1, it is CU3.  This can be found here:

https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe#:~:text=How%20to%20know%20whether%20you%20need%20this%20update,%20%20%20%2010%20more%20rows%20

As...

I kind of expected SQL to be smart enough to not let you re-use files like that during the install, but was just guessing in case that was the issue.

I...

"ACCESS DENIED" is actually very informative, depending on where you are seeing it as it SHOULD contain more information such as what access is being denied.

Is that in the SQL...

From the Microsoft documentation:

When this option is enabled, network communication between DTC services can fall back to non-authenticated communication or to non-encrypted communication if a secure communication channel cannot be...

On top of what Jeff was asking (what the scripts looked like before), I would be curious to see the execution plans for a slow run vs a fast run.

My first thought is that the local user Paolo is a member of a group on the local machine that has additional permissions on the SSRS instance.

That or you are...