Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sa user on cluster node

Posted on 2004-10-22
3
Medium Priority
?
529 Views
Last Modified: 2013-11-15
Hi

I installed Cluster on windows2003EE.
I installed SQL Instances on the cluster.
Everything is OK until I am trying to change the agent user name and password from
Windows account to saprel user.

The problem starts when I m shuting down node1 ans all Instances move to node2
The SQL agent does starts and the error log shows :[298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000].
When I startup the node1 and try to start the agent in node2 everything is OK.
From the log it shows that I am using user sa, when I am using user sarepl.

Please advice

Thanks

NirE
0
Comment
Question by:infogate85
3 Comments
 
LVL 1

Accepted Solution

by:
appop earned 200 total points
ID: 12419750
The normal reason for this problem is simply down to the way the service password was changed. In a clustered environment you must connect directly to each node in the the cluster and and open the services applet from control panel and ensure that these are both set to use the same account.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question