<div>
<div class="content wysiwyg-content">
We have a network account that we created as a copy of the account we use for the SQL network service on our SQL server.<br />
We know this account works as a normal user, however when we set the SQL server machine to use this as the network account for the SQL service, SQL agent service etc it wont start. &nbsp;However, if we then add the new account to the admin group (which the old one was not a member) we find that it does start the SQL services.<br />
<br />
Any ideas?
</div>
</div>


We have a network account that we created as a copy of the account we use for the SQL network service on our SQL server.
We know this account works as a normal user, however when we set the SQL server machine to use this as the network account for the SQL service, SQL agent service etc it wont start.  However, if we then add the new account to the admin group (which the old one was not a member) we find that it does start the SQL services.

Any ideas?

SQL service not working when I use an account copied from the original account

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.