I am unable send attachemts from dataserver but without attachment can send mails.The problem arises only when there is an attachment. Same works fine in all the other servers with same configuration including the dbmail config.I am able access the same path with XP_CMDShell dir command.Any help would be greatly appreciated.
sql server error:
\Shared\softusers\Gautham\att.txt Msg 22051, Level 16, State 1, Line 0 Failed to open loopback connection. Please see event log for more information.
The description for Event ID ( 17052 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Severity: 16 Error:18456, OS: 18456 [Microsoft][SQL Native Client][SQL Server]Login failed for user ‘ABC-SQL\sqlaccount’..
Any help would be greatly appreciated.
Thanks in Advance.
asked Dec 16, 2009 at 04:58 AM in Default
It seems to me that the user ‘ABC-SQL\sqlaccount’ has not permission to the Shared where attachment is.
Configure DataBase Mail settings log to Verbose to see mor information about the error.
In the Books Online, in the sp_send_dbmail remarks, I found this, I hope its helps:
Database Mail uses the Microsoft Windows security context of the current user to control access to files. Therefore, users who are authenticated with SQL Server Authentication cannot attach files using @file_attachments. Windows does not allow SQL Server to provide credentials from a remote computer to another remote computer. Therefore, Database Mail may not be able to attach files from a network share in cases where the command is run from a computer other than the computer that SQL Server runs on.
Part 1: Can you show the code? Presumably you're calling sp_send_dbmail, in which case the attachment file name must be an absolute path.
Part2: An absolute path just means the whole path and file name, not just a relative path (like 'att.txt'). There's no default path that it starts with. A UNC path like you've used is fine as long as Shared is the machine name. If it's the name of the folder, you need the machine name at the front.
There are a few possibilities:
There could be something wrong with the profile you're using. Before you look into more complicated stuff, try sending a test message. In SSMS, right click on Management | Database Mail, and select Send Test E-Mail.
According to this forum post it could be that the attachment is too big or that Oracle could be causing problems.
Attachment size is limited to 1,000,000 bytes (about 1MB) by default. To increase it: in SSMS, right click on Management | Database Mail, select Configure Database Mail, choose View or change system parameters, and alter the Maximum File Size (Bytes).
Are the attachments held in a share?
answered Dec 16, 2009 at 10:21 AM
Step 1 : Make sure that you have sufficient permission on your shared location .
Step 2 : if your shared location on database server try to test this code by specifying the actual drive name instead of shared location. if that is in the other server it may be a double hoop problem. please provide me more details on the shared location.
answered Jan 29, 2010 at 08:54 AM