Viewing 15 posts - 16 through 30 (of 72 total)
Thanks Jeffrey. Using the change option yeilds the same results... indication is the client is install but SSMS is not available.
December 5, 2008 at 1:51 pm
I apologize adams... got called for other duties. Hmmm, lets take a closer look at the properties of the job. Is the owner of the Job the same account as...
September 19, 2008 at 7:08 pm
Good. Right click the test job, click job history and look to see what is indicated in the 'Operator Emailed' column. Also look in the Message column for an indication...
September 19, 2008 at 1:32 pm
Good. Let's go to that Jobs Failure operator, right click and look at the Email name: . Type this same name in the To: box of the Send Test Email...
September 19, 2008 at 12:50 pm
Adams,
Have you solved the problem in the interim? If not let's back up.You indicated you sent a successful test message. When you right click Database Mail, in...
September 19, 2008 at 12:07 pm
Adams,
If you right click Database Mail, what is the name of the Database Mail_Profile and the To: email account that is successfully receiving the test message?
R.,
Ed
...
September 19, 2008 at 9:56 am
Adams,
Have you right clicked DataBase Mail \ View Database Mail Log \ Highlight the most recent entry and read the message at the bottom of the...
September 19, 2008 at 9:02 am
Thanks for the input Warren. Please note my response to Perry.
September 4, 2008 at 7:30 am
Thanks for the input Perry. That's what's odd about this case. The user can log into other clients, open SSIS and view all linked server objects. It's when anyone logs...
September 4, 2008 at 7:29 am
Thanks for the reply Warren. The external data sources are the same builds and service packs.
September 3, 2008 at 3:53 pm
Thank for responding Adam. The links are established using remote credentials. This user can log onto other ssis clients and access multiple linked servers and their objects.
September 3, 2008 at 3:51 pm
Oops,
My previous should have gone to you.
"Maine,
Your post hit my email at 9:12 this morning. Did Maine's response satisfy your question?
R.,
Ed ...
July 25, 2008 at 7:59 am
Maine,
Your post hit my email at 9:12 this morning. Did Maine's response satisfy your question?
R.,
Ed
July 25, 2008 at 7:56 am
You nailed it Happycat. I had to add the user to the msdb and add the user to the msdb SQLAgentOperator Role.
July 24, 2008 at 2:18 pm
Viewing 15 posts - 16 through 30 (of 72 total)