Reposition Subtotals: sending

Showing posts with label sending. Show all posts

Wednesday, March 28, 2012

Resetting Email Queue

Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.
Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:

> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.
sql

Resetting Email Queue

Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 200
5
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:

> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even i
f
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2
005
> alse sends them - i have to prevent this.

Resetting Email Queue

Hi
I have a the database mail system parameters set to retry sending failed
emails every ten minutes. I want to leave these settings as is.
How can I reset the queue ? that is delete all items in the queue - even if
they have failed! I need to refresh/delete them because we send out the
emails manually if they failed tooo many times - and then eventually sql 2005
alse sends them - i have to prevent this.Answered my quesiton myself!
One can look at the default system stored procedure and modify it to accept
a subject for example as a parameter.
Then just tweak the rest of the stored procedure to make it select only mail
items with similar subjects and delete those!
done!
"I.W Coetzer" wrote:
> Hi
> I have a the database mail system parameters set to retry sending failed
> emails every ten minutes. I want to leave these settings as is.
> How can I reset the queue ? that is delete all items in the queue - even if
> they have failed! I need to refresh/delete them because we send out the
> emails manually if they failed tooo many times - and then eventually sql 2005
> alse sends them - i have to prevent this.

Wednesday, March 21, 2012

resend - transfer database to a new server

