Viewing 15 posts - 76 through 90 (of 151 total)
That was it.
Thanks, I got it going!
May 1, 2009 at 4:04 pm
Yup, that was it. The servers machine account was in the wrong OU that refreshed the policy. I had the AD guys move it to the correct OU and it...
April 20, 2009 at 11:46 am
I'll check with the AD guys...
April 20, 2009 at 10:56 am
The AD account is not getting locked out. I can authenticate with the credentials fine on one server and I can manually retype in the credentails from the services mmc...
April 20, 2009 at 10:32 am
One other thing is that I try to go to the Loacl Security Policy mmc and drill down to "Log on as a service" and the buttons to add or...
April 20, 2009 at 10:28 am
This get's weirder and weirder. I did waht you suggested. I went to the SQL Server Configuration Manager and put in the correct credentials and I hit "Apply" and I...
April 20, 2009 at 10:10 am
Hmm...
I'll try that.
Thanks
April 17, 2009 at 2:33 pm
We're using an internal SMTP relay server here. Only domain authenticaed member servers have rights to relay. So when SQL (running with domain credentials) relays off it it allows it.
April 16, 2009 at 12:54 pm
Nevermind.....
IT WORKS NOW!!!
The field "E-mail name:" in the Opertaor property wanted the correct yomama@somewhere.net address.
This is what confused me from the other SQL 2005 servers. They had MAPI configured...
April 16, 2009 at 12:42 pm
Thanks for that.
I t still does not work. I have one question though. In the operator property in the field "E-mail name:", exactly what name is it asking for?...
April 16, 2009 at 12:35 pm
No, I did not install an "SMTP Service" as I do not want to broaden the attack vector of my server. The SMTP info was added to the properties required...
April 16, 2009 at 12:26 pm
Yes, DBMail works fine for me. SMTP info in the account is working.
But why doesn't the following work...
EXECUTE msdb.dbo.sp_notify_operator @name=N'YOMAMA',@body=N'testing SQL notifications'
April 16, 2009 at 12:14 pm
Windows Firewall is turned off. That was the first thing I shut off.
April 16, 2009 at 10:34 am
Yes it it is.
Also, for this test machine, it is the only profile.
April 16, 2009 at 10:14 am
"We enabled the SMTP service "
Huh? Why does the SMTP service need to be installed? I don't want to broaden the the vulnerability of my server by adding the SMTP...
April 16, 2009 at 10:02 am
Viewing 15 posts - 76 through 90 (of 151 total)