sa user on cluster node

Posted on 2004-10-22
Last Modified: 2013-11-15

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


Question by:infogate85
    1 Comment
    LVL 1

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    Read about achieving the basic levels of HRIS security in the workplace.
    Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    875 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now