Database Mirroring Transport Error

Hi

I am trying to configure Database Mirroring. I had do set dbcc traceon(1400,-1) manually using tsql as the server does not start when configring the startup parameter using the advanced properties of sql server configuration using -T 1400.

After using the db-mirror properties and the wizard in management studio i get an error "database mirroring transport is disabled in the endpoint configuration". I also get this error when executing

alter database set partner="..."

Am I missing something?

Thanks

First, upgrade to SP1. You don't have to specify the 1400 trace flag.

But, to answer your question....

For RTM, you must specify the trace flag 1400 as a startup parameter; you cannot use traceon. I notice that you have a " " (space) between the -T and 1400. Get rid of that. Start up sqlservr.exe with -T1400.

Thanks,

Mark

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database mail setup

SQL server 2005 standard edition
Windows NT 5.1 [2600]
I am able to configure and test database mail. But when I am trying to
configure SQL Server Agent to use database mail I see only "guest" database
user. What am i missing?
ontario, canada
Where are you seeing only guest database user? It sounds
like you are looking in the wrong place.
To configure Agent to use database mail, select the
properties for Agent in Management Studio, go to Alert
System. Under mail session, select the checkbox for Enable
mail profile. Select Database Mail for the Mail System. And
then select the profile or one of the profiles you have
setup for database mail.
-Sue
On Fri, 10 Aug 2007 07:06:04 -0700, db
<db@.discussions.microsoft.com> wrote:

>SQL server 2005 standard edition
>Windows NT 5.1 [2600]
>I am able to configure and test database mail. But when I am trying to
>configure SQL Server Agent to use database mail I see only "guest" database
>user. What am i missing?

Database mail setup

SQL server 2005 standard edition
Windows NT 5.1 [2600]
I am able to configure and test database mail. But when I am trying to
configure SQL Server Agent to use database mail I see only "guest" database
user. What am i missing?
--
ontario, canadaWhere are you seeing only guest database user? It sounds
like you are looking in the wrong place.
To configure Agent to use database mail, select the
properties for Agent in Management Studio, go to Alert
System. Under mail session, select the checkbox for Enable
mail profile. Select Database Mail for the Mail System. And
then select the profile or one of the profiles you have
setup for database mail.
-Sue
On Fri, 10 Aug 2007 07:06:04 -0700, db
<db@.discussions.microsoft.com> wrote:
>SQL server 2005 standard edition
>Windows NT 5.1 [2600]
>I am able to configure and test database mail. But when I am trying to
>configure SQL Server Agent to use database mail I see only "guest" database
>user. What am i missing?

Database mail setup

SQL server 2005 standard edition
Windows NT 5.1 [2600]
I am able to configure and test database mail. But when I am trying to
configure SQL Server Agent to use database mail I see only "guest" database
user. What am i missing?
--
ontario, canadaWhere are you seeing only guest database user? It sounds
like you are looking in the wrong place.
To configure Agent to use database mail, select the
properties for Agent in Management Studio, go to Alert
System. Under mail session, select the checkbox for Enable
mail profile. Select Database Mail for the Mail System. And
then select the profile or one of the profiles you have
setup for database mail.
-Sue
On Fri, 10 Aug 2007 07:06:04 -0700, db
<db@.discussions.microsoft.com> wrote:

>SQL server 2005 standard edition
>Windows NT 5.1 [2600]
>I am able to configure and test database mail. But when I am trying to
>configure SQL Server Agent to use database mail I see only "guest" database
>user. What am i missing?

Database Mail

I am trying to configure Database Mail on a new installation of SQL Server 2005 and the 'DatabaseMailUserRole' does not exist.

How do I add this role to the server?
Hi,

mhmm, strange thing, but use this script to recreate the Role:

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'DatabaseMailUserRole' AND type = 'R')

CREATE ROLE [DatabaseMailUserRole] AUTHORIZATION [dbo]

HTH, Jens Suessmeyer

http://www.sqlserver2005.de

|||Jens,

Thanks for the reply.

I was able to add the role using your script and added a user with the following script -

sp_addrolemember @.rolename = 'DatabaseMailUserRole',
@.membername = '<user name>'

However, it only added the role to the default database. Is there a way to make this a server role that shows up for each database?

Thanks for your help. I'm sure glad there are smart people in the world.
|||Hi,

you only need the role in the msdb database in order to send mails.

HTH, Jens Suessmeyer.

http://wwww.sqlserver2005.de
|||

Jens,

Thanks very much. I think everything is setup now.

Regards,

Dan Holsonback

|||I am having similar problems - I just added the (missing) DatabaseMailUserRole using the example provided. Now I am trying to execute the code in the 'troubleshooting' box

sp_addrolemember @.rolename = "DatabaseMailUserRole',
@.membername = "administrator" (i'm trying to use the administrator email account).

Now I get the error "User or role 'administrator@.avnnb.ca' does not exist in this database." Just what exactly am I supposed to use as membername? I can't find a tiny bit of documentation to help me in this regard.

|||Sorry. no real problem. there was an antivirus program running on mail server, which was stopping the email from getting through.

Database Mail

I am trying to configure Database Mail on a new installation of SQL Server 2005 and the 'DatabaseMailUserRole' does not exist.

How do I add this role to the server?
Hi,

mhmm, strange thing, but use this script to recreate the Role:

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'DatabaseMailUserRole' AND type = 'R')

CREATE ROLE [DatabaseMailUserRole] AUTHORIZATION [dbo]

HTH, Jens Suessmeyer

http://www.sqlserver2005.de

|||Jens,

Thanks for the reply.

I was able to add the role using your script and added a user with the following script -

sp_addrolemember @.rolename = 'DatabaseMailUserRole',
@.membername = '<user name>'

However, it only added the role to the default database. Is there a way to make this a server role that shows up for each database?

Thanks for your help. I'm sure glad there are smart people in the world.
|||Hi,

you only need the role in the msdb database in order to send mails.

HTH, Jens Suessmeyer.

http://wwww.sqlserver2005.de
|||

Jens,

Thanks very much. I think everything is setup now.

Regards,

Dan Holsonback

|||I am having similar problems - I just added the (missing) DatabaseMailUserRole using the example provided. Now I am trying to execute the code in the 'troubleshooting' box

sp_addrolemember @.rolename = "DatabaseMailUserRole',
@.membername = "administrator" (i'm trying to use the administrator email account).

Now I get the error "User or role 'administrator@.avnnb.ca' does not exist in this database." Just what exactly am I supposed to use as membername? I can't find a tiny bit of documentation to help me in this regard.

|||Sorry. no real problem. there was an antivirus program running on mail server, which was stopping the email from getting through.

Database Mail

Is it possible to configure Database Mail in SQL Server 2005 to process incoming messages? For example , if you wanted to insert a record into a message table every time a mail was sent to the address sample@.widgets.not and/or possibly process some additional notifications based on the content/subject of the message. If anyone could point me to any articles (assuming it's possible) I would appreciate it.

Thanks!

Database Mail only supports sending mail in SQL Server 2005.