Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Mail Not Received Using SSRS Subcription


Hi,

         Im using Report subscription for delivering reports through E-mail to the users which is scheduled on hourly basis. Once the time reaches the status in "MY Subscription" is showing "Mail Sent to <usermailid>". But when checking the Mail inbox, no mails are received.What could be the reason?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
E-mail Received And Sent From SQL?
I would like to receive and send e-mail in SQL.

The environment is Exchange 2003, SQL 8, on MS SBS 2003.

The reason is more a practical one: I could tag messages with IDs to associate these with actions in the database. I am running a small shopping site, and instead of sending via Outlook, I want to us ASP to generate any message that is required, such as order confirmation, customer queries, actions with suppliers, etc.

Is there a system out there doing this? Has someone done it? What is the best way to set it up?

I am after a simple solution (if there is ever such a thing :) ) one table with e-mail, a XRef table which links the order / supplier / customer tables.

Any hint, idea, etc would be much appreciated.

Thanks and regards,
Max

View Replies !   View Related
Database Mail - Status Sent But Email Never Received
From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything.  I checked my SMTP Mail Server Logs and I saw no entry of my test email. 
I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported.
The msdb.dbo.sysmail_allitems shows my email status as "sent".
So what am I missing? What steps would you recommend for troubleshooting my problem?
Thank you,
Ric

View Replies !   View Related
SSRS 2005 E-mail Delivery
I have a report server set with an smtp account with Alias set to False but will not allow me to send e-mail outside the network. E-mail report delivery works fine to any e-mail with @mycompany.com but to an e-mail like @hotmail.com it gets rejected saying e-mail not recognized. I tried all config possibilities know to this man but nothing works. If long into the smtp server itself I can send e-mails outside of company. I'm thinking it may require a password from SSRS config but there is no place to put one. Any one know how to config SSRS to deliver e-mails to any and all e-mails accounts?

View Replies !   View Related
E-mail In SSRS Reports With Attachment
Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

 

View Replies !   View Related
Drop Subcription At Subscriber
Sql Server 2000. I had a merge publication setup on one table that replicated to several sql servers (all 2000 SP3). The publication was deleted on the publisher - but somehow - the subscription information is still on the subscribers. How can I remove them? When trying to delete the tables at the subscribers I get error that they are part of replication.

P.S. Other tables in the same database are part of different merge replication.

Thanks.

Abe

 

View Replies !   View Related
Schedule Subcription With Dynamic Parameter
Hi all,
 
I'm working with Schedule Subcription with parameter @startdate in SQL 2005 Standard version.  The @startdate is depend on user needs, I've tried to use DayAdd() function in the parameter but don't work.  How can I set the parameter in subcription to do it?
Thanks!

View Replies !   View Related
SSRS Subscriptions: The E-mail Address Of One Or More Recipients Is Not Valid.
Hi There,

 

I try to send a report by email using SSRS subscriptions with recipients defined in an outlook email group. if 1 or more emailid are not a valid ones then SSRS does not send the report to any other valid recipients but displays the bellow error message!

 

"The e-mail address of one or more recipients is not valid."

 

In corporate companies, it is a common to find in valid/locked emailids in email group lists which can  not be corrected.

 

Expected functionality: SSRS Subscriptions should send report email to other valid recipients in the mail group.

 

Could you please suggest a work around or fix the issue?

 

Thank you much in advance!

 

Regards,

Ramana

 

View Replies !   View Related
Permission Denied W/ E-mail Subscription W/ SSRS 2000
EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'.

The dbo user for the msdb has admin priviledges.  I'm stumped on what to do or look for.

Any suggestions?  Thanks!

View Replies !   View Related
IIS Error 405 HTTP_STATUS_BAD METHOD When Creating New Subcription
I found the sql Server mobile edition got a lot of isse on WIndows Vista, while following the tutorials on the web, I cannot create the new subcriptions on SQL Server Mobile database:

At the final stage of the wizard, I get this error message:

 

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (Error)
 Messages
 * IIS Error 405 HTTP_STATUS_BAD_METHOD: The HTTP verb used is not allowed.
 HRESULT 0x80004005 (28017)
 
 * The operation could not be completed.
 

- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

 

 

Any idea?

ALthought there are some thread have similar prolem:

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

 

, but that guy solved by installing MSSQL SP1, but I already installed it with SP1 & SP2.

