Error 18452 severity 14 state 1

Seems that something has been adjusted at AD level, may be the SPN entires has been modified for the Servi ce account which is running, so have the right to you try to connect the

SQL server using SQL server organization account , incase if you obtain the SSPI handshake error then you have to set SPN effectively for the business accounts-

Registering and also Troubleshooting Service Principal Names (SPNs)-

http://technet.microsoft.com/en-us/library/bb735885.aspx

http://sqlserverdiaries.com/blog/index.php/2011/03/addressing-a-login-failed-error-18452-error-message-in-sql-server-2005/

http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-and-sspi-handshake-failed-error-hell/

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they aid and un-mark them if they provide no help.

You watching: Error 18452 severity 14 state 1

Thursday, May 31, 2012 7:38 AM

All replies

0
Sign in to vote

This task was executing for last 4 years and Authentication additionally was not changed.

Sql Job was configured to run at 1:00 Am this particular day through 1 hour interval.

See more: Deleting And Disabling And Reset Computer Account In Ad, Resetting Computer Accounts In Windows

It run o 1:00 Am and then At 2 AMsql errorlog,agentlog and home windows log filled through over err and also currently it is running correctly 3:00 AM.

it skiped 2:00AM schdule.

See more: Fix: Itunes Rolling Back Action Windows 10, Itunes Not Installing On Windows 10

currently difficulty i want to knowis it N/W issue or Db issue?

Manish

Thursday, May 31, 2012 5:12 AM


0
Sign in to vote

Seems that something has actually been readjusted at AD level, might be the SPN entires has actually been modified for the Servi ce account which is running, so deserve to you attempt to connect the

SQL server utilizing SQL server company account , ininstance if you get the SSPI handshake error then you have to set SPN appropriately for the organization accounts-

Registering and Troubleshooting Service Principal Names (SPNs)-

http://technet.microsoft.com/en-us/library/bb735885.aspx

http://sqlserverdiaries.com/blog/index.php/2011/03/addressing-a-login-failed-error-18452-error-message-in-sql-server-2005/

http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-and-sspi-handshake-failed-error-hell/

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they assist and un-mark them if they administer no assist.

Thursday, May 31, 2012 7:38 AM
Terms of Use|Trademarks|Privacy Statement|Site Feedback