For those seeking to dive even deeper into the content you saw last week at the MSDN Event in Milwaukee, I have compiled some additional resources to assist you in your learning.
1) Granular security with Reporting Services
"Authorization is invoked when a user attempts to perform an operation on the system or a report server item through the SOAP API and through URL access"
[referenced from Using Forms Authentication in Reporting Services]
2) Test for network access prior to background update checks with ClickOnce
I asked my colleague Ken LeFebvre, who helped produce the content for this session. He informed me that as long as your locally cached copy is completely downloaded (i.e. no transfer issues prior to attempted execution), the application will execute using the existing version, whether or not you have connectivity. It is not expected to balk simply because your computer is not networked at the time you execute the application.
3) Hardcoding the database for HTTP Endpoints in Microsoft SQL Server 2005
For this one, I went to the source. Srik Raghavan is the lead program manager who oversees the development of the native web services in SQL Server 2005. I co-hosted a webcast with him back in December and turned to him for an answer to this question. He directed me to the mecca of SQL knowledge - the SQL Server 2005 Books Online. You'll likely want to focus specifically on the section entitled Using Native XML Web Services in SQL Server 2005. I drilled into this handy online reference and found an answer to the question. No, you are not required to hardcode a database for HTTP endpoints (see below). As a matter of fact, there is a whole lot more that you can do with these endpoints than was possible with previous versions of SQL Server 2005 beta.
"[ DATABASE
= {
'database_name' | DEFAULT } ]
Specifies the database in the context of which the requested operation is executed. If database_name is not specified or if DEFAULT is specified, the default database for the login is used."
To wrap up, let me know what you think about these responses to your questions. Did I hit the mark? Are you looking for more information? I am eager to hear your opinions to ensure that I am effectively replying to your queries.
Thanks in advance,
Jacob
