.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Which Service Accounts to chosse for?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Which is the best service Account to chosse for  while installing SQL.

We are installing SSIS,SSRS,SSAS  as well and we will be installing each  of then in a differnt sever.

And we do not have a domain account to use for we should chose from network service/ localservice/ local system

please advice

View Complete Post

More Related Resource Links

service accounts

Where are the password hashes for the SQL Server password accounts stored? Are they set by a DBA or generated randomly? What can be done to test the strength of the passwords? version 2000 and 2005.

Managed Service Accounts

Can I use a Managed Service Account to access a SQL server database? The docs say MSA's were created to ease passsword management to  Exchange and IIS.  However, the FAQ says not supported for SQL and Task Scheduleer.  I'm not sure if the FAQ is referring to the service accounts sql runs under or login accounts to sql server. I would like to use MSA's for: 1.    an exe that needs to run nightly to move SQL data around 2.  an IIS Application Pool where the associated website needs to get sql data off a remote sql server.   http://technet.microsoft.com/en-us/library/dd548356%28WS.10%29.aspx http://technet.microsoft.com/en-us/library/ff641729%28WS.10%29.aspx

Can´t set up local system accounts as service accounts in sharepoint 2010

HI I made an inplace upgrade to sharepoint 2010. I want to setup performance point services. but it doesn´t allow me to set a local system account as the application pool account for performance point services application. It doesn´t allow me to register a new account it says The specified user account "domain\username" is a local account. Local accounts should only be used in stand alone mode. The application pool account for the site collection that I upgraded is a local system account so I don´t get it? I tried this http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=112 However the upgrade fails after this. Is there any way that I do the inplace upgrade and it would allow me to use local system accounts has service accounts? Without Active directory? Thanks      

Problem with service accounts on French Vista or W7

Hi folks, According to all the Microsoft documentation that I can find, if I want to set up the service accounts with system authority in a French system, I must use the term "AUTORITE NT\SYSTEM".  This works fine on a French XP but fails on a French W7 (and possibly Vista and W2008 I figure).  I have managed to install on a Dell using the term "AUTORITE NT\Système" instead.  Can anyone confirm whether the Microsoft documentation is totally wrong and, if not, what the heck is going on?  Thanks!

Accounts used by application pools or service identities are in the local machine Administrators gro

ERROR: Using highly-privileged accounts as application pool or as service identities poses a security risk to the farm, and could allow malicious code to execute.  The following services are currently running as accounts in the machine Administrators group: SharePoint Central Administration v4 (Application Pool) SPTimerV4(Windows Service) there are 2 accounts associated with this install. 1. SQL ACCOUNT 2. SP Admin account(farm) the admin account has the following listed components    Farm components using this account      Microsoft SharePoint Foundation Application Pool: SharePoint - 80 SharePoint Server Search Web Analytics Data Processing Service Farm Account User Profile Synchronization Service Microsoft SharePoint Foundation Sandboxed Code Service Access Services Secure Store Service PowerPoint Service Application Word Viewing Service PerformancePoint Service Application Visio Graphics Service Managed Metadata Service Web Analytics Service Application Word Automation Services Excel Services Application Business Data Connectivity Service Search Administration Web Service for Search Service Application User Profile Service Application Search Service Application Application Discovery and Load Balancer Service Application Security Token Service Application   The farm account is not listed in the local machines admi

Unable to access Configure Service Accounts using the Farm acount

hi all, I am new to SharePoint and have started working directly on SP2010,   I installed SP 2010 using the Domain\spadmin account. I have also added mine domain account as the administrator in the central admin(farm administrator) now m trying to start the SharePoint Server Search 14 service from "services.msc" for which the log in as user is mine domain account, for which i am getting the following error: The SharePoint Server Search 14 service failed to start due to the following error: The service did not start due to a logon failure. if I check for all the services which are running in SharePoint I get that SharePoint Search service is active. also when i try to access Central Admin --> Security --> Configure Service accounts then I get the error message as access denied signin as different user.   Please help me out as i need to configure search for my application and m not having the access.   Thanks for the help Arun Kumar

Access denied on "Configure service accounts"


Just installed a standalone, developer's instance of Sharepoint 2010 on my Windows7 workstation per the instructions outlined in the MSDN article:


When I try to click on the Configure service accounts link on Sharepoint Central Administration site, I get an access denied error.  My windows ID is local to the workstation and it has full administrator rights.  My Id is in the Farm Administrator's group plus the BUILTIN\Administrators group.  Why can't I access this link?  Everything else appears to working fine (still testing).



