Freebooting

remember a show on HBO a couple of decades ago called Not Necessarily The News? They had a segment called sniglets which has gotten popular in various media and emails. Its where you create alternative definitions for words or create/combine words to make new definitions. I heard this term being used at work in this manner. I got a giggle out of it. hope you do to!

Freebooting: The act of randomly rebooting multiple servers in the hope that your problem will go away.

Freebooter: One who frequently commits this act in order to save their job…

Windows Integrated Security in Reporting Services 2005

This issue has been tying me in knots. I am moving away from SQL authentication as CAC is the preferred method in the federal govt for accessing computers and servers. I also don't want to use no credentials. thats just nonsense. Unfortunately, I'm going to require users to use their network login barring my being directed to use a SQL account, not use credentialing which I'm loathe to do or Kerberos v5 is used. Therefore, users will have to enter their credentials until a better way is found. wish there was a workaround!

Windows Integrated Security
When you use the Windows Integrated Security option, the report server passes the security token of the user accessing the report to the server hosting the external data source. In this case, the user is not prompted to type a user name or password.

This approach is recommended if Kerberos is enabled. If Kerberos is not enabled, you should only use this approach if all the servers that you want to access are located on the same computer.

Error When Deploying a Large RS Report Model
by David Leibowitz | May 30, 2008

You may recieve the error during the deployment of a Reporting Services model:
There was an exception running the extensions specified in the config file.
Maximum request length exceeded.
To correct, you need to increase the file size limit currently in place in the web.config on the RS Server.
Find the web.config file located in the directory:
[SQL Server Directory]/[MSSQL RS Instance]/Reporting Services/ReportServer
Locate the node and add the attribute maxRequestLength and a number, or simply modify the value until you increase the limit such that you can deploy.
Mine looked like this when I was done:

Save the file and redeploy. You can switch it back if you like when you are done deploying.

Full attribute listing for httpRuntime here:
http://msdn.microsoft.com/en-us/library/e1f13641(VS.80).aspx
http://jetlounge.net/blogs/teched/archive/2008/05/30/error-when-deploying-a-large-rs-report-model.aspx