View Replies !   View Related
SSRS 2005 Failure Sending Mail: Interface Not Registered
 

Hi all,
 
We receive this error from all subscriptons on this server. Any advice?
 
Error: "Failure sending mail: Interface not registered "
 
 
Thank you,
-Randy

View Replies !   View Related
Data Driven Subscriptions - E-mail Distribution (SSRS 2005)
Hello folks,

Does anybody have experience with e-mail distribution using Data Driven Subscriptions?
I want to build the following:

I have a table with names and e-mail addresses of people in my data warehouse. This table changes over time, more people will be added and data (for example e-mail addresses) can change.
I made 1 report that I want to mail to all the people in the table. This report contains 1 parameter; the e-mail address of a person.
So basically it€™s quite simple: I want to e-mail all the people in the table a personalized (by the parameter) report each month.

Can anybody tell me how I can achieve this with SSRS 2005(SSEE)? I know how to make a data driven subscription but how can I make one pending on the data in a table?


Any help would be appreciated. I will write a blog about this when I've done it so your input will not get lost.


Jorg

View Replies !   View Related
Data Driven Subscription Problem - (Not Able To See Subcription Tab In My Report Server)
Hi,
    Can someone please help me in getting, Data Driven Subscription option in my Report Server.(Not able to see Subscription tab)

My Server Details
1)    Operating System €“ Windows Server 2003, Enterprise Edition
2)    SQl Server 2000 Reporting Services €“ Standard Edition
3)    SQL Server 2000 €“ Enterprise Edition
4)    Have Enabled Application Server, IIS, ASP, and Front Page Extensions
5)    Visual Studio .net 2003

Appreciate your quick response. Please reply back.

Thanks
Mahesh

