Shandy's Blog

Where Andrew Sutton, aka Shandy rants and rambles on as the fancy takes him
vbCity Blogs moved to:
http://cs.vbcity.com/blogs
  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 as a software developer. 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

OctNovember 2009Dec
SMTWTFS
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

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: