August 6, 2003 at 8:01 am
How can I make a local user on the SQL Server, with doesn't reside in the domain, the proxy account user of the sql server agent.
I've made the local user. He's local administrator on the server. He's administrator in SQL Server. But when I want to create the proxy account I get the error that the user can't logon.
When I do this with a server and a user that is within the domain, there is no problem.
But a server in a workgroup and a local user on that server. It doesn't work...
Any ideas?
Greetz,
Nico
August 6, 2003 at 9:51 am
Did you use machine name as the domanin name when creating the proxy account?
August 6, 2003 at 11:39 pm
Yes. I've tried the name of the machine. A dot, LocalHost, ...
I've tried all that. Still no result.
Greetings,
Nico
August 7, 2003 at 6:31 am
Which SQL Server version and service pack do you run? How did you create the proxy account, from EM or sp?
Edited by - allen_cui on 08/07/2003 06:31:44 AM
August 10, 2003 at 11:38 pm
I'm running SQL 2000 with SP3.
And I've tried it from EM en QA with the sp.
August 12, 2003 at 9:15 am
Try adding the operating system account to the remote access group.
The account must be able to acccess from network which is provided by that group.
Alternatively add the account to the security policy that allows remote connects/access from the network.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply