SQL Sever 2005 Local System Account & Network Permissons Question
Posted on 2007-11-19
SQL server 2005, Server 2003 not using AD. Standalone Server. What if I don't use the local system account and instead create 1 local account for the SQL Agent Service and SQL Service. Would I then be able to assign all the necessary permissions to this account that would allow me to run the product and also connect to other resource on other computers? Some of the informaiton I am reading says that the Agent must be configured as a member of the sysadmin fixed server role in SQL server. Could I not just assign the local account I create to this server role? Allow access to this computer via network is an option on the under local security policy I can also add this account to.