Problem after disaster recovery

A serious system crash took out one of our db servers. We were able to
recover all the databases including the system databases. The operating
system was reinstalled folowed by SQL Server 2005. I shut down the services
and copied the database files and log files into the data directory. When the
services were restarted, the databases were all present and usable with the
following exception.

There are a number of views in the database which use a linked server named
ADSI which gets Active Directory data. Any time any of these views are
queried the following error is returned:

An error occurred during decryption.

Additionally I can drop the views but I cannot recreate the views. I can
drop the linked server but cannot recreate it. Actually that's not exactly
accurate. I can recreate it (sp_addlinkedserver) but cannot add the login
(sp_addlinkedsrvlogin).

Any help greatly appreciated, I need to get this back online ASAP.

.

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
  • Re: Seperate Databases and Business Logic.. SQL vs. .NET code?? Design Ideas/Differences
    ... Say a particular shop has a few critical SQL Databases that are not ... it's been stated that we will not server link. ... and reporting and online can accept day- ...
    (microsoft.public.dotnet.framework.aspnet)