Sorry, I'm sending this again because I think it must be buried under week
old posts that no one will see. If I'm wrong please let me know.
I was able to successfully back up all the databases like master, model,
msdb, northwind, etc. I was also able to backup the four databases belonging
to the application. Restoring is not going as well. I first tried to restore
master, figuring that it is required first to inform SQL of the other
databases to come. It asked my to restart SQL in some single user mode which
I did. I then restored master. Now I can't start SQL. In the old computer
the databases were on E: and in the new they are on C:. So when I try to
start I get errors like this:
2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
device number (VDN) 1.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The system
cannot find the path specified.) during the creation/opening of physical
device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
device number (VDN) 1.
How can I recover (if I have to uninstall and reinstall I will) and what is
the correct sequence for restoring the databases?
Thanks.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
>
> Hi Bill,
>
> You have two easy choices:
>
> 1) Do a backup and restore the database on the other server
> 2) Detach the database and attach it on the other server
>
> On both cases you can look into the SQL Server documentation on how to
> accomplis these tasks, this is Books Online, located on Programs /
> Microsoft
> SQL Server / Books Online.
>
> Since you have a new server not used yet you will have enough time to test
> until you feel confortable with the procedure and test it.
>
> Be sure both SQL Server instalations are the same version including
> service
> packs and hotfixes.
>
> Finally you should apply a proper backup and restore procedure.
>
> Hope this helps,
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>
> "Bill Brehm >" wrote:
>
>> I don't know anything about SQL server.
>>
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>>
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>>
>> I will be able to kick everyone off the system and stop the SQL server if
>> necessary. If fact if it makes the task quicker and easier I would prefer
>> that.
>>
>> Thanks...
>>
>>
>>Bill
RESTORE the database WITH MOVE option (for more details please refer to the
BOL)
"Bill Brehm >" <<don't want any spam> wrote in message
news:ugDaDaXpGHA.4988@.TK2MSFTNGP04.phx.gbl...
> Sorry, I'm sending this again because I think it must be buried under week
> old posts that no one will see. If I'm wrong please let me know.
> I was able to successfully back up all the databases like master, model,
> msdb, northwind, etc. I was also able to backup the four databases
> belonging
> to the application. Restoring is not going as well. I first tried to
> restore
> master, figuring that it is required first to inform SQL of the other
> databases to come. It asked my to restart SQL in some single user mode
> which
> I did. I then restored master. Now I can't start SQL. In the old computer
> the databases were on E: and in the new they are on C:. So when I try to
> start I get errors like this:
> 2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
> device number (VDN) 1.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical
> file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may
> be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical
> file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may
> be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The
> system
> cannot find the path specified.) during the creation/opening of physical
> device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
> 2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
> device number (VDN) 1.
> How can I recover (if I have to uninstall and reinstall I will) and what
> is
> the correct sequence for restoring the databases?
> Thanks.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
>> Hi Bill,
>> You have two easy choices:
>> 1) Do a backup and restore the database on the other server
>> 2) Detach the database and attach it on the other server
>> On both cases you can look into the SQL Server documentation on how to
>> accomplis these tasks, this is Books Online, located on Programs /
>> Microsoft
>> SQL Server / Books Online.
>> Since you have a new server not used yet you will have enough time to
>> test
>> until you feel confortable with the procedure and test it.
>> Be sure both SQL Server instalations are the same version including
>> service
>> packs and hotfixes.
>> Finally you should apply a proper backup and restore procedure.
>> Hope this helps,
>> Ben Nevarez, MCDBA, OCP
>> Database Administrator
>>
>> "Bill Brehm >" wrote:
>> I don't know anything about SQL server.
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to
>> move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I
>> have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>> I will be able to kick everyone off the system and stop the SQL server
>> if
>> necessary. If fact if it makes the task quicker and easier I would
>> prefer
>> that.
>> Thanks...
>>
>
>|||This is a multi-part message in MIME format.
--080404050103090909090207
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Bill Brehm < wrote:
> Sorry, I'm sending this again because I think it must be buried under week
> old posts that no one will see. If I'm wrong please let me know.
> I was able to successfully back up all the databases like master, model,
> msdb, northwind, etc. I was also able to backup the four databases belonging
> to the application. Restoring is not going as well. I first tried to restore
> master, figuring that it is required first to inform SQL of the other
> databases to come. It asked my to restart SQL in some single user mode which
> I did. I then restored master. Now I can't start SQL. In the old computer
> the databases were on E: and in the new they are on C:. So when I try to
> start I get errors like this:
> 2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
> device number (VDN) 1.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
> 2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
> name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may be
> incorrect.
> 2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The system
> cannot find the path specified.) during the creation/opening of physical
> device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
> 2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
> e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
> device number (VDN) 1.
> How can I recover (if I have to uninstall and reinstall I will) and what is
> the correct sequence for restoring the databases?
> Thanks.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
>> Hi Bill,
>> You have two easy choices:
>> 1) Do a backup and restore the database on the other server
>> 2) Detach the database and attach it on the other server
>> On both cases you can look into the SQL Server documentation on how to
>> accomplis these tasks, this is Books Online, located on Programs /
>> Microsoft
>> SQL Server / Books Online.
>> Since you have a new server not used yet you will have enough time to test
>> until you feel confortable with the procedure and test it.
>> Be sure both SQL Server instalations are the same version including
>> service
>> packs and hotfixes.
>> Finally you should apply a proper backup and restore procedure.
>> Hope this helps,
>> Ben Nevarez, MCDBA, OCP
>> Database Administrator
>>
>> "Bill Brehm >" wrote:
>>
>> I don't know anything about SQL server.
>> We have one old PC running Windows NT and SQL server. I think it's a
>> standard edition. It is serving an accounting application. I want to move
>> to
>> a newer server before the old one goes bad (as it's already starting to
>> do).
>> The new server runs Windows 2000 Server. I have already installed SQL
>> server
>> (enterprise edition) on the new server.
>> So how do I go about moving the database over? I have browsed the
>> newsgroup
>> here and seen articles about backing up and restoring. But I don't even
>> know
>> how to do a proper backup and the articles don't say. (In the past I have
>> been backing up by stopping the SQL server and backing up the entire
>> directory including the database files. I figured that was a reasonably
>> safe
>> way to backup even though I would have no idea yet how to restore from
>> that.)
>> I will be able to kick everyone off the system and stop the SQL server if
>> necessary. If fact if it makes the task quicker and easier I would prefer
>> that.
>> Thanks...
>>
>>
>
>
Hi
Take a look at this article -
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
This might help get up and running again.
Additionally you should look at this link which tells you how to move
the databases - http://support.microsoft.com/kb/314546/en-us
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--080404050103090909090207
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bill Brehm < wrote:
<blockquote cite="midugDaDaXpGHA.4988@.TK2MSFTNGP04.phx.gbl" type="cite">
<pre wrap="">Sorry, I'm sending this again because I think it must be buried under week
old posts that no one will see. If I'm wrong please let me know.
I was able to successfully back up all the databases like master, model,
msdb, northwind, etc. I was also able to backup the four databases belonging
to the application. Restoring is not going as well. I first tried to restore
master, figuring that it is required first to inform SQL of the other
databases to come. It asked my to restart SQL in some single user mode which
I did. I then restored master. Now I can't start SQL. In the old computer
the databases were on E: and in the new they are on C:. So when I try to
start I get errors like this:
2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
device number (VDN) 1.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may be
incorrect.
2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The system
cannot find the path specified.) during the creation/opening of physical
device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
device number (VDN) 1.
How can I recover (if I have to uninstall and reinstall I will) and what is
the correct sequence for restoring the databases?
Thanks.
"Ben Nevarez" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:bnevarez@.sjm.com"><bnevarez@.sjm.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com">news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Hi Bill,
You have two easy choices:
1) Do a backup and restore the database on the other server
2) Detach the database and attach it on the other server
On both cases you can look into the SQL Server documentation on how to
accomplis these tasks, this is Books Online, located on Programs /
Microsoft
SQL Server / Books Online.
Since you have a new server not used yet you will have enough time to test
until you feel confortable with the procedure and test it.
Be sure both SQL Server instalations are the same version including
service
packs and hotfixes.
Finally you should apply a proper backup and restore procedure.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Brehm >" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I don't know anything about SQL server.
We have one old PC running Windows NT and SQL server. I think it's a
standard edition. It is serving an accounting application. I want to move
to
a newer server before the old one goes bad (as it's already starting to
do).
The new server runs Windows 2000 Server. I have already installed SQL
server
(enterprise edition) on the new server.
So how do I go about moving the database over? I have browsed the
newsgroup
here and seen articles about backing up and restoring. But I don't even
know
how to do a proper backup and the articles don't say. (In the past I have
been backing up by stopping the SQL server and backing up the entire
directory including the database files. I figured that was a reasonably
safe
way to backup even though I would have no idea yet how to restore from
that.)
I will be able to kick everyone off the system and stop the SQL server if
necessary. If fact if it makes the task quicker and easier I would prefer
that.
Thanks...
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
Hi 
 
