Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 2, 1998

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap