devxlogo

Accout for both SQL SERVER and SQL EXECUTIVE

Accout for both SQL SERVER and SQL EXECUTIVE

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  5 Tips for Working With an Onsite Interpreter
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