Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

I just had another article published at simple-talk.com: “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting“.

The article is a deep dive into the configuration, security and performance of SSRS and is closely related to the SSRS Performance Dashboard which I recently developed.

 

Feel free to explore the article and to take a look at

Continue reading […] Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting […]

 

SSIS service does not support multi-instance

I have a server with several SQL Server instances installed on it. Why can’t I connect to all instances of SSIS on my server? I can connect to the default instance, but not to the named instances.

The error I get is:

TITLE: Connect to Server
——————————
Cannot connect to MyServerName\test1.
——————————
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For

Continue reading […] SSIS service does not support multi-instance […]