SQL Server

[PaulM]

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

[Simon Hayes]

"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