March 21, 2008 at 9:05 pm
You'd be amazed at what some of the ref's I work with do in the real world. Take this one for instance: Professor at UCCS in the Computer Science Department; teaches Computer Operating systems (I actually had him for an instructor back in the early 80's!).
There are quite a few out there in the IT field working as ref's. I guess even geeks have a jock hiding inside to some extent. Actually, I got into soccer because of my kids. Soccer Dad, Assistant Coach, Head Coach, now a Ref. My two oldest are also ref's, and my youngest wants to do it when she gets older. My oldest, howver, quit as she got tired of nasty coaches.
Edit: I may not get the configuration until Monday. I just tried to VPN into work and I can't get a connection. Being a school district, and Spring Break next week, I doubt it will get fixed before Monday morning. I will try to get in early so I can post it before our training class.
March 24, 2008 at 7:52 am
Here is how our accounts and profiles are setup.
March 24, 2008 at 8:13 am
Thanks Lynn.
So your Services account has email setup on the exchange server? I don't think at this point mine does because I really didn't foresee a need using Database mail, but if this is why I can't use reply to then there is a need.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 24, 2008 at 10:08 am
Okay here is another follow up. On my 32-bit laptop running 2005 SP2 developer edition I changed the service to run under my login so there would be a valid email box on the Exchange Server. Set the SMTP authentication to use the Windows Authentication Using Database Engine Service credentials. Set different email address and reply to address and sent the test email and the reply to was still the base email address. Same result when using sp_send_dbmail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 24, 2008 at 2:10 pm
Our Exchange guru (I mean administrrator) is out this week. When he gets back I'll ask him if there is anything different on the Exchange side. If I remember correctly, he simply gave our servie account appropriate access to Exchange. I wish I had more to help you with on this, but since everything worked as expected (meaning I had no problems) nothing is coming to my mind on what to look at.
😎
March 24, 2008 at 3:19 pm
Lynn,
Thanks for the information thus far. It gave me some things to look at. Unfortunately none of them actually worked. I can live without the reply to, but it would be nice. I will get together my exchange admin tomorrow also.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 28, 2008 at 6:48 am
Jack,
This might be a .NET Framework 2.0 service pack 1 issue.
Based on three servers, the only one that appeared to work was the one without SP1. Here's the version numbers from within SSMS, Help/About.
Microsoft .NET Version / Status
Server1: 2.0.50727.312 / worked
Server2: 2.0.50727.1433 / did not work
Server3: 2.0.50727.1433 / did not work
When I removed SP1 from one of the servers SSMS would no longer start, so I would not recommend trying that except in a test environment.
March 28, 2008 at 8:27 am
Todd Engen (3/28/2008)
Jack,This might be a .NET Framework 2.0 service pack 1 issue.
Based on three servers, the only one that appeared to work was the one without SP1. Here's the version numbers from within SSMS, Help/About.
Microsoft .NET Version / Status
Server1: 2.0.50727.312 / worked
Server2: 2.0.50727.1433 / did not work
Server3: 2.0.50727.1433 / did not work
When I removed SP1 from one of the servers SSMS would no longer start, so I would not recommend trying that except in a test environment.
The following is the information from SSMS when run directly on our development servers. Database Mail works on these servers.
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790
Microsoft SQL Server 2005 9.0.3054
Don't know if this will help, but it adds some more to compare against.
😎
March 28, 2008 at 8:41 am
Following Lynn's lead, here's from a server that does not work.
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790
March 28, 2008 at 9:34 am
Decided to try DB Mail from my desktop install of SQL Server 2005, and I ran into the same problem you are having with your server. Here is version info from my desktop.
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
Microsoft SQL Server 2005 9.0.3159
😎
March 28, 2008 at 9:39 am
Guess what, mine matches Todd's. Here it is for confirmation:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790
Here's my SQL Server Version:
9.00.3042.00 (X64)
So it seems to be a .NET Framework issue. I'll have to check to see if has been reported to MS.
Thanks for all your help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 28, 2008 at 10:37 am
Jack,
Keep us posted on what you find. I have determined that this issue does exist on my two PeopleSoft database servers and I have asked our sys admins to NOT update .NET on my DW development servers.
😎
March 28, 2008 at 11:20 am
Will do.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 28, 2008 at 11:54 am
I did not find this issue on Microsoft Connect so I submitted it as a bug. Here is the link for anyone who would like to confirm it:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335613
Thanks again for all your help, especially Lynn and Todd.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 28, 2008 at 12:32 pm
I have gone out to confirm the issue. Thanks for the link.
😎
Viewing 15 posts - 16 through 30 (of 35 total)
You must be logged in to reply to this topic. Login to reply