Database mirroring support also by SQL server 2005 without SP1

Hi All,

I get a general question about the feacture "Database Mirroring". Is it support by SQL Server Standard. Edition without SP1? Of i still need to upgrade the server from SQL Server 2005 to SQL Server 2005 with SP1?

Another question: are there any problem if the one machine(server) has installed SQL server 2005 Standard edition and the other with "Developer Editon".

I hope some one can answer my question. Thanks anyway!

Regards,

Pat

Yes, it's supported in SQL server 2005 standard edition. But by default it's disable. you must specify the trace flag 1400 as a startup parameter. Please refer http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=423000&SiteId=1 for more detail.

There should not be problem if one server is "standard edition" and other one is "developer edition".

|||

Hi All,

Anyone know or i still to install the SQL Server 2005 SP 1 first before i can use the feature "Database Mirroring"?

Best regards,

Pat

|||

I believe your question was answered by the above post

YES, you can do database mirroring in SQL2005, with or without SP1 (need to set trace flag 1400)

For your other question, mirroring between STD and DEV edition

This post should help, even though it's between STD and ENT (DEV IS Enterprise edition)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=730526&SiteID=1

|||

In non-SP1, Database mirroring exists, but it is not supported. What that means is that you are using it at your own risk. If it blows up and deletes allof your data, MS won't help you unless you are running SP1.

Database mirroring support also by SQL server 2005 without SP1

Hi All,

I get a general question about the feacture "Database Mirroring". Is it support by SQL Server Standard. Edition without SP1? Of i still need to upgrade the server from SQL Server 2005 to SQL Server 2005 with SP1?

Another question: are there any problem if the one machine(server) has installed SQL server 2005 Standard edition and the other with "Developer Editon".

I hope some one can answer my question. Thanks anyway!

Regards,

Pat

Yes, it's supported in SQL server 2005 standard edition. But by default it's disable. you must specify the trace flag 1400 as a startup parameter. Please refer http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=423000&SiteId=1 for more detail.

There should not be problem if one server is "standard edition" and other one is "developer edition".

|||

Hi All,

Anyone know or i still to install the SQL Server 2005 SP 1 first before i can use the feature "Database Mirroring"?

Best regards,

Pat

|||

I believe your question was answered by the above post

YES, you can do database mirroring in SQL2005, with or without SP1 (need to set trace flag 1400)

For your other question, mirroring between STD and DEV edition

This post should help, even though it's between STD and ENT (DEV IS Enterprise edition)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=730526&SiteID=1

|||

In non-SP1, Database mirroring exists, but it is not supported. What that means is that you are using it at your own risk. If it blows up and deletes allof your data, MS won't help you unless you are running SP1.

sql

database mirroring question

Is Asynchronous database mirroring support in the Standard Edition of
SQL 2005?
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JDJoeyD
If I remember well, database mirroring is supported only on Enterprise
Edition
"JoeyD" <joeydba@.gmail.com> wrote in message
news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
> Is Asynchronous database mirroring support in the Standard Edition of
> SQL 2005?
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>|||Synchronous mirroring is supported on Standard and Enterprise editions.
Asynchronous mode is only supported on Enterprise edition.
--
Paul Randal
Principal Lead Program Manager
Core Storage Engine, Microsoft SQL Server Team
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> JoeyD
> If I remember well, database mirroring is supported only on Enterprise
> Edition
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
>> Is Asynchronous database mirroring support in the Standard Edition of
>> SQL 2005?
>> I've read some docs that say it isn't. However, my manager saids that
>> he was told it was (or would work), something about 'single stream'? I
>> have not been able to find any docs that talks about 'single stream'.
>> Can anyone advise or point me in the right direction?
>> thanks all,
>> JD
>|||Thanks Paul for the reply. I've done some more testing on my own and
have found this to be true. Not sure what my manager had heard or where
he had heard it.
Joe
Paul S. Randal [MS] wrote:
> Synchronous mirroring is supported on Standard and Enterprise editions.
> Asynchronous mode is only supported on Enterprise edition.
> --
> Paul Randal
> Principal Lead Program Manager
> Core Storage Engine, Microsoft SQL Server Team
> http://blogs.msdn.com/sqlserverstorageengine/default.aspx
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> > JoeyD
> > If I remember well, database mirroring is supported only on Enterprise
> > Edition
> >
> >
> >
> > "JoeyD" <joeydba@.gmail.com> wrote in message
> > news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
> >> Is Asynchronous database mirroring support in the Standard Edition of
> >> SQL 2005?
> >>
> >> I've read some docs that say it isn't. However, my manager saids that
> >> he was told it was (or would work), something about 'single stream'? I
> >> have not been able to find any docs that talks about 'single stream'.
> >> Can anyone advise or point me in the right direction?
> >>
> >> thanks all,
> >> JD
> >>
> >
> >

database mirroring question

Is Asynchronous database mirroring support in the Standard Edition of
SQL 2005?
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JD
JoeyD
If I remember well, database mirroring is supported only on Enterprise
Edition
"JoeyD" <joeydba@.gmail.com> wrote in message
news:1168635799.710707.324810@.51g2000cwl.googlegro ups.com...
> Is Asynchronous database mirroring support in the Standard Edition of
> SQL 2005?
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>
|||Synchronous mirroring is supported on Standard and Enterprise editions.
Asynchronous mode is only supported on Enterprise edition.
Paul Randal
Principal Lead Program Manager
Core Storage Engine, Microsoft SQL Server Team
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> JoeyD
> If I remember well, database mirroring is supported only on Enterprise
> Edition
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:1168635799.710707.324810@.51g2000cwl.googlegro ups.com...
>
|||Thanks Paul for the reply. I've done some more testing on my own and
have found this to be true. Not sure what my manager had heard or where
he had heard it.
Joe
Paul S. Randal [MS] wrote:[vbcol=seagreen]
> Synchronous mirroring is supported on Standard and Enterprise editions.
> Asynchronous mode is only supported on Enterprise edition.
> --
> Paul Randal
> Principal Lead Program Manager
> Core Storage Engine, Microsoft SQL Server Team
> http://blogs.msdn.com/sqlserverstorageengine/default.aspx
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...

database mirroring question

Is Asynchronous database mirroring support in the Standard Edition of
SQL 2005?
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JDJoeyD
If I remember well, database mirroring is supported only on Enterprise
Edition
"JoeyD" <joeydba@.gmail.com> wrote in message
news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
> Is Asynchronous database mirroring support in the Standard Edition of
> SQL 2005?
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>|||Synchronous mirroring is supported on Standard and Enterprise editions.
Asynchronous mode is only supported on Enterprise edition.
Paul Randal
Principal Lead Program Manager
Core Storage Engine, Microsoft SQL Server Team
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...
> JoeyD
> If I remember well, database mirroring is supported only on Enterprise
> Edition
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:1168635799.710707.324810@.51g2000cwl.googlegroups.com...
>|||Thanks Paul for the reply. I've done some more testing on my own and
have found this to be true. Not sure what my manager had heard or where
he had heard it.
Joe
Paul S. Randal [MS] wrote:[vbcol=seagreen]
> Synchronous mirroring is supported on Standard and Enterprise editions.
> Asynchronous mode is only supported on Enterprise edition.
> --
> Paul Randal
> Principal Lead Program Manager
> Core Storage Engine, Microsoft SQL Server Team
> http://blogs.msdn.com/sqlserverstor...ne/default.aspx
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uh6Amz7NHHA.3916@.TK2MSFTNGP02.phx.gbl...sql

Database Mirroring Monitor Job Error

We have recently set up two SQL Server 2005 Standard Edition servers with database mirroring. The mirrors function and fail over without a problem, but the Database Mirroring Monitor Job fails every time with the following error message:

Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step failed.

Both SQL Servers are running SP2 with the latest patches.

Can you please let me know what we have to do to resolve this issue?

Thank you!

Bosko

Is this been like this since the invocation of Database mirroring on these instances?

If not see what has been changed since the last successful occurence.

|||The problems started upon implementation of the database mirroring|||

I'm also facing the same issue.

Did anyone find a solution or workaround?

|||

I posted this in a couple different forums/newsgroups and never got an answer. We are still having this problem.

Bosko

Database Mirroring Monitor Job Error

