Iniciar sesión
 
InicioBibliotecaAprendizajeDescargaSoporteComunidadForos
Recursos para Profesionales de TI >
> 
> 
SQL Database 'Secure_Store_Service_DB_xxxxxxxxx81dd4b' missing

Respondida SQL Database 'Secure_Store_Service_DB_xxxxxxxxx81dd4b' missing

  • martes, 20 de marzo de 2012 7:55
     
     
    Inicie sesión para votar
    0

    Hi,

    I have no idea what happend, but I get this critical error "

    Cannot open database "Secure_Store_Service_DB_35e8500e90c54faa8d8403f42b81dd4b" requested by the login. The login failed.

    Login failed for user 'XXXX\spraun_sql'. The db is not there

    I do not have any backup of this db.

    Is it possible to recreate Secure Store Service or create a new one and use it??

    What can I do in this situation?

    thanks.

    Erró


    • Editado Erró domingo, 25 de marzo de 2012 18:59 No help
    •  
     

Todas las respuestas

  • jueves, 22 de marzo de 2012 17:29
     
     
    Inicie sesión para votar
    0
     Anyone

    Erró

     
  • domingo, 25 de marzo de 2012 18:55
     
     
    Inicie sesión para votar
    0

    No help here :(

    Erró


    • Editado Erró domingo, 25 de marzo de 2012 18:57 No help
    •  
     
  • domingo, 25 de marzo de 2012 20:54
     
     Respondida
    Inicie sesión para votar
    0

    Go to Central Adminitration site -> Manage Service Applications -> Select "Secure Store Service Appliation Proxy" and Click Delete on ribbon (check "Delete data associated with the Service Application connections"); Select "Secure Store Service Appliation" and Click Delete on ribbon (check "Delete data associated with the Service Application")

    Recreate Secure Store Service if needed (for example, by running Configuration Wizard)

    Bond... Brooke Bond!


     
  • domingo, 25 de marzo de 2012 21:07
     
     Respondida
    Inicie sesión para votar
    1

    Hi Erró.

    Aviw is right, but you should however before going and recreating the Secure Store consider what it was used for, and perhaps even consider what has happened that caused the DB to disappear in the first place? Check if you have a backup?
    Perhaps it was used for what it is intended, to store credentials, if so that perhaps you will loose some critical information when recreating the servcie app.

    Consider this...and then, if it feels right, recreate the service application.

    Read up on it here:

    Plan the Secure Store Service (SharePoint Server 2010)
    http://technet.microsoft.com/en-us/library/ee806889.aspx

    Configure the Secure Store Service (SharePoint Server 2010)
    http://technet.microsoft.com/en-us/library/ee806866.aspx

    Regards

    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here