Creating new credential in SQL2005

• zedj

  Valued Member

  Points: 55

  More actions

  November 15, 2010 at 3:58 am

  #231335

  I am trying to create a new credential through Management Studio in SQL 2005 but recieve the following error:

  ------------------------------------------------------------------

  Alter failed for credential "MYCredential", (Microsoft.SqlServer.Smo)

  Additional Information:

  An exception occured while executing a Transact-SQL sql statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  An error occured during decryption (Microsoft SQL Server, Error: 15466)

  -------------------------------------------------------------------

  We are using SQL2005 SP3 9.0.4035.

  Any thoughts?

• pruthvi116

  SSC Enthusiast

  Points: 169

  More actions

  December 14, 2010 at 3:58 pm

  #1262581

  Did you try creating a credential through a TSQL script?