database mirroring - correction to technet article requested

This is a very informative document:
http://www.microsoft.com/technet/pro.../dbmirror.mspx
However, I would like to request one correction:
Step 4 under "Setup and Security" indicates that you have to specify the
partner and the witness. It tells you to to issue "ALTER DATABASE...SET
PARTNER..." on the intended principal first. Then you execute the same
command on the intended mirror.
Problem:
I could not get it to work that way. When I set up Mirroring in my
environment (9.0.2153) I had to execute the command on the mirror first then
against the primary.
Keith Kratochvil
Hi Keith!
The early revisions of this document, I believe was based on a beta, so it is possible that the
behavior changed between that and production. Did you do a feedback at the bottom of that page?
(I see the same thing, btw, that you have to do mirror before principal...)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:u8enyNH9GHA.3820@.TK2MSFTNGP02.phx.gbl...
> This is a very informative document:
> http://www.microsoft.com/technet/pro.../dbmirror.mspx
>
> However, I would like to request one correction:
> Step 4 under "Setup and Security" indicates that you have to specify the partner and the witness.
> It tells you to to issue "ALTER DATABASE...SET PARTNER..." on the intended principal first. Then
> you execute the same command on the intended mirror.
> Problem:
> I could not get it to work that way. When I set up Mirroring in my environment (9.0.2153) I had
> to execute the command on the mirror first then against the primary.
>
> --
> Keith Kratochvil
>
>
|||argh. "Please limit comments to 256 characters"
I will try to be more to the point.
Keith Kratochvil
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:es8ewZH9GHA.3348@.TK2MSFTNGP03.phx.gbl...
> Hi Keith!
> The early revisions of this document, I believe was based on a beta, so it
> is possible that the behavior changed between that and production. Did you
> do a feedback at the bottom of that page?
> (I see the same thing, btw, that you have to do mirror before
> principal...)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:u8enyNH9GHA.3820@.TK2MSFTNGP02.phx.gbl...
>
|||> argh. "Please limit comments to 256 characters"
Like a SQL 6.5 varchar?
;-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OxGJasH9GHA.788@.TK2MSFTNGP05.phx.gbl...
> argh. "Please limit comments to 256 characters"
> I will try to be more to the point.
> --
> Keith Kratochvil
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:es8ewZH9GHA.3348@.TK2MSFTNGP03.phx.gbl...
>

Database Mail Works Locally but not from Web

I'm building a web site in Visual Web Developer Express on a SQL Server 2005 Developer Edition database, on XP Pro with IIS 5.1 up and running.

Database Mail is configured and works well from the VWD environment. I can launch the site locally from VWD and the stored procedures that call the database mail functions execute perfectly.

However, when I copy the site from the development folder under VWD to my IIS default web page, nothing is ever generated from database mail. I can open the site in IIS and everything looks like it's responding correctly (data updates, refreshes etc) but the behind-the-scenes processes that should be generating email traffic don't do anything.

Review of the database mail log through SQL Server Management Studio shows no activity at all during the timeframe of the "on line" IIS sessions, so it appears that the process isn't hearing anything calling it (or is ignoring the calls if they are happening).

Why would it work in one environment and not another on the same machine? Is there a setup configuration or permissions issue that I've missed somewhere?

Thanks in advance.

I suggest it is a permissions thing. I suggest this is asked in the development forums, in how to conifgure your website to talk to your database with the correct permissions.|||

You were correct, the sp_send_dbmail SPROC used by my stored procedure resides in the MSDB database. The default configuration does not include the ASPNET account with any permissions. Once I found the SPROC and granted Execute permission to ASPNET, everything started working as intended. It's magic!

Database Location Not on Design PC

OS = Windows XP Pro; VB6 Enterprise Edition; Crystal Reports XI Developers Edition.

I have designed and developed several CR reports on my PC at home. This is a "stand-alone" PC that is NOT connected to an internal network.

The production PC, that these reports are going on, the database is on a server. All the tables and field names are the same. The only difference is the location of the database.

After testing on my PC, is there any way to put the Server path in the Database Location so that I can create my setup package here at home?

Thanks,
SamGoto the menu Database->Set Database Location
Then map it to the current db and save the report