We have recently set up two SQL Server 2005 Standard Edition servers with database mirroring. The mirrors function and fail over without a problem, but the Database Mirroring Monitor Job fails every time with the following error message:

Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step failed.

Both SQL Servers are running SP2 with the latest patches.

Can you please let me know what we have to do to resolve this issue?

Thank you!

Bosko

Is this been like this since the invocation of Database mirroring on these instances?

If not see what has been changed since the last successful occurence.

|||The problems started upon implementation of the database mirroringsql

Database Mirroring Monitor Job Error

We have recently set up two SQL Server 2005 Standard Edition servers
with database mirroring. The mirrors function and fail over without a
problem, but the Database Mirroring Monitor Job fails every time with
the following error message:

Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect
syntax near the keyword 'with'. If this statement is a common table
expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step
failed.

Both SQL Servers are running SP2 with the latest patches.

Can anyone help with the resolutionto this this issue?

Thank you!
Bosko(bosko19@.gmail.com) writes:

Quote:

Originally Posted by

We have recently set up two SQL Server 2005 Standard Edition servers
with database mirroring. The mirrors function and fail over without a
problem, but the Database Mirroring Monitor Job fails every time with
the following error message:
>
Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect
syntax near the keyword 'with'. If this statement is a common table
expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step
failed.
>
Both SQL Servers are running SP2 with the latest patches.
>
Can anyone help with the resolutionto this this issue?

Eh, that looks bad. I haven't worked much with mirroring, or more precisely
not at all. But a syntax errors is not what I would expect. Could you
list the exact name of the servers and databases involved? My suspicion
is that there is a problem with special characters.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Apr 13, 6:45 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(bosk...@.gmail.com) writes:

Quote:

Originally Posted by

We have recently set up two SQL Server 2005 Standard Edition servers
with database mirroring. The mirrors function and fail over without a
problem, but the Database Mirroring Monitor Job fails every time with
the following error message:

>

Quote:

Originally Posted by

Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect
syntax near the keyword 'with'. If this statement is a common table
expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step
failed.

>

Quote:

Originally Posted by

Both SQL Servers are running SP2 with the latest patches.

>

Quote:

Originally Posted by

Can anyone help with the resolutionto this this issue?

>
Eh, that looks bad. I haven't worked much with mirroring, or more precisely
not at all. But a syntax errors is not what I would expect. Could you
list the exact name of the servers and databases involved? My suspicion
is that there is a problem with special characters.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

LOL...I didn't think it looked good either :)

The database server has a dash in it (i.e. CompanyName-SQL1 and SQL2
respecitvely). All databases are just alpha characters except for one
that begins with a number sequence (i.e. 1000DatabaseName).

Thank you in advance!

Bosko|||(bosko19@.gmail.com) writes:

Quote:

Originally Posted by

The database server has a dash in it (i.e. CompanyName-SQL1 and SQL2
respecitvely). All databases are just alpha characters except for one
that begins with a number sequence (i.e. 1000DatabaseName).

What service-pack level are you at? (For all three machines.)

If you are on SP2, you should definitely submit a bug on
http://connect.microsoft.com/SqlServer/. And if it's not an acceptable
workaround to rename the servers, I think you should open a case with
Microsoft, and demand that you get a hotfix.

If you are not on SP2, I recommend you to download it to see if it addresses
the problem. Note there is a rollup to SP2 which addresses two serious
bugs with maintenance plans. Make sure you get the rollup, if you use
maintenance plans.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog (esquel@.sommarskog.se) writes:

Quote:

Originally Posted by

What service-pack level are you at? (For all three machines.)

Sorry, I see now in your first post that you are on SP2.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Apr 16, 5:30 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Erland Sommarskog (esq...@.sommarskog.se) writes:

Quote:

Originally Posted by

What service-pack level are you at? (For all three machines.)

>
Sorry, I see now in your first post that you are on SP2.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thank you for taking the time to look into the issue! I will submit
the case to Microsoft and hopefully get a resolution from them.

