http://www.sqlmag.com/authors/author/author/5568739/rsscomment/5568739en-USFri, 25 May 2012 11:16:52 GMTFri, 25 May 2012 11:16:52 GMThttp://www.sqlmag.com/article/sql-server-reporting-services-ssrs/understanding-sql-server-reporting-services-authentication-141280#commentsAnchorWed, 18 Apr 2012 12:59:51 GMT
Excellent article]]>fbureyWed, 18 Apr 2012 12:59:51 GMThttp://www.sqlmag.com/article/sql-server-reporting-services-ssrs/understanding-sql-server-reporting-services-authentication-141280#commentsAnchorhttp://www.sqlmag.com/article/sql-server-reporting-services-ssrs/understanding-sql-server-reporting-services-authentication-141280#commentsAnchorTue, 21 Feb 2012 10:23:34 GMT
Nice article. A few comments: 1: If SSRS uses a different DNS namespace than the client, then Internet Explorer must have that namespace as a Trusted Site. IOW, accessing 'dev.reports.local' from 'client.mycompany.local' should have '*.reports.local' as a Trusted site. This will resolve the IE / FQDN issue in your bullet point. 2: If using a load-balanced configuration (or one that aliases the true identity of the SSRS hostname), you will need to set the BackConnectionHostNames or DisableLoopbackCheck registry entries (KB896861 / KB926642). 3: Like Sharepoint integrated SSRS, SCOM 2007 Reporting uses its own custom security extension. However, since it is not built-in like Sharepoint, it cannot be load-balanced. 4: A quick test to see if Kerberos is working would be to create a report that queries sys.dm_exec_connections on a remote SQL instance (providing it is properly configured for Kerberos), configuring the data source to use Windows Integrated security.]]>ron.klimaszewskiTue, 21 Feb 2012 10:23:34 GMThttp://www.sqlmag.com/article/sql-server-reporting-services-ssrs/understanding-sql-server-reporting-services-authentication-141280#commentsAnchorhttp://www.sqlmag.com/article/sql-server-integration-services-ssis/developing-integration-services-packages-high-performance-136428#commentsAnchorWed, 24 Aug 2011 09:10:55 GMT
The images are not shown.]]>pzhu1968Wed, 24 Aug 2011 09:10:55 GMThttp://www.sqlmag.com/article/sql-server-integration-services-ssis/developing-integration-services-packages-high-performance-136428#commentsAnchorhttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorWed, 06 Jul 2011 07:58:19 GMT
Awesome article! Thanks!]]>djenkins2003Wed, 06 Jul 2011 07:58:19 GMThttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorhttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorTue, 19 Apr 2011 06:04:34 GMT
Thanks really great article I have assignment to setup this enviroment and this article really helping me. Stacia can you guide me for any samples or article which provides hand on exercise on integration of dundas with reporting service 2008 as well . Appreciate your help always!]]>Monika GargTue, 19 Apr 2011 06:04:34 GMThttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorhttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorTue, 15 Mar 2011 06:23:17 GMT
Hello Stacia,
Its one of nice blog describing about what i need thanks for sharing this.
Also,I want to learn more about SharePoint and its integration with SQLServer2008 R2.
Please,some one provide some more specific link to learn more about sharepoint.

Thanks,
Anil Maharjan
]]>AnilTue, 15 Mar 2011 06:23:17 GMThttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorhttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorTue, 01 Mar 2011 11:39:55 GMT
Excellent Article Stacia !!!
You had covered complete configuration for SSRS 2008 R2 in SharePoint

Appreciate your help]]>TaiyebiTue, 01 Mar 2011 11:39:55 GMThttp://www.sqlmag.com/article/project-plan-sharepoint--sql-server-2008-r2-88/sql-server-2008-r2/reporting-services-2008-r2-and-sharepoint-server-2010-the-next-generation-of-integration#commentsAnchorhttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorThu, 24 Feb 2011 03:55:32 GMT
great article - much easier to follow than the MS documentation. In my case I am using SQL 2008 R2 and Sharepoint 2007, so I needed the MS documentation at hand to refer to now and again, but this article still applied for the most part.
If you are implementing the same versions as above, may need to run this step as well:
http://technet.microsoft.com/en-gb/library/bb677366.aspx
Thanks Stacia!

Doodles ]]>Neile BermudesThu, 24 Feb 2011 03:55:32 GMThttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorhttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchorFri, 10 Dec 2010 10:28:31 GMT
too short]]>joel peFri, 10 Dec 2010 10:28:31 GMThttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchorhttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchorThu, 01 Oct 2009 12:44:23 GMT
too short]]>ChrisThu, 01 Oct 2009 12:44:23 GMThttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorThu, 15 May 2008 14:17:01 GMT
Apologies for the late reply - I was traveling a great deal these last many weeks and unable to look at this sooner. You are right that the Reporting Services integration settings in Central Admin’s Application Management only allow you to specify Trusted Account or Windows Authentication, but there is another setting that has an impact: Application Management > Authentication Providers - hence the phrasing "MOSS Web application - not RS integration settins. Each Web application can be configured to use Windows, Forms, or Web single-sign on authentication. So if you DO NOT want to use Kerberos - you can do the following: - Trusted Account: Set Auth provider as Windows, set RS integration as Trusted Account, and then you MUST use a data source configured to use stored credentials. - Forms Authentication: Set Auth provider as Forms, set RS integration as Trusted Account, and then you MUST use a data source configured to use stored credentials - Windows Authentication with Trusted Accounts: Set Auth provider as Windows, set RS integration as Trusted Account, and then you MUST use a data source configured to use stored credentials AND selectthe stored credentials’ checkbox "use as Windows credentials" If you DO want to use Kerberos (or if RS and data source are on the same server), you do the following: - Set Auth provider as Windows, set RS integration settings as Windows Authentication AND set SharePoint to use delegation (see http://technet.microsoft.com/en-us/library/cc263284.aspx). The above is sufficient if you’re using a data source on same box with user credentials because the server isn’t forwarding the credentials. If you’re passing the credentials to another server, then you must configure Kerberos in your domain for the SharePoint server (a good resource for this is http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-conf iguration-for-sharepoint.aspx).]]>StaciaThu, 15 May 2008 14:17:01 GMThttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorWed, 02 Apr 2008 11:24:20 GMT
ckangai, thanks for your feedback. We’ve forwarded your comment to the author, Stacia Misner. She’s currently unavailable this week but said she’ll respond to your questions next week. Thanks for reading! Anne Grubb, Web site editor, SQL Server Magazine]]>AnneWed, 02 Apr 2008 11:24:20 GMThttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorSat, 29 Mar 2008 13:39:07 GMT
Useless: the dialog box in Central Administration has two options: Windows Authentication and Trusted Account. Why not have one paragraph describing Windows Authentication and when you use it, and a second paragraph describing Trusted Account and when you use it? Simple. Instead your first paragraph rambles on about Trusted Account, Forms Authentication, or Windows Authentication with Trusted Accounts. I am then left none the wiser.]]>CharlesSat, 29 Mar 2008 13:39:07 GMThttp://www.sqlmag.com/article/sql-server/the-differences-between-authentication-modes#commentsAnchorhttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorWed, 28 Nov 2007 15:02:49 GMT
This was perfect. Step by step and very detailed. THANKS!]]>NicoleWed, 28 Nov 2007 15:02:49 GMThttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorhttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorThu, 25 Oct 2007 13:01:14 GMT
I could really use some more info on how to run stand-alone and MOSS enabled reporting services on the same box.]]>MatthewThu, 25 Oct 2007 13:01:14 GMThttp://www.sqlmag.com/article/reporting2/information-integration-ssrs-and-moss-2007#commentsAnchorhttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchorSat, 06 Oct 2007 16:10:36 GMT
Too short.]]>DavidSat, 06 Oct 2007 16:10:36 GMThttp://www.sqlmag.com/article/sql-server/what-can-i-accomplish-with-other-sharepoint-technologies-#commentsAnchor