Adriaan wrote the following post at 05-13-2009 6:11 PM: Did you try logging in with the local admin account? Or with a domain admin account? yes i'm...
you are right the local admins are by default sysadmin but the issue they are revoked as i mentioned nobody is member of sysadmins except the sathat...
I didn’t disable the SA but the issue is that to login with sa the authentication must be mixed which isn’t the case
Dear ; As I mentioned there is no users in the sysadmin role , so even if I’m a local admin I’ will not be able to change...
Dear all; Currently I’m facing an issue with one of the instances in my company , this instance is running forefront databases, the...
intentionally damaged copy of adventureworks dear all; I was reading the new book introducing Microsoft SQL Server 2008 and the book...
Dear Brothers; We are planning for the disaster recovery site for our SQL 2005 cluster , we have two nodes cluster active /active in...
THE PROBLEM IS THAT THE DPM blocks the cluster service from gaining access in the secons that it collects the backup , i donot know how to overcome...
Dear satia and mohameed i figured it out finnaly , the problem is with the dpm , and i'm working with it now ,...
active passive one instance per node 2005 i have three cluster for applications and one of them is the mentioned computer name for failure audite
brother, i'm not talking about any sql accounts , i'm talking about the sql cluster service account it shouldn't be the same on both...
brother , do you mean that the SQL Cluster Service Account - Applications must be the same on both nodes , notice that i have two instance , each...
Dear ; what do you mean by correct state of cluster ? yes i can perform a failover for cluster nodes in this state the builtinadministrator...
i made the SQL Cluster Service Account alocal admin on both nodes , but i still receiving the same fail audit , any idea?
Dear satya ; thanks alot , i'll make the account of the cluster service alocal admin on both nodes , and i'll tell u the result thanks again for...
Dear satya ;
thanks for your fast replay i got afailure audit Login failed for user 'SAsrvc-SQLCI-sqla'. this account is amember of adomain group that...
i'm a dba in acompany which has two cluster nodes with two instances , we deployed microsoft dpm for data protection , and we scheduled the dpm...
Separate names with a comma.
