By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

SQL Server

P: n/a
Scenario:

2 x win2k pro machines
1 x windows 2000 server
In a workgroup not domain

Problem:

I have SQL2000 installed on my new server (SERVER001), I now need SQL
Mail working.

I have created a user account username: sql password: whatever and
made it a member of the admin group.

I have logged in to the server as usr sql and installed Outlook on the
server to give me the MAPI functionality.

I have created a MAPI profile for user sql and set SQL Server to run
as user sql (tools > sql server configuration > security > start up
service account)

Despite all this my MAPI profile is not listed in the SQL Mail
configuration, this is usually because the MAPI profile was created
for a different login to the one SQL Service uses.

When I try configure SQL to start using the sql account it won't
accept it unless I prefix it with server001\sql could this could be
the problem?

Another thing I've noticed is that when I do a ctrl+alt+delete it
tells me the login information:

SQL Server is logged on as SERVER001\sql

I would be expecting:

You are logged on as SERVER001\sql

Please help this is beginning to wind me up.
Regards

Paul
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"PaulM" <pa**@mdacreative.com> wrote in message
news:cd**************************@posting.google.c om...
Scenario:

2 x win2k pro machines
1 x windows 2000 server
In a workgroup not domain

Problem:

I have SQL2000 installed on my new server (SERVER001), I now need SQL
Mail working.

I have created a user account username: sql password: whatever and
made it a member of the admin group.

I have logged in to the server as usr sql and installed Outlook on the
server to give me the MAPI functionality.

I have created a MAPI profile for user sql and set SQL Server to run
as user sql (tools > sql server configuration > security > start up
service account)

Despite all this my MAPI profile is not listed in the SQL Mail
configuration, this is usually because the MAPI profile was created
for a different login to the one SQL Service uses.

When I try configure SQL to start using the sql account it won't
accept it unless I prefix it with server001\sql could this could be
the problem?

Another thing I've noticed is that when I do a ctrl+alt+delete it
tells me the login information:

SQL Server is logged on as SERVER001\sql

I would be expecting:

You are logged on as SERVER001\sql

Please help this is beginning to wind me up.
Regards

Paul


Lots of information here:

http://support.microsoft.com/default...&Product=sql2k

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.