SQL Mail

Question

SQL Mail

Krasavita

SSC-Insane

Points: 23138
More actions
January 27, 2010 at 11:05 am

#100055

I am trying to set up,do I need to set up seperate sql account to run sql mail

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Since it appears that you are attempting to setup SQL Mail in SQL Server 2000, you need to install a MAPI compliant client on the server. This would be Outlook, NOT Outlook Express. You then need to logon to the server using the service account to setup the mail account for Outlook, so it will also need an email address setup for this purpose.

Of course you'd probably know most of this if you were to take some time and read Books Online before posting your questions here on ssc and expect us to provide you detailed instructions on how to do everything.

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

But do I need to create seperate sql account in sql server to run, if yes what setting needs to be check for it?Thank you

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

Krasavita

SSC-Insane

Points: 23138

January 27, 2010 at 11:18 am

#1109465

What is service account?

GSquared SSC Guru Points: 260824 More actions · Answer 4

No, you don't need a separate SQL account.

The service account is the one that SQL is running under, as a Windows service. Do you know what a Windows service is?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Krasavita (1/27/2010)
What is service account?

Curious, what is your position at your current employer?

Have you ever installed SQL Server?

You really need to start reading more in Books Online. It is the SQL Server Help System and it can provide you valuable information that will help you.

SQL Mail does not run under a sql account. It needs to use the same account as that used to run SQL Server.

Service Account, the user the SQL Server is running under on your server.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Suggestions:

1) If your employer has the install CD's for SQL Server 2000, ask for them and install SQL Server 2000 Personal Edition on your desktop. It will provide you with the sandbox system to play in, starting with installing SQL Server 2000.

2) Purchase SQL Server 2005 or SQL Server 2008 Developer Edition and install it on your PC at home and start working with it there. The Developer Edition of SQL Server 2005/2008 has a street price of $50.00 USD, but if you look a bit on the web you can find it for less than that.

3) Purchase some books and read, a lot. Try the things in the books in your sandbox databases (NOT PRODUCTION or DEVELOPMENT at work) If you have questions, come here to SSC, and post your specific and detailed questions along with what you have done so we can see what you are doing.