Startup account

Question

Post reply

Startup account

hirenk

SSCrazy

Points: 2000
More actions
October 2, 2002 at 11:46 am

#58375

When I am looking at SQL server propoerties|security Tab , an option for Startup and run SQL server in the following account is greyed. I don't see any username/password there neither I can make any changes there. Does anyone know how do I know which account is being used to startup SQL server?
Thanks.
Hirenk

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

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

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 1

Do you have administrative rights to the server?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

hirenk SSCrazy Points: 2000 More actions · Answer 2

In EM server registeration is done using user SA.

Thanks.

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 3

If your NT user account has access to the SQL server, make it a member of the sysadmin role. Change the registration to use NT authentication.

Getting the information on startup account requires being able to look at the information on the service itself. This requires a privileged account for the system itself (such as a domain user with administrative rights)... not sure what level off-hand.