x

Database mail does not work for one sql instance, returns error - Object reference not set to an instance of an object.

so here is my scenario, I have database mail working perfectly on a server on one instance of sql, it sends emails out as expected without any problem however when i try to test database mail on the same server on a different instance I get the "Object reference not set to an instance of an object." in the mail log.

I have hunted on the and not found a solution to the problem, I have tried deleting and recreating the profile and account, i have tried adding an entry to the host file and ensured that the relevant account has permissions to the "DatabaseMailUserRole". I am now stuck as to where i should look next. Any suggestions?
more ▼

asked Jan 03, 2012 at 05:33 AM in Default

nick long gravatar image

nick long
21 1 1 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Sounds like a security setting issue. I'd validate that the services on both instances are running under the same security context. Then, validate the the logins you're using have the same security context in both instances.
more ▼

answered Jan 03, 2012 at 05:37 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

Thanks Grant, I will look into it and let you know
Jan 03, 2012 at 05:59 AM nick long
So I found the issue, NT Authority did not have DBMailUserRole. Thanks again grant for pointing me in the right direction.
Jan 03, 2012 at 06:16 AM nick long
Not a problem. Glad to help. By the way, if you like the answer, please give it a thumb's up. If you think it was the right answer, please check the check box. It's how we keep score around here.
Jan 03, 2012 at 06:36 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

hello guys can someone help me with this kind of error. i have a table "worker" that has field number and name i amm trying i have created a stored procedure from sql server 2008 itself. the stored procedure is like this

create procedure input @number int, @name varchar(10) as insert into worker values(@number,@name) and in vb 2008 i have put two textboxes and one button and the code is like the following: Public Class Form1 Dim conn As SqlConnection Dim cmd As SqlCommand

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Try
        conn = New SqlConnection("Data Source=bona-pc;Initial Catalog=workship;Integrated Security=True")
        conn.Open()
        cmd.Connection = conn
        cmd.CommandType = CommandType.StoredProcedure
        cmd = New SqlClient.SqlCommand("input", conn)
        cmd.Parameters.AddWithValue("@number", TextBox1.Text)
        cmd.Parameters.AddWithValue("@name", TextBox2.Text)
        cmd.ExecuteNonQuery()
        conn.Close()
        TextBox1.Text = ""
        TextBox2.Text = ""
        MsgBox("Saved successfuly")
    Catch ex As Exception
        MessageBox.Show("Error while inserting record on table..." & ex.Message, "insert records")
    End Try
after i have clicked the button the error comes saying:
Error while inserting record on table... Object reference not set to an instance of an object.
i have spent a whole day searching all over but if any one helps it would be so great for me. thx.
more ▼

answered Sep 26, 2012 at 03:08 PM

sangwa125 gravatar image

sangwa125
-4

I'd make more sense to post your own question/problem instead of posting it as an answer to something completely different.
Sep 26, 2012 at 04:23 PM DirkHondong
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x344
x18

asked: Jan 03, 2012 at 05:33 AM

Seen: 2661 times

Last Updated: Sep 26, 2012 at 04:23 PM