Take a look at this article -
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/default.aspx?scid=kb;en-us;224071</a> ">http://support.microsoft.com/default.aspx?scid=kb;en-us;224071">http://support.microsoft.com/default.aspx?scid=kb;en-us;224071</a> 
This might help get up and running again. 
 
Additionally you should look at this link which tells you how to move
the databases - <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/kb/314546/en-us</a> ">http://support.microsoft.com/kb/314546/en-us">http://support.microsoft.com/kb/314546/en-us</a> 
 
 
 
-- 
Regards 
Steen Schlüter Persson 
Databaseadministrator / Systemadministrator 

</body>
</html>
--080404050103090909090207--|||Bill
Here are a few more articles that might help.
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles for
SQL Server
Regards
John
"Steen Persson (DK)" wrote:
> Bill Brehm < wrote:
> > Sorry, I'm sending this again because I think it must be buried under week
> > old posts that no one will see. If I'm wrong please let me know.
> >
> > I was able to successfully back up all the databases like master, model,
> > msdb, northwind, etc. I was also able to backup the four databases belonging
> > to the application. Restoring is not going as well. I first tried to restore
> > master, figuring that it is required first to inform SQL of the other
> > databases to come. It asked my to restart SQL in some single user mode which
> > I did. I then restored master. Now I can't start SQL. In the old computer
> > the databases were on E: and in the new they are on C:. So when I try to
> > start I get errors like this:
> >
> > 2006-07-11 09:31:36.34 spid10 FCB::Open failed: Could not open device
> > e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf for virtual
> > device number (VDN) 1.
> > 2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
> > name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
> > incorrect.
> > 2006-07-11 09:31:36.34 spid8 Starting up database 'syntrg'.
> > 2006-07-11 09:31:36.34 spid10 Device activation error. The physical file
> > name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf' may be
> > incorrect.
> > 2006-07-11 09:31:36.34 spid8 udopen: Operating system error 3(The system
> > cannot find the path specified.) during the creation/opening of physical
> > device e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf.
> > 2006-07-11 09:31:36.34 spid8 FCB::Open failed: Could not open device
> > e:\Program Files\Microsoft SQL Server\MSSQL\data\syntrg.mdf for virtual
> > device number (VDN) 1.
> >
> > How can I recover (if I have to uninstall and reinstall I will) and what is
> > the correct sequence for restoring the databases?
> >
> > Thanks.
> >
> >
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:B3DBFC04-0A32-4B7D-94FD-13C3B2173EB8@.microsoft.com...
> >
> >> Hi Bill,
> >>
> >> You have two easy choices:
> >>
> >> 1) Do a backup and restore the database on the other server
> >> 2) Detach the database and attach it on the other server
> >>
> >> On both cases you can look into the SQL Server documentation on how to
> >> accomplis these tasks, this is Books Online, located on Programs /
> >> Microsoft
> >> SQL Server / Books Online.
> >>
> >> Since you have a new server not used yet you will have enough time to test
> >> until you feel confortable with the procedure and test it.
> >>
> >> Be sure both SQL Server instalations are the same version including
> >> service
> >> packs and hotfixes.
> >>
> >> Finally you should apply a proper backup and restore procedure.
> >>
> >> Hope this helps,
> >>
> >> Ben Nevarez, MCDBA, OCP
> >> Database Administrator
> >>
> >>
> >> "Bill Brehm >" wrote:
> >>
> >>
> >> I don't know anything about SQL server.
> >>
> >> We have one old PC running Windows NT and SQL server. I think it's a
> >> standard edition. It is serving an accounting application. I want to move
> >> to
> >> a newer server before the old one goes bad (as it's already starting to
> >> do).
> >> The new server runs Windows 2000 Server. I have already installed SQL
> >> server
> >> (enterprise edition) on the new server.
> >>
> >> So how do I go about moving the database over? I have browsed the
> >> newsgroup
> >> here and seen articles about backing up and restoring. But I don't even
> >> know
> >> how to do a proper backup and the articles don't say. (In the past I have
> >> been backing up by stopping the SQL server and backing up the entire
> >> directory including the database files. I figured that was a reasonably
> >> safe
> >> way to backup even though I would have no idea yet how to restore from
> >> that.)
> >>
> >> I will be able to kick everyone off the system and stop the SQL server if
> >> necessary. If fact if it makes the task quicker and easier I would prefer
> >> that.
> >>
> >> Thanks...
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> Hi
> Take a look at this article -
> http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
> This might help get up and running again.
> Additionally you should look at this link which tells you how to move
> the databases - http://support.microsoft.com/kb/314546/en-us
>
> --
> Regards
> Steen SchlÃ¼ter Persson
> Databaseadministrator / Systemadministrator
>

Monday, March 12, 2012

Request for the permission of type System.Net.Mail.SmtpPermission

Hi all

I have some problems with sending Mail over System.Net.Mail ...
I have made a C# Class which sends mail, and it works fine.
Now I have added this assembly to SQL Server 2005,
I made the SQL function and so on.

When I try to run it I get the following message:
Msg 50000, Level 16, State 1, Procedure SendMail, Line 114
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Would be very very happy for any comments !!

Thanks and best regards
Frank UrayI just found out what to do ... :-)
Add "External access assembly" to the Login or role .|||

Hi,

how did you register the assembly in SQL Server (which security settings / safe/unsafe/external Access ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Can you send how i can do it? Please.

Request for the permission of type System.Net.Mail.SmtpPermission

Hi all

Would be very very happy for any comments !!

Thanks and best regards
Frank UrayI just found out what to do ... :-)
Add "External access assembly" to the Login or role .|||

Hi,

how did you register the assembly in SQL Server (which security settings / safe/unsafe/external Access ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Can you send how i can do it? Please.

Saturday, February 25, 2012

Repost - RS e-mailing attachments via SMTP

I can configure a working subscription to e-mail through my SMTP server when
sending only the LINK to a report BUT NOT if I attach the report to the
e-mail in say excel or xml format.
I have tested using a command line SMTP utility and have been able to send
both a plain text message and a plain text message wth an attachment so I
know the Mail server will accept it.
I'll include a copy of the log file from when the error occurs.
Anyone out there have something for me to check? I have done my research on
the web but not been able to find any solutions.
Travis
Here's the error from the log... I can't make much of it... Other than the
part that says "more details in the log files -->please see the log
files..." :-)
ReportingServicesService!emailextension!728!07/29/2004-07:32:05:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext reportContext, String historyID, Boolean
forRendering, Guid& reportID, Int32& executionOption, String&
savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot&
snapshotData, Guid& linkID, DateTime& historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)Is this with Lotus? I know there are some problems with Lotus discussed on
this newsgroup.
Bruce L-C
"REM7600" <rem7600@.hotmail.com> wrote in message
news:OibDe9JeEHA.996@.TK2MSFTNGP12.phx.gbl...
> I can configure a working subscription to e-mail through my SMTP server
when
> sending only the LINK to a report BUT NOT if I attach the report to the
> e-mail in say excel or xml format.
> I have tested using a command line SMTP utility and have been able to send
> both a plain text message and a plain text message wth an attachment so I
> know the Mail server will accept it.
> I'll include a copy of the log file from when the error occurs.
> Anyone out there have something for me to check? I have done my research
on
> the web but not been able to find any solutions.
> Travis
>
> Here's the error from the log... I can't make much of it... Other than
the
> part that says "more details in the log files -->please see the log
> files..." :-)
> ReportingServicesService!emailextension!728!07/29/2004-07:32:05:: Error
> sending email.
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
> Server has encountered a configuration error; more details in the log
> files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
> ception: The Report Server has encountered a configuration error; more
> details in the log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
> tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
> g userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
> tring userName, IntPtr userToken, Byte[] secDesc, ReportOperation
> requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
> romCatalog(CatalogItemContext reportContext, String historyID, Boolean
> forRendering, Guid& reportID, Int32& executionOption, String&
> savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot&
> snapshotData, Guid& linkID, DateTime& historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
> ItemContext reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
> Service rs, CatalogItemContext reportContext, ClientRequest session,
> JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
> effectiveParameters, String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
> sageBody(IMessage message, Notification notification, SubscriptionData
data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
> e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
> fication notification)
>
>|||Bruce,
It's MS Exchange 2000
Thanks
TR
> Is this with Lotus? I know there are some problems with Lotus discussed on
> this newsgroup.
> Bruce L-C|||Hi Travis,
Are you using the local \Pickup folder for your SMTP service? There
are several threads in this group discussing how to set this more
efficient delivery method up. There's a setting in the
RSReportServer.config file (in the \ReportServer folder of your
default SRS installation path) that will let you specify the path to
the local SMTP pickup folder. Search that config file for "SMTP" and
check the other postings in this group that have more detail on how to
change those settings.
If you already have the Pickup folder specified, you may have to
change the SMTP Delivery properties via the IIS snap-in. From the
Delivery tab, click the Advanced button, then put the IP address [in
square brackets] of your Exchange server in the "Smart host" box. In
addition, you may have to un-check the "Attempt direct delivery"
option for this to work, as I did.
-- Ian
"REM7600" <rem7600@.hotmail.com> wrote in message news:<OibDe9JeEHA.996@.TK2MSFTNGP12.phx.gbl>...
> I can configure a working subscription to e-mail through my SMTP server when
> sending only the LINK to a report BUT NOT if I attach the report to the
> e-mail in say excel or xml format.
> I have tested using a command line SMTP utility and have been able to send
> both a plain text message and a plain text message wth an attachment so I
> know the Mail server will accept it.
> I'll include a copy of the log file from when the error occurs.
> Anyone out there have something for me to check? I have done my research on
> the web but not been able to find any solutions.
> Travis|||Thanks... I'm out of office for a week. But I'll re-read when I get back
in and give it a whirl.
TR
> Are you using the local \Pickup folder for your SMTP service? There
> are several threads in this group discussing how to set this more
> efficient delivery method up. There's a setting in the
> RSReportServer.config file (in the \ReportServer folder of your
> default SRS installation path) that will let you specify the path to
> the local SMTP pickup folder. Search that config file for "SMTP" and
> check the other postings in this group that have more detail on how to
> change those settings.
> If you already have the Pickup folder specified, you may have to
> change the SMTP Delivery properties via the IIS snap-in. From the
> Delivery tab, click the Advanced button, then put the IP address [in
> square brackets] of your Exchange server in the "Smart host" box. In
> addition, you may have to un-check the "Attempt direct delivery"
> option for this to work, as I did.
> -- Ian
>
> "REM7600" <rem7600@.hotmail.com> wrote in message
news:<OibDe9JeEHA.996@.TK2MSFTNGP12.phx.gbl>...
> > I can configure a working subscription to e-mail through my SMTP server
when
> > sending only the LINK to a report BUT NOT if I attach the report to the
> > e-mail in say excel or xml format.
> >
> > I have tested using a command line SMTP utility and have been able to
send
> > both a plain text message and a plain text message wth an attachment so
I
> > know the Mail server will accept it.
> >
> > I'll include a copy of the log file from when the error occurs.
> >
> > Anyone out there have something for me to check? I have done my
research on
> > the web but not been able to find any solutions.
> >
> > Travis

Wednesday, March 28, 2012

Resetting Email Queue

Resetting Email Queue

Resetting Email Queue

Wednesday, March 21, 2012

resend - transfer database to a new server

resend - transfer database to a new server

Monday, March 12, 2012

Request for the permission of type System.Net.Mail.SmtpPermission

Request for the permission of type System.Net.Mail.SmtpPermission

Saturday, February 25, 2012

Repost - RS e-mailing attachments via SMTP

Reposition Subtotals

Blog Archive

About Me