Monday, February 20, 2012

Local administrators was removed from SQL server logins, SQL Agent is not running

Colleagues,
I am experiencing problems described in (MSSQL 2000):
http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
My problem is, that I have no MSSQL account I can use to solve the problem,
I cannot access SQL Servers Logins.
What can I do? Could please somebody help me?
Best regards,
PeterSQL Server Agent has to have an Administrative account. I would recommend
that the agent account be a local administrator on the server with far
reaching access accross the network. The only suggestion that I have is to
try and locate someone who can grant you sa or a minimum Security Admin for
this instance. One thing you might try is to determine if the console account
for the server is a user in SQL. I have always used the console account and
password as the SA on that SQL instance as well as the account that the
agent/service uses which is I believe to be quite common. Might get lucky.
(i.e If there server console name is Server1 and the console login in
P@.ssw0rd, then use that to try and login through Query analyizer. If it lets
you in, try editing the instance registration in Enterprise Manager and see
what kind of access that account has.)
Good Luck.
"Peter Rus" wrote:
> Colleagues,
> I am experiencing problems described in (MSSQL 2000):
> http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
> My problem is, that I have no MSSQL account I can use to solve the problem,
> I cannot access SQL Servers Logins.
> What can I do? Could please somebody help me?
> Best regards,
> Peter
>
>

No comments:

Post a Comment