Bosko

Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
IanDatabase mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.
> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian|||"Dan Guzman" wrote:
> Database mirroring is currently for evaluation only in standard, enterprise
> and developer editions. The plan is to fully support database mirroring in
> the first half of 2006.
> > Ideally, I'd like it to be available in Standard.
> It will be available in standard edition with the restrictions described in
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> > Hi all,
> >
> > I've been checking the editions comparison at the MS website for SQL
> > Server
> > 2005.
> >
> > http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> >
> > Under High Availability, I'm confused by the Database Mirroring entry. It
> > has a '1' by the actual Database Mirroring that, in the key, states "For
> > evaluation purposes only".
> >
> > Does this mean that mirroring is only available for evaluation full stop
> > or
> > only in certain editions? Ideally, I'd like it to be available in
> > Standard.
> >
> > Any ideas would be greatly appreciated.
> >
> > Cheers,
> >
> > Ian
Thanks Dan, that answers my question perfectly :-)
Cheers,
Ian

Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodin...e-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
IanDatabase mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.

> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodin...e-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian|||"Dan Guzman" wrote:
[vbcol=seagreen]
> Database mirroring is currently for evaluation only in standard, enterpris
e
> and developer editions. The plan is to fully support database mirroring i
n
> the first half of 2006.
>
> It will be available in standard edition with the restrictions described i
n
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
Thanks Dan, that answers my question perfectly :-)
Cheers,
Iansql

Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodinf...-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
Ian
Database mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.

> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodinf...-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian
|||"Dan Guzman" wrote:
[vbcol=seagreen]
> Database mirroring is currently for evaluation only in standard, enterprise
> and developer editions. The plan is to fully support database mirroring in
> the first half of 2006.
>
> It will be available in standard edition with the restrictions described in
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
Thanks Dan, that answers my question perfectly :-)
Cheers,
Ian

Database Mirroring - setting up the witness

SQL Server 2005 Standard Edition SP1 + .2153 hotfixes, Windows 2003 R2 SP1
Witness: SQL Server 2005 Developer Edition SP1 + .2153 hotfixes
Corporate stuff runs in the parent domain (including witness)
Hosted (client) servers run in the child domain(s).
I set up mirroring between two SQL2k5 boxes in our child domain. SQL Server
runs under a network account in the child domain. We run our corparate SQL
Servers under a different account in our parent domain.
I wanted to have the witness box (located in our corporate domain) monitor
the primary and mirrors in the various child domains. I am running into the
following error message: "The ALTER DATABASE command could not be sent to
the remote server instance 'TCP://Witness-Server.TheParentDomain.com:5022'.
The database mirroring configuration was not changed. Verify that the server
is connected, and try again."
I verified that the appropriate endpoints exist within the witness via the
following query: SELECT name, role_desc, state_desc FROM
sys.database_mirroring_endpoints
What am I doing wrong?
Keith KratochvilThe service accounts are most likely different between the two domains. You
need to add the service account of the witness to the SQL Server hosting the
principal and mirror and vice versa. You then have to grant CONNECT TO
permissions to the account for the Database Mirroring endpoint.
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23T73eWR0GHA.2036@.TK2MSFTNGP05.phx.gbl...
> SQL Server 2005 Standard Edition SP1 + .2153 hotfixes, Windows 2003 R2 SP1
> Witness: SQL Server 2005 Developer Edition SP1 + .2153 hotfixes
> Corporate stuff runs in the parent domain (including witness)
> Hosted (client) servers run in the child domain(s).
>
> I set up mirroring between two SQL2k5 boxes in our child domain. SQL
> Server runs under a network account in the child domain. We run our
> corparate SQL Servers under a different account in our parent domain.
> I wanted to have the witness box (located in our corporate domain) monitor
> the primary and mirrors in the various child domains. I am running into
> the following error message: "The ALTER DATABASE command could not be sent
> to the remote server instance
> 'TCP://Witness-Server.TheParentDomain.com:5022'. The database mirroring
> configuration was not changed. Verify that the server is connected, and
> try again."
> I verified that the appropriate endpoints exist within the witness via the
> following query: SELECT name, role_desc, state_desc FROM
> sys.database_mirroring_endpoints
> What am I doing wrong?
> --
> Keith Kratochvil
>
>

Database Mirroring - setting up the witness

SQL Server 2005 Standard Edition SP1 + .2153 hotfixes, Windows 2003 R2 SP1
Witness: SQL Server 2005 Developer Edition SP1 + .2153 hotfixes
Corporate stuff runs in the parent domain (including witness)
Hosted (client) servers run in the child domain(s).
I set up mirroring between two SQL2k5 boxes in our child domain. SQL Server
runs under a network account in the child domain. We run our corparate SQL
Servers under a different account in our parent domain.
I wanted to have the witness box (located in our corporate domain) monitor
the primary and mirrors in the various child domains. I am running into the
following error message: "The ALTER DATABASE command could not be sent to
the remote server instance 'TCP://Witness-Server.TheParentDomain.com:5022'.
The database mirroring configuration was not changed. Verify that the server
is connected, and try again."
I verified that the appropriate endpoints exist within the witness via the
following query: SELECT name, role_desc, state_desc FROM
sys.database_mirroring_endpoints
What am I doing wrong?
--
Keith KratochvilThe service accounts are most likely different between the two domains. You
need to add the service account of the witness to the SQL Server hosting the
principal and mirror and vice versa. You then have to grant CONNECT TO
permissions to the account for the Database Mirroring endpoint.
--
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23T73eWR0GHA.2036@.TK2MSFTNGP05.phx.gbl...
> SQL Server 2005 Standard Edition SP1 + .2153 hotfixes, Windows 2003 R2 SP1
> Witness: SQL Server 2005 Developer Edition SP1 + .2153 hotfixes
> Corporate stuff runs in the parent domain (including witness)
> Hosted (client) servers run in the child domain(s).
>
> I set up mirroring between two SQL2k5 boxes in our child domain. SQL
> Server runs under a network account in the child domain. We run our
> corparate SQL Servers under a different account in our parent domain.
> I wanted to have the witness box (located in our corporate domain) monitor
> the primary and mirrors in the various child domains. I am running into
> the following error message: "The ALTER DATABASE command could not be sent
> to the remote server instance
> 'TCP://Witness-Server.TheParentDomain.com:5022'. The database mirroring
> configuration was not changed. Verify that the server is connected, and
> try again."
> I verified that the appropriate endpoints exist within the witness via the
> following query: SELECT name, role_desc, state_desc FROM
> sys.database_mirroring_endpoints
> What am I doing wrong?
> --
> Keith Kratochvil
>
>sql

Database Mirroring

I'd like to verify that to use Asynchronous database mirroring is NOT
support for Standard Edition.
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JD
Standard Edition Database Mirroring is supported as follows:
Single REDO thread and the safety setting is always on.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
"JoeyD" wrote:

> I'd like to verify that to use Asynchronous database mirroring is NOT
> support for Standard Edition.
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>
sql

Database Mirroring

I'd like to verify that to use Asynchronous database mirroring is NOT
support for Standard Edition.
I've read some docs that say it isn't. However, my manager saids that
he was told it was (or would work), something about 'single stream'? I
have not been able to find any docs that talks about 'single stream'.
Can anyone advise or point me in the right direction?
thanks all,
JDStandard Edition Database Mirroring is supported as follows:
Single REDO thread and the safety setting is always on.
http://www.microsoft.com/sql/prodin...e-features.mspx
"JoeyD" wrote:

> I'd like to verify that to use Asynchronous database mirroring is NOT
> support for Standard Edition.
> I've read some docs that say it isn't. However, my manager saids that
> he was told it was (or would work), something about 'single stream'? I
> have not been able to find any docs that talks about 'single stream'.
> Can anyone advise or point me in the right direction?
> thanks all,
> JD
>

Database Maintenance

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. We setup a database maintenance (Database Integrity and Index,
Reorganize data and indexes, etc. ) to run every week. However, the report
shows that the maintenance job did not run because the database needs to be
in a single user mode. How do you setup a single user mode to run the
database maintenance? When the database maintenance is done, how do you
remove the single user mode? Thanks.
Uncheck the "Attempt to repair minor problems" checkbox. All this does is
hide problems until they become unfixable.
Run DBCC CHECKDB manually. You will find you have a problem. Fix the
problem. You will likely have to take the system offline to fix it.
Database corruption issues are very often due to disk subsystem failures.
Check on that and repair if necessary.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. We setup a database maintenance (Database Integrity and
> Index, Reorganize data and indexes, etc. ) to run every week. However,
> the report shows that the maintenance job did not run because the database
> needs to be in a single user mode. How do you setup a single user mode to
> run the database maintenance? When the database maintenance is done, how
> do you remove the single user mode? Thanks.
>
|||Thanks very much for your prompt response, Geoff.
If I run DBCC CHECKDB manually, what kind of problems do you expect that I
will encounter? Normally, are these problems easy to fix? Thanks.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>
|||How do you take the system offline to fix a problem?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>
|||Answering both responses.
I don't know what kinds of problems you will find. You can run DBCC CHECKDB
anytime, but it does create a significant load on the system. I would do it
at a low activity time. To do a repair, you first have to take the database
into single-user mode. Both topics are covered in BOL under DBCC CHECKDB
and DBCC DBREPAIR. I suggest you do a LOT of reading before trying
anything.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
> How do you take the system offline to fix a problem?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
>
|||Thanks very much for your prompt response, Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OKBZgjMOGHA.3576@.TK2MSFTNGP15.phx.gbl...
> Answering both responses.
> I don't know what kinds of problems you will find. You can run DBCC
> CHECKDB anytime, but it does create a significant load on the system. I
> would do it at a low activity time. To do a repair, you first have to
> take the database into single-user mode. Both topics are covered in BOL
> under DBCC CHECKDB and DBCC DBREPAIR. I suggest you do a LOT of reading
> before trying anything.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
>

Database Maintenance

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. We setup a database maintenance (Database Integrity and Index,
Reorganize data and indexes, etc. ) to run every week. However, the report
shows that the maintenance job did not run because the database needs to be
in a single user mode. How do you setup a single user mode to run the
database maintenance? When the database maintenance is done, how do you
remove the single user mode? Thanks.Uncheck the "Attempt to repair minor problems" checkbox. All this does is
hide problems until they become unfixable.
Run DBCC CHECKDB manually. You will find you have a problem. Fix the
problem. You will likely have to take the system offline to fix it.
Database corruption issues are very often due to disk subsystem failures.
Check on that and repair if necessary.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. We setup a database maintenance (Database Integrity and
> Index, Reorganize data and indexes, etc. ) to run every week. However,
> the report shows that the maintenance job did not run because the database
> needs to be in a single user mode. How do you setup a single user mode to
> run the database maintenance? When the database maintenance is done, how
> do you remove the single user mode? Thanks.
>|||Thanks very much for your prompt response, Geoff.
If I run DBCC CHECKDB manually, what kind of problems do you expect that I
will encounter? Normally, are these problems easy to fix? Thanks.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. We setup a database maintenance (Database Integrity and
>> Index, Reorganize data and indexes, etc. ) to run every week. However,
>> the report shows that the maintenance job did not run because the
>> database needs to be in a single user mode. How do you setup a single
>> user mode to run the database maintenance? When the database maintenance
>> is done, how do you remove the single user mode? Thanks.
>|||How do you take the system offline to fix a problem?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. We setup a database maintenance (Database Integrity and
>> Index, Reorganize data and indexes, etc. ) to run every week. However,
>> the report shows that the maintenance job did not run because the
>> database needs to be in a single user mode. How do you setup a single
>> user mode to run the database maintenance? When the database maintenance
>> is done, how do you remove the single user mode? Thanks.
>|||Answering both responses.
I don't know what kinds of problems you will find. You can run DBCC CHECKDB
anytime, but it does create a significant load on the system. I would do it
at a low activity time. To do a repair, you first have to take the database
into single-user mode. Both topics are covered in BOL under DBCC CHECKDB
and DBCC DBREPAIR. I suggest you do a LOT of reading before trying
anything.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
> How do you take the system offline to fix a problem?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
>> Uncheck the "Attempt to repair minor problems" checkbox. All this does
>> is hide problems until they become unfixable.
>> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
>> problem. You will likely have to take the system offline to fix it.
>> Database corruption issues are very often due to disk subsystem failures.
>> Check on that and repair if necessary.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "Diane Walker" <ett9300@.yahoo.com> wrote in message
>> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. We setup a database maintenance (Database Integrity and
>> Index, Reorganize data and indexes, etc. ) to run every week. However,
>> the report shows that the maintenance job did not run because the
>> database needs to be in a single user mode. How do you setup a single
>> user mode to run the database maintenance? When the database
>> maintenance is done, how do you remove the single user mode? Thanks.
>>
>|||Thanks very much for your prompt response, Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OKBZgjMOGHA.3576@.TK2MSFTNGP15.phx.gbl...
> Answering both responses.
> I don't know what kinds of problems you will find. You can run DBCC
> CHECKDB anytime, but it does create a significant load on the system. I
> would do it at a low activity time. To do a repair, you first have to
> take the database into single-user mode. Both topics are covered in BOL
> under DBCC CHECKDB and DBCC DBREPAIR. I suggest you do a LOT of reading
> before trying anything.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
>> How do you take the system offline to fix a problem?
>> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>> news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
>> Uncheck the "Attempt to repair minor problems" checkbox. All this does
>> is hide problems until they become unfixable.
>> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
>> problem. You will likely have to take the system offline to fix it.
>> Database corruption issues are very often due to disk subsystem
>> failures. Check on that and repair if necessary.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "Diane Walker" <ett9300@.yahoo.com> wrote in message
>> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. We setup a database maintenance (Database Integrity
>> and Index, Reorganize data and indexes, etc. ) to run every week.
>> However, the report shows that the maintenance job did not run because
>> the database needs to be in a single user mode. How do you setup a
>> single user mode to run the database maintenance? When the database
>> maintenance is done, how do you remove the single user mode? Thanks.
>>
>>
>

