.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

SQL MAIL SERVICE PROBLEM

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :ASP.Net
 

Hi All


i tried to make profile for mailing purpose in sqlserver 2005


EXECUTE msdb.dbo.sysmail_add_account_sp
    @account_name = 'test@test.com',
    @description = 'test',
    @email_address = 'test@test.com',
    @display_name = 'test',
 @username='test@test.com',
 @password='test123',
    @mailserver_name = 'mail.test.com'

-------------------------------------------------------------------------------------
EXECUTE msdb.dbo.sysmail_add_profile_sp
       @profile_name = 'test Profile',
       @description = 'Profile used for Akruti club mail1'

-------------------------------------------------------------------
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
    @profile_name = 'Akrui Club Profile',
    @account_name = 'test@test.com',
    @sequence_number = 1

-----------------------------------------------------------------------------------

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
    @profile_name = 'test Profile',


View Complete Post


More Related Resource Links

Problem to obtain client IP on web service

  

Friends,

I'm having problems to obtain the client IP on web service. Here's my scenario:

One server with Windows 2003, hosting the web service using .Net Framework 2.0, with IP 10.0.2.50 and host name ServerTransaction.
Other server with Windows 2003, hosting a web application using .Net Framework 2.0, that consuming the web service on  ServerTransaction, with IP 10.0.2.51 and host name ServerApplication.
Many other computers on the local network (IPs: 10.0.2.80, 10.0.2.81, 10.0.2.82, ...) acessing the web application on ServerApplication.

On the code of the web service I've tried to use HttpContext.Current.Request.UserHostAddress or HttpContext.Current.Request.ServerVariables("REMOTE_ADDR") or HttpContext.Current.Request.ServerVariables("HTTP_X_FORWARDED_FORR"), but always I can only get the IP of ServerApplication (10.0.2.51).

Any idea or tip?


Thanks and sorry for my bad english.


problem compiling web service

  

Using Visual Studio 2010.

I created a webservice GetDemographicData asmx, GetDemographicData asmx.cs and then used wsdl to create a proxy, then used csc.exe to create dll.

first time when I generate proxy, it looks and works fine, but when I make some changes to my webservice and regenerate proxy the following problems occur:

1.I lost the function: public DataSet Get_GetDemographicData(string CaseNum, int Version)
2. The namespace changed to my-labs

Why?? Please see my code below:

Any help is appreciated. Thanks.


<%@ WebService Language="C#" CodeBehind="~/App_Code/GetDemographicData.cs" Class="GetDemographicData" %>
GetDemographicData.cs was created under AppDataas follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

/// <summary>
/// Summary description for GetCurrentReportVersion
/// </summary>
[WebService(Namespace = "http://localhost/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, u

problem in consuming WCF service through Window application

  

I have a silverlight application and WCF service all made in VS 2010 , i had hosted my site to web server which contain Window 2008 and IIS 7.0


now the problem is i have another application which is a window application developed in VS2008 , when i try to add the service reference it gives me error

::::

The document at the url http://72.44.172.77/HRDev3/Service.svc was not recognized as a known document type.

The error message from each known type may help you fix the problem:

- Report from 'DISCO Document' is 'There was an error downloading 'http://dev_qa.emspa.com/HRDev3/Service.svc?disco'.'.

  - The request failed with HTTP status 400: Bad Request.

- Report from 'WSDL Document' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.

- Report from 'http://72.44.172.77/HRDev3/Service.svc' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.

- Report from 'XML Schema' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.

Metadata contains a reference that cannot be resolved: 'http://72.44.172.77/HRDev3/Service.svc'.

Content Type application/soap+xml; charset

System.Net.Mail HTML Template Problem

  

What do I need here ?????? To make this work??


Dim MassMail As New MailMessage()


        Dim Template As ??????????????


        MassMail.To.Add(New MailAddress(TextBox_massemailto.Text))
        MassMail.From = New MailAddress("You@me.com")

        ' MassMail.CC.Add()
        MassMail.Subject = TextBox_massemailsubject.Text
        MassMail.Body = TextBox_massemailBody.Text
        ' MassMail.Body = Template.BodyFileName = "EmailTemplates/BusinessAdBrochure.htm"
        MassMail.Priority = MailPriority.High

        Dim smtpclient As New SmtpClient("relay-hosting.secureserver.net")
        smtpclient.Credentials = New System.Net.NetworkCredential(""You@me.com"", "pasword")
        smtpclient.Port = 25
        smtpclient.EnableSsl = False
        smtpclien

Problem with passing an Image as binary through web service

  

All

I have a web service that is accessed by a windows forms application and receives updates like facility name, address, image etc. Everything works fine except the image data is not being passed to the windows app. I am saving the images in database on both sides, so when I pull it from the server I use the following code

if (!reader.IsDBNull(floorPlanOrdinal))

facility.FloorPlan = (byte[])reader["FloorPlan"];

I can see the facility.FloorPlan Dimentions as 103840 when I debug this method which means that the data is pulled from the database fine.

On the forms side though the dimentions become 0, all other values pass fine except this. Here is the facility property in the web service on server side.

using System;

using System

Problem to use unicode chars in yahoo mail

  
Hi i have a problem to send email via smtpClient class to yahoo mail. if i send a unicode email from non-Yahoo account to yahoo mail, it works correctly (display unicode chars correctly without any making change), but when i send from yahoo account to yahoo mail, it does not display characters correctly and i should change it's encoding to UTF8. can anybody help me to work-around this problem ? Please see my previous thread in this link. thanks in advancehttp://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem with incoming mail to SharePoint Library - what is wrong with this?

  
I configured my incoming mail to a SharePoint 2010 library according to these instructions. http://intellects.in/2010/04/04/configuring-sharepoint-2010-document-libraries-with-exchange-server-2010-to-receive-mails-from-internalexternal-world/ I'm able to receive mail at the Exchange mailbox set up for the document library, but am unable to receive the document in the library itself.  I'm thinking it's because I have a problem with my naming - but I'm not sure how to solve it: I have a SharePoint box and an Exchange box. I've configured the SMTP virtual server with default domain of  server.domain.com .  I've also assigned it an alias of domain2.net I've configured incoming email in SharePoint Central Administration to use the address of mylist@domain2.net so that users can have a friendly url for sending documents to lists and libraries. I've created an Attended Domain in Exchange 2010 and set up an email address policy that speicifes all mailboxes receive an domain2.net address.  I have an MX record for the domain2.net address with a DNS server pointing to the Exchange box. I've created an SMTP Send Connector that points to the FQDN server.domain.com of my virtual server on my SharePoint box. With that connector, I've chosen to route mail through the same FQDN of server.domain.com , that of my SharePoint/IIS SMTP Virtual Server box. When I confi

WCF Service client problem.

  
Hi,I have hosted a wcf service over IIS with Windows Authentication. All the users are able to access the WCF service Url from their machine. The problem is that some of the user are able to consume the webservice method while few of them when try to consume the service ,the error is thrown connection - reset error.I have tried to go through the IIS log also but it did'nt helped.Can any one help me regarding this. What settings I need to check/change to solve the proble.Thanks,AKB

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Problem With SharePoint Designer 2010 and the Search.asmx Web Service

  
I've created a web service datasource on a 2010 site using SharePoint Designer. When I try to make use of the datasource on a page I get the "The server returned a non-specific error when trying to get data from the data source..." message. The datasource connects to _vti_bin/search.asmx. I am using the QueryServiceSoap port and operation QueryX. I've tried various queryXml strings, including site & people searches using both SQL and keyword syntax. eg <?xml version="1.0" encoding="utf-8" ?><QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000"><Query domain="QDomain"> <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats> <Context>   <QueryText language="en-US" type="MSSQLFT"><![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, Filename, Description, Author FROM scope() WHERE CONTAINS ('"Lorum"') AND  ( ("SCOPE" = 'All Sites') )   ORDER BY "Rank" DESC ]]></QueryText> </Context> <Range><StartAt>1</StartAt><Count>20</Count></Range> <EnableStemming>false</EnableStemming> <TrimDuplicates>true</TrimDuplicates> <IgnoreAllNoiseQuery>true&l

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

  
Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Delgation via web service problem

  
Hi, I have an ASP.NET 2.0 web app which calls a one way web method on a web service. This web method contacts remote servers and pulls back config information to confirm the state of new server builds (config, settings etc) and inserts the collected data into a SQL database. The web app is supposed to pass through the callers kerberos ticket to the web service and then again to the newly built server which is being checked, all via impersonation and kerberos delegation using the calling users administrator privileges. The trouble is, I just can't get the web service to run under the callers context. I have the SPN's set up, delegation turned on in the active directory objects for the computer running the web app and service and the worker process domain user service account. I have windows authentication on and impersonation set to true in both the web app and service's web.config, integrated authentication in IIS, and IE settings are all ok. All has been checked out and passes the tests in DelegConfig, but it still won't work. Where am I going wrong? Thanks for any help!

Sending an e-mail with the content of a GridView in asp.net 2.0. problem

  
Hi experts,  I am Sending an e-mail with the content of a GridView in asp.net 2.0. Everything is working fine , but my problem is that  it is also sending "DELETE" LINKLabel to the email. Is there anyway so that only Content of Gridview will go to email and "Delete" Link will not go. Is it possible ??? Thanks in Advance

Problem consuming 32bit WCF service which references a native Dll in a 64 bit OS(Windows Server 2008

  
I have some 32bit Dlls which i want to use it in 64bit OS as i do not have a source code of this to recompile it for 64 bit OS. I have created a x86(32 Bit) WCF service which calls these Dlls and hosted it as a Windows Service on a x64(64 Bit) machine using Windows Server 2008. I have created one more x64 client which calls a function in the WCF which in turn calls a function from the 32 bit native Dll. Whenever i try calling this WCF from the client I get an error as given below.Can anybody please guide as to where I am going wrong and what is needed to solve this issue. Thanks in advance for any help.******The Error Message********************System.BadImageFormatException: Could not load file or assembly 'TestWCFWrapper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.File name: 'TestWCFWrapper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'   at TestWrapperWCFClient.Form2.button1_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms

problem with sending mail by smtpclient

  
 hi , I have an aspx  page that sending a mail by smtp client , but it`s not work properly ! and pass an exeption : failur sending mail here is my code :   protected void BTN_Submit_Order_Click(object sender, EventArgs e) { MailMessage MailMsg = new MailMessage("Sales@anahidcorp.com", "test0@anahidcorp.com"); MailMsg.Subject = "?????"; MailMsg.Body = "????"; MailMsg.IsBodyHtml = false; MailMsg.BodyEncoding = System.Text.Encoding.Unicode; MailMsg.SubjectEncoding = System.Text.Encoding.Unicode; MailMsg.CC.Add("test1@anahidcorp.com"); MailMsg.CC.Add("test2@anahidcorp.com"); NetworkCredential cred = new NetworkCredential("Sales@anahidcorp.com", "mypass"); SmtpClient smtp = new SmtpClient("myserver"); smtp.UseDefaultCredentials = false; smtp.EnableSsl = true; smtp.Credentials = cred; try { smtp.Send(MailMsg); } catch ( SmtpException ex) { Response.Redirect("errpage.aspx?err=" +
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend