Shandy's Blog

Where Andrew Sutton, aka Shandy rants and rambles on as the fancy takes him

 This blog hosted by:
 http://blogs.vbcity.com      
  Home :: Syndication  :: Login
  Community Forums :: vbCity.com :: DevCity.NET

My name is Andrew Sutton, aka Shandy.

I am currently living and working in the UK within the garment industry as an IT specialist. This blog contains mainly IT related issues.

I was a Microsoft VB MVP for a couple of years (Apr 2004-Mar 2006) and was a vbCityLeader between April 2003 and June 2007.

If you are looking for my Sri Lanka or Morocco experiences check out Shandy's Sri Lanka Blog or Shandy's Morocco Blog. My personal (Non IT) blog is now at Shandy's Place

DecJanuary 2009Feb
SMTWTFS
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

Articles

Archives

Topics

Image Galleries

.NET

Blogs I Read

Others

VB.Classic

SQL Server 2005 : Using sp_send_dbmail With Attachments With a SQL Server Authenticated Username
In SQL Server 2000 I used a SQL Server authenticated user name to send emails with attachments using the xp_sendmail account. However, in SQL Server 2005 I was unable to get xp_sendmail working and after switching to using sp_send_dbmail I initially still couldn't get my SQL Server authenticated account to send emails with attachments. In the end I had to give the SQL Server authenticated account sysadmin rights. Not a very satisfactory solution but a lot easier than switching to using a windows authenticated account.

I'd be interested to hear if anyone has a more elegent solution

posted on Thursday, May 24, 2007 4:21 PM

Feedback

# re: SQL Server 2005 : Using sp_send_dbmail With Attachments With a SQL Server Authenticated Username 7/18/2007 5:17 PM siva
c#.net

Post Feedback

Title:
Name:
Url:
Comments: 
Protected by Clearscreen.SharpHIPEnter the code you see: