Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

RIL_button( “http://sqlconcept.com/2011/11/22/administrating-sql-server-reporting-services-planning-documenting-and-troubleshooting/”, “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

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

November 22nd, 2011 | Tags: , , , , , , , , , , , , , | Category: SSRS, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SSIS service does not support multi-instance

RIL_button( “http://sqlconcept.com/2011/09/22/ssis-service-does-not-support-multi-instance/”, “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

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

September 22nd, 2011 | Tags: , , , , , , | Category: SSIS | Comments are closed
Work on itWell, now...OKGoodGood job! (6 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...