Since the issue is narrowed down to a single procedure , you need to look at the execution plan for the procedures to undertsand the way the query is being...

test user looks like a sql account , are your missing a password in your connection string

run update stats on the data master table first , it seems to be the root cause as mentioned above. Your optimizer if way off target when estimating the number...

I would check DTC as mentioned by Jack , also have a look here .

From here - https://msdn.microsoft.com/en-us/library/cc304421.aspx

When deciding whether and how to implement a transaction, follow these guidelines:

...

here is a possible and fairly common scenario. The original execution plan is flawed and overestimates the number of suitable rows and therefore decides it needs more CPU power to...

1- how do you compare Cognos with MS's Power BI tool. which one is best and why?

Power Bi is better when integrated with sharepoint, this gives you the drag and...

You can use SSRS to provide the same kind of reports that Cognos delviers but your current task is much bigger than just Cognos. You need a DW ( it...

The new cardinality estimaotr is not guaranteed to improve performance in all cases, there are sceanrios where it might actually degrade performance hence the trace flag

read more here

the issue seems to be with a connection manager and not the transaction settings. Please check if you connection managers are configured properly.

Click the details button and check what it says , also are you able to connect to the catalog database directly within SSMS, check for permissions , Also...

I think your going about it the wrong way. If you just want to display the data in excel then you dont even need SSRS in the middle.

https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.extensions%28v=vs.120%29.aspx

Here are the...

SQL express cant be used as a publisher in replication

You dont need to know the workings on an internal combustion engine to drive a car , same thing goes for internals and SQL server. MS has done a good...

What I meant with In your server is , if you have set up log shipping and monitored it regulalry your likely to have come across this file type atleast...

seems to be an isolation level issue , do you have optimistic concurrency enabled?