View Replies !   View Related
Unknown Token Received
I have a client using SQL 2k, SP2 (due application requirements, SP3 is notan option - the application vendor will not specify why). We are receiving:[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerConnection BrokenThere doesn't appear to be any rhyme or reason as to why this is happening.And...it shows it's ugly head at random places during execution. Has anyoneexperienced this also, or have any ideas on what to look for? I have seennumerous suggestions stating to upgrade from MDAC 2.6 to 2.7. At thispoint, I'm not sure if thats an option based on the vendors application(which by the way they no longer support!).Any ideas will be greatly appreciated.Greg

View Replies !   View Related
Messages Received In An Incorrect Sequence
Hi All
 
I am sending two messages across servers with in the same transaction but they are received in the incorrect sequence.
 
Message1 from service1 to service2 on contract1 with RELATED_CONVERSATION_GROUP = 'xxxxxxx'
Message2 from service1 to service2 on contract2 with RELATED_CONVERSATION_GROUP = 'xxxxxxx'
 
Message2 is always received first at the target and is causing our process to fail.
 
When I check the service2 definition contract2 is specified first. Can this be the issue? I tried to change this order by dropping the contracts from the service and adding again but it still keeps the same order.
 
Please help.

View Replies !   View Related
Received Message Constantly Processed.
Hello,

when is seemd that everything works some weird behaviours comes out.


I try to summarize the problem without to post the complete code.

Service Broker is set to have a dialog between two databases on the same SQL Server instance.

 

The Initiator queue has retention=on and there is an activation SP to handle errors and Target's end dialog message.

The Target queue has retention=off, MAX_READER =1 and there is an activation SP to receive the message (WAIT FOR (RECEIVE (1) ...), TIMEOUT 30000 and do something with this message (sample insert into a DB).

 

The conversation has a Timeout Dialog to end the dialog after a while.


The problem that the message is constantly processed. The Process doens't stop is I end the dialof after the processing either.

n.b.the Receive is within a Transation that I commit at the end.

 

some other informations that in the meanwhile I found out :

This was my complete WAIT FOR(RECEIVE :

 WAITFOR ( RECEIVE top(1) -- just handle one message at a time
                 @message_type=message_type_id, --the type of message received
  @messagetypename=message_type_name, 
  @message_body=message_body,      -- the message contents
  @dialog = conversation_handle    -- the identifier of the dialog this message was received on
FROM [TargetQueue]    
), timeout 1000;

if (@@ROWCOUNT = 0)
BEGIN
   COMMIT;
   BREAK;
END

IF I delet TIMEOUT 1000, everything works as expected ...
Inside if (@@ROWCOUNT = 0)BEGIN..END I wrote also an Insert into a table to see wheter the end of the queue was reached but this insert never occurs (neither with not without timeout)
I'm happy that it works what if this is the solution, it make no sense to me!

Any ideas?
Thank you!


M.B.



 

Thank you very much

M.B.

 

View Replies !   View Related
Received Error Code 0x80040e57
I've check out that this error code says: A literal value in the command overflowed the range of the type of the associated column.

I received the error message when inserting large block data into a image column in SQL Server 2000. As I know, image support max 2G data to store. I use the C code function below to insert the data:

DBCreateParamBinary (hStmt, "", DB_PARAM_INPUT,&(pMonitorDBData->SampDat),NUM_SAMPLES_SETDBMONITOR*sizeof(float64) );

in which, the NUM_SAMPLES_SETDBMONITOR*sizeof(float64) stands for the data length by byte. and ,&(pMonitorDBData->SampDat) stands for the pointer address of the data block. (pls note: NUM_SAMPLES_SETDBMONITOR*sizeof(float64) = 4096*8=32768 bytes)

In addation, I've tried to use certain numbers instead of "NUM_SAMPLES_SETDBMONITOR*sizeof(float64)", and I found I could only set this value up to 8003 bytes.  If 8003 above, this error message would be received.

What should I do with this issue? Any help?
Thanks a million!

View Replies !   View Related
Error Msg: Unknown Token Received From SQL Server
After completing a database restore I receive the error msg: "Unknown token received from SQL Server", along with SQL-DMO: ODBC SQLState HY000. Books online provides the following description for this error:

"The TDS stream from the server is invalid. This error is typically caused by a problem on the server. Check the SQL Server error log"

I don't see anything in the error log that points to this problem. I'm looking for possible causes for this error and any troubleshooting suggestions.

View Replies !   View Related
Toolbox Is All Grayed Out And IUIService Could Not Be Located Received
Every time I try to edit a Control flow or Data flow task I am getting the following error. My toolbox options are all grayed out also.

 TITLE: Microsoft Visual Studio
------------------------------

The service System.Windows.Forms.Design.IUIService could not be located.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=UnableToLocateService&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Any help is appreciated

Gulden

View Replies !   View Related
&#34;Unknown Token Received From SQL Server. Error Code -1&#34;
Has anyone ever seen this error?


[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server. Error code -1.

It comes after doing a select statement
'select ID from SmUserGroup where UserID = (select UserID from SmUser where Name = 'clarken') and GroupID = (select GroupID from SmGroup where Name = 'Everyone'

A short time ( less than one minute) after this we see
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.. Error code -1


Any help would be greately appreciated.

Paul

View Replies !   View Related
DTS RunTime Error &#34;received Invalid Column Length From BCP Client&#34;
when i tried to run a DTS which transfer bulk data between 2 SQL servers, i got following error message:
================================================== ============
Error: -2147467259 (80004005); Provider Error: 4815 (12CF)
Error string: Received invalid column length from bcp client.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
================================================== ===========

if anybody has encounter the same problem before? after testing, i think it's
must related with network traffic problem. but i can not figure out how to solve it.

View Replies !   View Related
SQL Server 2000 Error 17805 Invalid Buffer Received From Client
Hi,I've developed an ASP.NET application which uses MS-SQL Server 2000 as abackend. But as the site hits increase SQL server reponse becomes lower.At some stage after that SQL Server gets automativally stopped bringingcomplete web-application down to halt. i checked the Windows 2000 EventLogs and found several error logs indicating folloowing line."SQL Server 2000 Error 17805 Invalid buffer received from client.". Butno errors on UI side. What may be the actual problem.In storedproceduresor at some other place?Awaiting favourble reply.Regards,Amit*** Sent via Developersdex http://www.developersdex.com ***

View Replies !   View Related
Error: 17805, Severity: 20, State: 3 Invalid Buffer Received From Client.
Howdy Folks,
Our site has been experiencing this issue for a couple of months now.. Hopefully someone else can assist, as I’ve got to a point where I think issue lies within the application or a Microsoft bug. Web searches have reveled a number installations that have also had this error but its has not revealed an actual fix.

I understand this error code basically means data being returned to the client is getting either corrupted or the data is too large to fit into the buffer on the client side. Client in our case is the terminal server, here after called a application server

As the user base has increased form 5 to 20, I have noticed that the issue is occurring more frequently in comparison to when the company first started using the application /database. Its just about daily now...

The db server also has 8 other db's residing on it - but they are all less than 300 meg.

The attached PowerPoint doc has the trace info & the surrounding code for each process that has suffered a buffer error over a period of a week.

DB Server Environment: Win2000 SP4, SQL2000 SP3a, MDAC 2.7 SP1 refresh.
Application Environment: Written In house in VB.NET Framework 1.1 – setup as a published app on a terminal server – running windows 2000 SP4

Common features of the issue, that have been omitted from trace output for visibility reasons are:
-Involves 1 particular DB (thats accessed by VB app) & its developement db
-All connections are coming from 1 application server
-Issue does not relate to any particular site connecting to the application server using this application

I have reviewed & fixed several potential server side causes but this error still is occuring with in the environment:

MDAC versions must be common on application & server:
- Removed from equation by updating MDAC version on App server to be the same as DB Server: 2.7 SP1 Refresh

Network related
- Considered unlikely; we are also not experiencing network card errors on either server; also all db's would be experiencing connectivity errors.

Which leaves us with Application related options to review:
- Compilation error of application
- App parameter definitions to stored procedures are the correct data type
- Ensure values being passed do not exceed 4000 characters as that has also been known to create this error message
- I've asked the developer to review MS KB 827366 article, as it may be a valid test
- In regard to MSKB 832977 - I am not using pssdiag & have a later version of the MS Analyzer. But what I thought was interesting, is the statement that this problem occurs more frequently when an application submits a large remote procedure call (RPC) input buffer, especially when the RPC input buffer is greater than or equal to 8 KB. However, this problem may occur even if the input buffer is less than 4 KB
- A is using datatypes varchar & char - not nvarchar & nhar

Any assistance with this issue would be appreicated as server performance is being effected - these processes hang around for 1 - 5 mins before terminating (refer duration times in the powerpoint traces)

Thanks In advance

Suze.

View Replies !   View Related
Bulk Copy Error: Received Invalid Row Length X From Bcp Client. Minimum Row Size Is Y
Hi,I am attempting a bulk copy from a c program into SQL Server 2000 usingDBLib in freeTDS 0.63 RC11 (gcc 3.4.3, RH 9). I am getting an error messagethat I cannot find any documentation on.The server is sending back the following: "Received invalid row length 2from bcp client. Minimum row size is 4."I know the row is longer 2 bytes (see below). Once this happened I created atest table and C program. See below. Anyone with any ideas?ThanksProgram output ---------------->$ ./test_bcpbcp'ing This is a test with a length of 14sentMsg 4807, Level 16, State 1Server 'CENTIVIA_10', Line 1Received invalid row length 2 from bcp client. Minimum row size is 4.done<----------------------Table ddl --------------------->CREATE TABLE [xxx] ([col2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]GO<------------------------------------Compiled using gcc ------------------->gcc -g -I/home/test_user/dev/freetds-0.63RC11/include -Wall -Wno-strict-aliasing-g -O2 -c -o test_bcp.o test_bcp.cgcc -o test_bcp test_bcp.o -L/home/test_user/lib -lsybdb<----------------------------------program source (included the msg and error handlercode) -------------------------->#include <string.h>#include <stdio.h>#include <stdlib.h>#include <sqldb.h>intsyb_msg_handler(DBPROCESS * dbproc, DBINT msgno, int msgstate, int severity,char *msgtext, char *srvname, char *procname, int line){char var_value[31];int i;char *c;if (msgno == 5701 || /* database context change */msgno == 5703 || /* language changed */msgno == 5704) { /* charset changed */if (msgtext != NULL && (c = strchr(msgtext, ''')) != NULL){i = 0;for (++c; i <= 30 && *c != '' && *c != '''; ++c)var_value[i++] = *c;var_value[i] = '';}return 0;}if (severity >= 0 || msgno == 0) {if (msgno > 0 && severity > 0) {fprintf(stdout, "Msg %d, Level %d, State %d",(int) msgno, (int) severity, (int) msgstate);fprintf(stdout, "Server '%s'", srvname);if (procname != NULL && *procname != '')fprintf(stdout, ", Procedure '%s'",procname);if (line > 0)fprintf(stdout, ", Line %d", line);fprintf(stdout, "");fprintf(stdout, "%s", msgtext);fflush(stdout);} else {fprintf(stdout, "%s", msgtext);fflush(stdout);}}return 0;}intsyb_err_handler(DBPROCESS * dbproc, int severity, int dberr, int oserr, char*dberrstr, char *oserrstr){if (dberr == SYBESMSG)return INT_CANCEL;env_set(g_env, "batch_failcount", "1");fprintf(stdout,"DB-LIBRARY error (severity %d, dberr %d, oserr %d, dberrstr%s, oserrstr %s):",severity, dberr, oserr, dberrstr ? dberrstr : "(null)",oserrstr ? oserrstr : "(null)");fflush(stdout);if ((dbproc == NULL) || DBDEAD(dbproc)) {if (dberr != SYBECOFL) {exit(255);}}return INT_CANCEL;}int main(int argc, char *argv[]){DBPROCESS *dbproc;LOGINREC *login;DBINT test_int = 99999999;DBCHAR test_char[32] = "This is a test";dbinit();dberrhandle(syb_err_handler);dbmsghandle(syb_msg_handler);login = dblogin();DBSETLPWD(login, "audit");DBSETLUSER(login, "audit");dbproc = dbopen(login, "192.168.58.1");dbuse(dbproc, "audit_dev");bcp_init(dbproc,"xxx", (BYTE *)NULL, (BYTE *)NULL, DB_IN);printf("bcp'ing %s with a length of%d",test_char,strlen(test_char));//ii = bcp_bind(dbproc, (BYTE *) &test_int, 0, -1, NULL, 0, SYBINT4,1 );//printf("bound %d",ii;bcp_bind(dbproc, test_char, 0, strlen(test_char), NULL, 0, SYBCHAR,1 );bcp_sendrow(dbproc);printf("sent");bcp_batch(dbproc);printf("done");return 0;}<---------------------------------

View Replies !   View Related
Directory Connection Failed Received On RTMT Toll Used To Monitor Call Manager
 

Hi All,
 
We use Cisco Call Manager 4.1(3), We use RTMT Tool to monitor our devices & now Daily once i get a error message as Directory connection failed . Monitored precanned object has value of 0., can anyone tell me what could be the excat cause or how can we troubleshoot this issue or what services should we check on our call manager to overcome this error.
 
 
Thanks & Regards
Sameer P Khakhar

View Replies !   View Related
Error Received In Sql Server Reporting Services Configuration Tool When Changing Encryption Key.
 I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
 
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

I don't want to loose any data. Please help me resolving this error.

FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.

Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.

View Replies !   View Related
Connect 2 DropDownList And Received &"Input String Was Not In A Correct Format&"
I have 2 DropDownList, the first one to display the product category and the other one to display the products based on the selected category. However, when I run code I received the following error message: Input string was not in a correct format.
Please find the code below.
Thanks,
Andy.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="Name" DataValueField="Name">
</asp:DropDownList>
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Assignment2ConnectionString %>"
SelectCommand="SELECT [Name] FROM [Category]"></asp:SqlDataSource>
<br />
 
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Name" DataValueField="Name">
</asp:DropDownList>
 
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Assignment2ConnectionString %>"
SelectCommand="SELECT [Name] FROM [Product] WHERE ([CategoryID] = @CategoryID2)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="CategoryID2" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
 
</div></form>
</body>
</html>

View Replies !   View Related
Setting Up Ms Sql Mail And Ms Sql Agent So I Can Send/ Receive Mail And Utilize Pager Notifications
Subject: Setting up Ms sql mail and Ms sql Agent so I can send/ receive mail and utilize pager notifications

hi, it seem that I need to have a MAPI( some kind of email software I guess)correct me if I am wrong, in order to use sql mail.
Here what I did ,

1. I created a domain name account for Mssql server services
2. I created a domain name account for Sql server Agent services

I guess In order to use MS sql I need to install a client email. so I can choose either (1)MS exchange server or (2) Ms window NT mail or (3) a post office protocol 3 (POP3) server

WHERE can I get a client email and which one is the easiest to set up

After to install the email client, I guess I need to create the following:
1. a post office connection
2. a mail store (mailbox)
3. a mail profile
4. a Ms windows NT domain user account to log in to Ms sql server


One more question. In order to use pager notification from ms sql agent, Do I need to have a third party pager-to email software.
What I am trying to do is to set up SQL mail and pager notification to work and I really do not know how. I do apprecite your help.If anyone has done such set up , please send me some guide lines,advice and feedback.
Thanks

Ali

View Replies !   View Related
Setting Up Ms Sql Mail And Ms Sql Agent So I Can Send/ Receive Mail And Utilize Pager Notifications
hi, it seem that I need to have a MAPI( some kind of email software I guess)correct me if I am wrong, in order to use sql mail.
Here what I did ,

1. I created a domain name account for Mssql server services
2. I created a domain name account for Sql server Agent services

I guess In order to use MS sql I need to install a client email. so I can choose either (1)MS exchange server or (2) Ms window NT mail or (3) a post office protocol 3 (POP3) server

WHERE can I get a client email and which one is the easiest to set up

After to install the email client, I guess I need to create the following:
1. a post office connection
2. a mail store (mailbox)
3. a mail profile
4. a Ms windows NT domain user account to log in to Ms sql server


One more question. In order to use pager notification from ms sql agent, Do I need to have a third party pager-to email software.
What I am trying to do is to set up SQL mail and pager notification to work and I really do not know how. I do apprecite your help.If anyone has done such set up , please send me some guide lines,advice and feedback.
Thanks

Ali

Ali

View Replies !   View Related
DB Mail And Notify Operator Through DB Mail Error Could Not Retrieve Item From The Queue
I've set up DB mail and sent a test e-mail and that comes through fine.

I set up an Operator with email Name: DWhelpton@k-and-s.com;MWeaver@k-and-s.com

I created a job and set up the notifications to e-mail the operator on failure.

When the job runs and fails, I do not get an e-mail and I get the following exception in the db mail log:

Date  2/2/2007 8:35:00 AM
Log  Database Mail (Database Mail Log)

Log ID  402
Process ID  3936
Last Modified  2/2/2007 8:35:00 AM
Last Modified By  NT AUTHORITYSYSTEM

Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Could not retrieve item from the queue.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
   at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)


What step am I missing?

View Replies !   View Related
SQL-DMO: SQL Server Agent Properties - Mail Session - Mail Profile
Hello to all:Under Enterprise Manager, select server, select management, right-clickon sql server agent. On the general tab, observe the mail session.Using SQL-DMO, how can I find the mail profile? I've combed the helpfile and the net without any luck.

View Replies !   View Related
XP_sendmail Puts Copy Of Mail In Sent Mail Of Exchange Client.
I am using nt4.0 sp5 with sql7.0 sp3 and exchange client.
Does anyone know how to keep xp_sendamil form putting a copy of the mail message in the sent mail folder or an automated process for deleting all mail in the sent folder? As it stands now I must manually delete all messages from the sent mail folder on a daily basis.

Thanks,

Ed.

View Replies !   View Related
SMTP Database Mail Showing Error While Sending Mail
Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:

Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.).
),3000,90,,3/5/2007 3:16:07 PM,sa


but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.


Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."

View Replies !   View Related
SSIS Send Mail Task - Failure Sending Mail
Hi Everyone,

Hopefully someone out there will have an idea as this is driving me nuts.

I've setup a task to email on success/failure and keep receiving the following message when executed:

Progress: The SendMail task is initiated. - 0 percent complete
[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".
Progress: The SendMail task is completed. - 100 percent complete
Task Send Mail Task failed

When I configure Outlook Express on the same machine with the same settings it works.

On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL.

On the Send Mail Task, it uses the above connection. The To: , From: , Subject  fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc.

Nothing useful is logged in the Event Viewer even with full logging turned on.

Any suggestions appreciated,

Thanks.

 

 

 

 

 

View Replies !   View Related
SSIS Send Mail Task - Failure Sending Mail
Dear all,
I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail.
but still the Mail Task is failing..
plz suggest.
 

View Replies !   View Related
Ssis Bulk Insert Failed &"Received An Invalid Column Length From Thebcp Client...&".
I am trying to bulk load a flat file into a SQL server table (2005)using the integration services. I got the following error:[OLE DB Destination [190]] Error: An OLE DB error has occurred. Errorcode: 0x80004005. An OLE DB record is available. Source: "MicrosoftOLE DB Provider for SQL Server" Hresult: 0x80004005 Description:"Received an invalid column length from the bcp client for colid54.".This has happened before also. Once I close the particular SSISpackage and open the same package again, and when I execute again, itworked fine.Now, I have 21 million records that needs to be loaded to a table, ittook about 45 minutes to read and during the final commit, I got theabove error message. It might work, if I close and open; I have nottried. Has anyone come across this error? Please let me know if Ineed to change anything.Thank you,Geetha.

View Replies !   View Related
Database Mail With Yahoo Business Mail Server
Hi all....

Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help

Thanks

Rajesh

View Replies !   View Related
Configure SMTP Server Mail To Send Mail
Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.

View Replies !   View Related
Sending Mail To Several Users With Send Mail Task ?
I know you can specify additional recipients in the To column by sepperating them with a semicolon. But whats the easiest way to send to several users, when the email address must be retrieved from a table with a query like this: 

select email from problem_subscribers

where project = 'project1'

and statusmail = 'OnError'

So when the eventhandler gets an OnError i want the mail task to be sent to each problemsubscriber.

 

 

View Replies !   View Related
Error Sending Mail With Send Mail Task
I keep getting a generic "Error Sending Mail" error. For testing purposes I am just trying to send using my own email account. What goes in the SMTP Server box in the connection manager? I have tried:
 
A - the exchange server address (SOMETHING.us.company.com)
B - The SMTP properties I see when I look at the properties of my email address: (my.name@abcd.efgh.company.com)
C - Just the end portion of the SMTP properties: (abcd.efgh.company.com)
D - My email address (my.name@company.com)
 
I don't know what to enter, or what is giving me such a generic error message.

View Replies !   View Related
Help With Mail That Send Mail When Database Bakcup Fails
Hello

I have got a script which gives the mail to the dba mail box when database backup fails.

In the script I want to make a change so that I get the particular database name , on what ever database i implement.

Can you tell me some suggestions.

The script I am using is :

 

use master
go
alter PROCEDURE dbo.SendMail
@to VARCHAR(255),
@subject VARCHAR(255),
@message VARCHAR(8000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@rv INT,
@from VARCHAR(64),
@server VARCHAR(255);
SELECT
@from = 'testsql2000@is.depaul.edu',
@server = 'smtp.depaul.edu';


select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13)

EXEC @rv = dbo.xp_smtp_sendmail
@to = @to,
@from = @from,
@message = @message,
@subject = @subject,
@server = @server;
END
GO

 


--- After the above script is run the following should be given in the 2nd step when
--- the backup jobs are scheduled ------

exec master.dbo.sendmail
   @to = 'dvaddi@depaul.edu',
  @subject =' Test sqlserver 2000',
  @message = '' ;


 

Thanks

 

View Replies !   View Related
Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
 
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
 
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too.  So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC.  Next I run the SQL 2008 "Reporting Services Configuration" tool.  When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
 
The developer PC is Windows Vista Business.
 
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
 
Thanks!
-ErikR

View Replies !   View Related
SQL Mail - Mail Delivered Days Late
I am having a problem with SQL Mail. Setup was no problem, and the initial mail test on SQL, worked fine. Very slow mail delivery has generally occurred ever since then.

Mail only seems to get delivered when I log on to NT as `sqlexec` account (that was setup for SQL Mail), and open Exchange to find all the undelivered mail. Even then not all of it is delivered.

I have `Check for new mail` option set on Exchange, but there is no delivery except when I log on to the SQL Executive account (which you are not supposed to do).

Has anyone had similiary problems - any ideas ?!?

Thanks in advance
Jasper

View Replies !   View Related
Sql Mail Failed., Need Help To Set Up Sql Mail In Sql Server 2000
Hi, I have created a profile named sqlmail in exchange server. I tried to run the sql mail service from support service under sql mail to put the profile name, I got the following error: can any one assist me in setting up sql mail in an sql server 2000. .... thanks
Ali

Microsoft SQL - DMO(ODBC SQLState: 42000)
Error 18025:xp_test_mapi_profile: failed with mail error 0x80004005

View Replies !   View Related
How Do I Mail Results From A Query To A Mail Recipient
i have to create a scheduled task that does the following:

a) creates an Excel Spreadsheet from a SQL Query

b) sends the spreadsheet to a user

i then need to schedule this task so that it runs every day and creates a NEW spreadsheet (doesnt matter it the name is the same as long as it overwrite what is already there)

HELP me PLEASE i dont like this SQL Game anymore !!

Daniel.:mad: :confused:

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved