September 24, 2003 at 11:25 am
Hello everyone,
I have a process that sends me the results of a query using xp_sendmail. However, when the process runs, it errors out every time when the following message:
Error 17969 - Unable to log into SQL Server
Now, I'm running this against a SQL Server 7.0 database. I'm a sysadmin on the server and I've even tried running it under the SQL Server account, but I get the same message every time. Also, I've tried using the parameter @set_user, but with no luck.
Does anyone know what would cause this behavior?
Thanks,
Jason
September 25, 2003 at 12:21 am
Any chance this is related to Q310822 ?
Check out smtp-mail at http://www.sqldev.net
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 25, 2003 at 12:43 am
Refer the link below
September 25, 2003 at 7:32 am
Hi guys,
Thanks for the links and the Q article number, but the workarounds don't do the trick either. Also, this server is not clustered.
I've tried doing a wrapper call using xp_cmdshell and SQL Authentication, but the same error still occurs. I'm wondering if it has something to do with MDAC 2.7 SP1 refresh. We had MDAC 2.6 SP2 and the process worked fine, but then our network people installed the latest MDAC version and now the process doesn't work.
I don't know if is the problem, but I'm leaning that way.
Thanks,
Jason
September 25, 2003 at 7:49 am
What version of SQL7.0 are you running ?
MDAC-upgrades should _always_ be tested on seperate servers that are at the level of your production server.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 25, 2003 at 8:17 am
quote:
What version of SQL7.0 are you running ?MDAC-upgrades should _always_ be tested on seperate servers that are at the level of your production server.
We are running 7.00.1094.
Also, I agree with you about testing the MDAC installs. However, I didn't get a chance to voice my opinion about the installation. I came in on a Monday and was told "Oh, by the way, now all of our servers are running MDAC 2.7 SP1 refresh".
Thanks,
Jason
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply