Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLBuddy123
Starting Member
26 Posts |
 Posted - 2009-06-02 : 20:03:12
|
| Hi We have SQL Mail feature enabled on a SQL 2000 instance and now we are planning to migrate that instance to SQL Server 2005. Could anyone please tell the steps required to accomplish this so that all the jobs and other objects that make use of SQL mail can function without any problems? Thank you,Yours SQLBuddy. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-03 : 15:51:06
|
| http://msdn.microsoft.com/en-us/library/ms187891.aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-06-03 : 16:10:55
|
| Hi Dinakar, Thank you very much for your reply. Could you please clarify me one more question? If we enable the SQL Mail feature using surface area configuration tool and install MAPI client like Outlook on the server that has SQL Server 2005, can we use the sql mail features without any issues or should we take any other steps to make SQL Mail fuction? Thank You,YoursSQLBuddy.YoursKiran. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-03 : 16:30:36
|
| you should be usig database mail and not SQL mail. You need to create the profiles, accounts and configure DB mail.Here's the order: http://msdn.microsoft.com/en-us/library/ms188298.aspxDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
SQLBuddy123
Starting Member
26 Posts |
Posted - 2009-06-03 : 16:53:00
|
| Hi Dinakar, Thank you very much for your reply. I really appreciate it.Yours SQLBuddy. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-04 : 10:13:37
|
| welcome. glad to help.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Migrating SQL Mail to SQL Server 2005