December 15, 2008 at 2:37 pm
One of my developers is trying to register a SQLServer server (Win 2000,
SQL 2000) using Enterprise Manager. He receives the message below;
A connection could not be established to sever_name.
Reason: "EXECUTE permission denied on objedt 'sp_MSSQLDMO80_version'.
His login is in an NT group and I added the login the way I've always
done. I even tried adding his login alone. No luck.
He can register other servers, just not this one.
I tried granting explicit execute rights to the sp but the error pops
up again but on a different sp this time.
This is not my server and is under the direct control of another dba
and IT group. I spoke with them and they were clueless about any
security setup/configuration that may have been done.
I'm clueless. If you have a clue please advise.
Thanks in advance.
December 16, 2008 at 5:34 am
Have you tried logging in to the dev's workstation and registering the server with your credentials? Can anyone else in that AD group register that server?
December 16, 2008 at 3:04 pm
Have you tried logging in to the dev's workstation and registering the server with your credentials? Can anyone else in that AD group register that server?
Other people don't have this connection problem, the developer has no problem connect to other servers.
:w00t:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply