Report Builder Hyperlink Column

If I have an entity that returns a column that has a URL in it like http://www.microsoft.com, can I make that a live hyperlink in a Report Builder tabular report?

No, this is not supported in this release.

You can create the report in Report Builder, then open it in Report Designer and modify it to get this behavior, however.

replications and stored procedures and sa account

I have just setup my first Transactional replication between twoservers. Next I needed to test what would happen if the live serverwent down.
I disconnected the live server and connected it to the backup server(doing all the ip setup bits as well). Then I tried running my web app.
The web app ran great. I can look at the data that was replicated. Myproblem is that I cannot seem to add any data. Ever time I try to run astored procedure, the web app crashes with 'sa' account login failed. Itried running the stored procedures through SQL Query Analyzer, and itsays the same thing.
I know there is no problem with the sa account, as I can view the datausing this. There are no permissions set on any of the objects in thedatabase. The only thing I can think of is that the replication hassomehow disabled the ability to add data to the replicated database.
Can anyone point out what is happening?
Foundan MSDN article which explains why this is happening. Solve the problem.