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

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

Service Account for SQL Server 2000 Cluster

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Dear All, One of my customer is running a active/active SQL 2000 cluster in Windows 2003 and the service account for one of the instance is LocalSystem account. I am not sure how they changed the service account to localsystem because SQL Server doesn't allow LocalSystem account as your service account when you install it on a cluster and it doesn't allow to change the service account to LocalSystem account in Enterprise Manager when running in a cluster. I searched for documentation to findout whether Microsoft supports running SQL Server using LocalSystem account in a cluster but I am unable to find a documentation. Please help me to identify the documentation regarding the support or share your experience Regards BalajiRegards,Balaji, Please mark as answer if you think this answers your questions

View Complete Post

More Related Resource Links

SQL 2005/2008 on Windows Server 2008 R2 cluster - Service only starts when account is local admin


I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.

I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.

I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.

Errorlog shows the following...

Error: 26054, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      Could not find any IP address that this SQL Server instance depends upon.  Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available.  Error code: 0x5.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

SQL Agent - service account permissions - SQL Server 2008

Hi @ all   I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine. I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE 42000 Error(7314)). The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions? Which settings are needed? Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'} Powershell Console: works                                     SQL Agent Job: access denied I tried some solutions with user rights, group policies and security permissions but nothing works. like: Configuration -Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS

SQL Job not able to sen email after SQL Server Service Account change



I changed on the SQL Server service account to a least priviledge domain user.  However after the change, one of my sqljob which use sp_send_dbmail is not functioning. after checking on the log, it mentioned no permission. i tried to set the MSSQLUser Group as db_owner of msdb database, but it was not helping. When i set the MSSQLUser group as sysadmin ,then only the job able to send email. what could be the least priviledge of the service account so that i able to send email via sql job?

WCF service with WAS and High Availability Cluster on Server 2008


I have a WCF service using one-way net.msmq transport to deliver messages to a high availability cluster.

I have followed a few articles I have found on setting up WCF in a cluster environment and essnetially have the following queues


Cluster: private$\MI/ManagementInformationService.svc

Node A: private$\MI/ManagementInformationService.svc

Node B: private$\MI/ManagementInformationService.svc

Although I am not sure why I need the local queues.

I've installed the WCF application into IIS7 on Node A and Node B. I;ve configured both nodes to the following address:

address="net.msmq://{cluster endpoint}/private/MI/ManagementInformationService.svc"

So, I configure my Web Servers to deliver the MI to the clustered endpoing via WCF net.msmq binding.

At this point, everything works and as messages hit the clustered queue, they are picked up by one of the nodes and processed. However, when I fail over the cluster, the second node does not automatically spring into life, as I would expect it to with WAS. However, if I browse the WSDL for my service on the now-current node, then it does indeed spring into life and process the messages off the queue.

So I turn on WCF tracing, IISReset fire up the WSDL, IISReset (to flush the WCF Trace log) then see the following:

A warning: Cannot detec

SQL Server 2000 is getting very slow, memory usage also very high but restarted db service it comes



I am facing slow down problem in SQL Server 2000. SQL Server is very very slow during that time memory also very high usage but when I restart SQL Service it comes to normal. Please advice, if anyone who has experienced in this type of situation. Appreciate if you help to resolve this problem. Thanks





Cluster Security Policy -- Configuration in SQL Server 2008 R2 (Side by Side with SQL Server 2000


Hi all

Please I have SQL Server 2000 running on Windows 2003 SP2 (A/P) Cluster,Now we are adding new SQL Server 2008R2 Instance to Cluster.

I want know "Database Engine Domain Group","SQL Server Agent Domain Group" section,can I select excisting SQL Server 2000 Engine Domain group or I required to Configure  some thing else.


How to find out "Database Engine Domain Group","SQL Server Agent Domain Group" of  excisting SQL Server 2000.


Thanks in Adavnce




Error: The SQL Server Service account does not have permission to register the supplied URL on the e



I've developed a SQL webservice which works absolutely fine on the server but it doesn't work on my VMware. It generates following error:

"The SQL Server Service account does not have permission to register the supplied URL on the endpoint.  Use sp_reserve_http_namespace to explicitly reserve the URL namespace before you try to register the URL again. An error ('0x80070005') occurred while attempting to register the endpoint."

Here's my webservice:

WEBMETHOD 'GetCountries'( NAME=N'[TestDatabase].[dbo].[GetCountries]'
WEBMETHOD 'GetCities'( N

SQL server 2005 cluster - second node - sql service will not start - node is showing down in cluster


I am tryng to get the second node in a two node cluster to start sql services and come up in the cluster.  The second node was configured and running in a cluster when at some point, the sql service and/or cluster service went down.  Now the node will not start...as in SQL service fails and the system log error is:

"The disk associated with cluster disk resource 'Disk Q:' could not be found. The expected signature of the disk was BF17D33C. If the disk was removed from the server cluster, the resource should be deleted. If the disk was replaced, the resource must be deleted and created again in order to bring the disk online. If the disk has not been removed or replaced, it may be inaccessible at this time because it is reserved by another server cluster node."

and the Application log shows:

Error 2(The system cannot find the file specified.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

I had to edit the startup parameters on the second node because it appears it cannot "see" the original path, which was a network driv

Cannot start SQL Server Agent service on Cluster , 2008 R2



I'm testing a two node cluster installation on windows 2008 r2 and sql server 2008 r2 both enterprise before a production deployment and my only issue so far is that the SQl Server Agent service cannot be started.

The failover works fine, the cluster and SQL services changes nodes without any problem but on both nodes i cannot start that service.

I'm using a domain user for the service, member of the local admin and sysadmin on the SQL server itself.

The error i get when i click on start from SQL management console is:

Unable to start service SQLAGENT$SQLTEST on server SERVERNAME. (mscorlib)

Program Location:

Server stack trace: 
 at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
 at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args,
 Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md,
 Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink
replySink) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.R

adding a node to existing SQL Server 2000 cluster


We have a SQL 2000 cluster pair, say node A and node B. The node B has been corrupted and now the SQL instance is running only on node A. The node B has been rebuilt from scratch and OS reinstalled.

Now, we need to add the node B to node A and they should have a SQL cluster pair. Any one can provide any steps how to add this newly built node to an existing SQL 2000 cluster.

Configuring linked server for a service account - error authenticating


I am trying to run a report through SSRS 2008 web interface.  The credentials that are being used to execute the report are through a service account.  The point of using a service account was so that the subscriptions feature could be used.  However, two particular reports connect directly though a linked server to an excel workbook.  I get the following error when I try to execute the report:


  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
      • The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK".

How can I correctly add my service account to the linked server?






SQL Server Service does not start on SQL Failover Cluster Node B even though i turn off Node A (acti


We ahev setup a SQL Server (64-bit) Failover Environment which consist of a Node A (active) and Node B (passif).

The setup was completed successfully and was working fine since june 2008.

Our system administrators have reported that, after they made some changes during a maintenance week-end, the SQL Server Services don't start anymore on the node B (even though they turn off the active node A and make Node B as active). Our attempts to manually start those services arealways failing.

Can someone help?

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

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