There are a few things to check to see if kerberos is setup properly.

check if the SPN is correct, in an elevated command prompt window type "setspn -L <managed service...

you could try granting permission on the file restore location to the AD group. It might be that the AD group doesn't have permission to create a file in windows.

check...

This example works fine for me. My guess is the actual file you are trying to import has some hidden characters which is causing this. See if you can import...

A table name cannot start with a number

http://msdn.microsoft.com/en-ca/library/ms175874.aspx

If you want to access network resources you should use either a managed service account or a domain account

http://msdn.microsoft.com/en-us/library/ms143504.aspx#Default_Accts

If this is what is occurring then ideally you would want the application to close the connection when it receives the error.

This would be a simple thing to test...

there is no limit to filestream files outside of the free space on the volume

http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx

FILESTREAM storage is implemented as a varbinary(max) column in which the data is stored as BLOBs...

If you do have a windows password policy, checking the "Enforce Password Policy" should lock a sql login after however many invalid logins are specified.

http://msdn.microsoft.com/en-us/library/ms161959.aspx

I am guessing that the application is not trying to reconnect as it is already connected. the problem is that the credentials of the account have changed and I believe...

seems to me that an idle timeout could be handled better via the web app directly (example). Keeping the session state in the database would require your app to constantly...

Just curious why...

First off, I will say that the method used for backups isn't as important as whether said method can satisfy your businesses RPO and RTO. You should test each restore...

Since you specify that you need to get files for a specific date and dealer, is there an identifying dealer name in the file? I am going to assume ACTEST...

vnraaje (11/12/2014)

Its really helpful to me. I want to give specific date in that expression so that i have to create a variable and give date value, so that it...

do you want to download all files files in the ftp location or just a specific date?

if you want to get all the files in the format yyyymmdd.txt you can...