devxlogo

Accout for both SQL SERVER and SQL EXECUTIVE

Accout for both SQL SERVER and SQL EXECUTIVE

Why Trust Us

Question:
Is it possible to assign an account to both SQL Server and SQL Executive and be able to log into Windows NT to perform task schedualing? I read in the MS SQL SETUP book (page 27) that I cannot use this account for users to log on.

Answer:
Both the SQL Executive and SQL Server have the option of either running under the local system account or under a user account that one can specify.

A user account created for the purpose is more useful, especially when two SQL Servers need to communicate. One can have them both run under the same user account, which simplifies certain rights issues.

One should not use this specially created user account for regular users, because a regular user should not have the level of rights that is typically given to the SQL Server account.

See also  Why ChatGPT Is So Important Today
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More