SPN get deregisters automatically in SQL Server Clustering


while failover of clustered instance of sql server, spn gets deregisters automatically. after reboot have register spn manually, should done automatically.

before failover lists account on running below command. after failover not lists. please on it.

setspn -l domainname\accountname

please vote & "mark answer" if post helpful you. cheers prakash nandwana bangalore , india

hello,

please see following post:

http://blogs.technet.com/b/kevinholman/archive/2007/12/13/system-center-operations-manager-sdk-service-failed-to-register-an-spn.aspx

hope helps.

regards,

alberto morillo
sqlcoffee.com



SQL Server  >  SQL Server Setup & Upgrade



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

set datagrid current record to inserted record

i have master detail page datagrid , dataform. there text box users can enter client reference number. if th reference bumber not found, child window pops uo d ataform insert. want when new record inserted, , child window closed, current record in datagris should set inserted record.. how possible private sub addnewclient_closed(sender object, e eventargs) dim clients cwclientadminadd = sender dim dd domaindatasource = ria_clientselection if not clients.newtbcbi_client nothing dd.dataview.add(clients.newtbcbi_client) dd.submitchanges() else dd.cancelsubmit() end if end sub private sub ria_clientselection_submittedchanges(sender object, e system.windows.controls.submittedchangeseventargs) if e.haserror messagebox.show(e.[error].tostring(), "submit error", messageboxbutton.ok) e.markerrorashandled() else me.dgclientsearch.itemssourc...
Read more