Database Maintenance

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. We setup a database maintenance (Database Integrity and Index,
Reorganize data and indexes, etc. ) to run every week. However, the report
shows that the maintenance job did not run because the database needs to be
in a single user mode. How do you setup a single user mode to run the
database maintenance? When the database maintenance is done, how do you
remove the single user mode? Thanks.Uncheck the "Attempt to repair minor problems" checkbox. All this does is
hide problems until they become unfixable.
Run DBCC CHECKDB manually. You will find you have a problem. Fix the
problem. You will likely have to take the system offline to fix it.
Database corruption issues are very often due to disk subsystem failures.
Check on that and repair if necessary.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. We setup a database maintenance (Database Integrity and
> Index, Reorganize data and indexes, etc. ) to run every week. However,
> the report shows that the maintenance job did not run because the database
> needs to be in a single user mode. How do you setup a single user mode to
> run the database maintenance? When the database maintenance is done, how
> do you remove the single user mode? Thanks.
>|||Thanks very much for your prompt response, Geoff.
If I run DBCC CHECKDB manually, what kind of problems do you expect that I
will encounter? Normally, are these problems easy to fix? Thanks.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>|||How do you take the system offline to fix a problem?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> Uncheck the "Attempt to repair minor problems" checkbox. All this does is
> hide problems until they become unfixable.
> Run DBCC CHECKDB manually. You will find you have a problem. Fix the
> problem. You will likely have to take the system offline to fix it.
> Database corruption issues are very often due to disk subsystem failures.
> Check on that and repair if necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:ubtudFMOGHA.2128@.TK2MSFTNGP10.phx.gbl...
>|||Answering both responses.
I don't know what kinds of problems you will find. You can run DBCC CHECKDB
anytime, but it does create a significant load on the system. I would do it
at a low activity time. To do a repair, you first have to take the database
into single-user mode. Both topics are covered in BOL under DBCC CHECKDB
and DBCC DBREPAIR. I suggest you do a LOT of reading before trying
anything.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
> How do you take the system offline to fix a problem?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23h63CRMOGHA.2268@.TK2MSFTNGP09.phx.gbl...
>|||Thanks very much for your prompt response, Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OKBZgjMOGHA.3576@.TK2MSFTNGP15.phx.gbl...
> Answering both responses.
> I don't know what kinds of problems you will find. You can run DBCC
> CHECKDB anytime, but it does create a significant load on the system. I
> would do it at a low activity time. To do a repair, you first have to
> take the database into single-user mode. Both topics are covered in BOL
> under DBCC CHECKDB and DBCC DBREPAIR. I suggest you do a LOT of reading
> before trying anything.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OLSGtcMOGHA.3924@.TK2MSFTNGP14.phx.gbl...
>

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe