SQL Server

[Danial]

Hi Everyone,
I have been using SQL Server(7.0) for some time but i have a small problem, when i am logged in as a different user rather then my usual Username (Administrator) the sql server fails to start due to log in failure. How do i make sure that sql server starts for every users.

Thanks in advance

[TheBao]

To set the service startup account for SQL Server Agent

Right-click SQL Server Agent; then click Properties.
In the SQL Server Agent Properties dialog box, under Service startup account, select:
System account if your jobs require resources from the local server only.
This account if your jobs require resources across the network, including application resources; you want to forward events to the application logs of other Microsoft® Windows NT® computers; or if you want to notify operators through e-mail or pagers.
If you selected This account, enter the Windows NT account name that SQL Server Agent will use, and then enter the password for the Windows NT account in the Password box.
You must restart SQL Server Agent before these configuration changes take effect.