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
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
Comment