I have an annoying problem with a sql 2012. The SQL runs in a windows 2008 R2 server.
I have a .net software that does a select in a view. the view is an inner join between table articles and table image (a table where I store images in image filed).
If the image table is empty the query runs fine, but if I insert an image I have this error: "The specified network name is no longer available". I have this error from SSME also, but only if I'm in VPN (in LAN the query return results in 2 secs).
I have a WIN 7 with the same DB in the same network and all runs correctly.
So, I tryed to disable windows firewall but the problem was not solved.
there is some other configurations in windows 2008/sql 2012 that could cause the error?
and why I have the problem only if I have the images in the table?