Is a multiple administrative and service accounts a MUST for MOSS 2007/2010?


Want to set up a MOSS 2007 server farm and was reading up on how to do it. One Msft article insist that I need multiple accounts. My sys admin tells me that I can use one account for everything. This account is a domain account and is a member of the domain admin group, it has dbcreator, public, secadmin, serveradmin, sysadmin roles on the db server.

Any thought on the topic?



SQL Server 2005 Express (SP3) service accounts


According to http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/28627c31-0c39-4560-8cf9-f41a960fad6c ,   Network Service is 2nd best.

The only choices other than Network Service, Local Service, and Local System is Domain User. But my laptop isn't a part of a domain. My laptop is running Windows XP SP2.

What do I do?



Sql server service accounts


Hi all,

I am connecting to a access database by a linked server through a network,

using the network service account. It works fine.

All i want to know is whether using the network service account has any drawbacks?

Can i achieve the same by using a local service account? If i can achieve that through local service account what are the steps i need to do?

Please share your ideas


SQL Engine Services and Domain Accounts Used as the Service Login


Looking for detailed information on what resources the MS SQL Engine reads, writes, and modifies in order to operate as designed.  Read this carefully.  I've been on the search but am not finding anything quickly.

I believe if a Windows domain account is being used for any of the SQL Engine services that account should not have any granular permission settings on any folders related to SQL operations, nor any granular settings on the registry or any where else.  Should be FULL CONTROL.  Microsoft wrote the program to run the way it does and we should not be the judge of what permissoins a service account should have so the program runs correctly.

I am troubleshooting unstable SQL issues and I am finding little tips here and there pointing in my mind to be the service account having too many restrictions on the SQL folders, Windows registry, and everything else.

My opinion would be, any domain account used as a SQL service account should have FULL CONTROLL on any folders used for SQL operations and FULL CONTROLL on registry operations and be part of NO group policies.

If anyone knows where I may find detailed information that is written in GOLD as to what permissions SQL needs to run, let me know.  Send a link.  I think there should be NO restrictions.  I haven't met anybody yet that really understand

Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.

WCF Tip: Using Properties in Service Contracts

you'll notice all of the Service Contracts are implemented with interfaces containing only methods. For the longest time I thought that's all that was supported, until I thought about it a little more. In C# land, properties are simply wrappers around a get method and set method, so why wouldn't we be able to use properties in a service contract? Well the answer is we can.

Realizing a Service-Oriented Architecture with .NET

This article is meant to be a practical discussion guide to building a .NET application in a service-oriented architecture. We will consider real-world goals, real-world obstacles, and experience-based solutions. I quickly concede the approaches discussed here are not exhaustive or infallible. This paper is focused on application development, not application integration. We will specifically consider architectural issues and component design issues.

The Potential of Web Services

Web Service for uploading documents into SharePoint

WS UploadService is a web service written for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 and is meant for uploading documents into SharePoint. I have just uploaded the zip file to GotDotNet.com so it will take some time before the zip file appears in the list of downloads. For the time being, you can download the zip file from the following location

Creating and Using an ASP.NET Web Service in Visual Web Developer

In addition to letting you create Web pages, Microsoft Visual Studio also lets you create Web services that use ASP.NET XML. Creating a Web service in Visual Studio is similar to creating a Web page. You can also use the Microsoft Visual Web Developer Web development tool to reference and use Web services that are in a Visual Web Developer solution, on your local computer or in a local or external UDDI directory. In this walkthrough, you will create the Web service in one solution and use it in another.

Tasks illustrated in this walkthrough include:

Creating a simple XML Web service in Visual Web Developer.

Creating a separate Web site that uses the Web service.

AutoGenerateSelectButton="False" ignored when using Domain Service


Crosspost from RIA Services forum: http://forums.silverlight.net/forums/t/196466.aspx

I'm creating a Dynamic Data application in VS2010 and have recently switched to using a Domain Service to give greater control over the data presented to the client. I've noticed that the AutoGenerate<Action>Button attributes on my GridView are being ignored. The presence of the Edit and Delete buttons appear to be contingent on the existence of Update and Delete methods on the partial classes autogenerated in the Domain Service, but i'm not seeing how to control the generation of the Select button. Is there a way to control this from within the Domain Service class?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend