Make sure SQL server is running, the database exists and is online …….

Also in Visual studio when you added the data source connection did you run a test connection at...

Here is few troubleshooting I would do as starting point…

1)Make sure in the C# code connection string, you pointing to correct database and using the correct credential. ...

I would use sys.dm_os_waiting_tasks DMV as starting point. It will list all threats that are waiting and what they are waiting for. That will tell you at least what is...

Scan will retrieve and touch all rows of the table whether or not the retrieved data is qualified for the request .It will be very costly for SQL server, since...

Give “Read and Write” permissions on the share for this account "Local System"’ (based on your post it looks that is what your SQL agent is running under). Check your...

I don’t understand why a developer wants to have admin right into reporting services instance. I wouldn’t give admin right in productions for sure. However, in Test environment is different...

SQL server agent service accounts must have read and write privileges on the share.

Does SQL server agent in both instances “Remote and local” using the same service account or different services account.