I have same situation as the OP, we have a 'scratch' database that the devs write all kinds of stuff too, only to delete it or send its data on...

Your connection parameters may be bad as well. Double check the servername, etc.

If the servername seems correct, try pinging it, connecting with the IP directly etc.

TRUNCATE, but be cautious if you want any auto-increment PK columns to not reseed back to the original seed value of the table.

If that is the case,...

You could also set the column to ignore truncation errors if you are certain your data won't overflow the allowed space.

Truncation errors in SSIS are annoying sometimes.

Rynga, did you fix your problem?

Sounds to me like you want application roles. The access granted by an app role is only alive as long as the thread from the applicaiton is alive....

You can also manually update the SPN's, this would be issued from the command prompt with an Admin account:

setspn -A MSSQLSvc/myhost.redmond.microsoft.com:1433 accountname

setspn -A MSSQLSvc/myhost.redmond.microsoft.com accountname

setspn -A MSSQLSvc/myhost.redmond.microsoft.com:instancename accountname

We had something similar, this KB fixed our SPN problems:

http://support.microsoft.com/kb/2811670

You use such a cute little coffee mug!

:hehe:

I can fit a four-cup pot of coffee in my normal mug...

Besides, I never specified the *size* of the pot! What if...

I always liked to ask someone interviewing me what they felt was the worst part about where they were currently working. This always seemed to throw them off a...

I am imagining a large chunk of wood smushing a cockroach....

Sounds like a place I contracted at once that had a 'no temp tables' rule. One of the boss-types was convinced any sort of temporary table was a performance...

Found the problem! Altho Windows firewall was off, the firewall setting inside of F-Secure, which was a recent installation on the desktops affected by this error, was on!

Switched off...

Deleted

Phil Parkin (10/28/2013)

---

pnr8uk (10/28/2013)

---

Thanks I thought of that, but sadly the value is then wrong on what SQL is looking for:

The FileSystemPath has to match exactly, so if I remove...