Sql Server Service account and sql agent account

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

raj-247939 SSCertifiable Points: 5999 More actions · Answer 1

Hi Ranga,

Use sp_who .This will give u the information. about the accounts.

from

Killer

philcart SSC-Forever Points: 47794 More actions · Answer 2

raj, unless you're running a different system to everyone else I'm sure you can't retrieve the service accounts via sp_who.

Ranga N, Your best bet would be to query the services via WMI in VBScript, or maybe using the sp_OA* procedures.

--------------------
Colt 45 - the original point and click interface

philcart SSC-Forever Points: 47794 More actions · Answer 3

Check this link for a script.

--------------------
Colt 45 - the original point and click interface

raj-247939 SSCertifiable Points: 5999 More actions · Answer 4

SSCertifiable

Points: 5999

October 7, 2005 at 8:26 pm

Thanx, Phill