Re: Problem after disaster recovery

Hi
So what has changed since you re-installed? What errors do you get?

"Pitcairnia" <Pitcairnia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:38C7AF12-7632-4CE7-9D5A-25B266A384A3@xxxxxxxxxxxxxxxx
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: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Moving system databases in SQL 2005
    ... I am using sql 2005 standard edition, and i want to move my system databases ... Alter DATABASE tempdb ...
    (microsoft.public.sqlserver.setup)
  • Re: Move databases between servers
    ... I assume we can backup the system databases (including ... then restore the system databases. ... When you restore databases on your other server SQL Server adds ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving system databases in SQL 2005
    ... want to move the other system databases. ... but when I now start the sql service it does not start. ... system databases on sql 2005 to a different location and worked. ... Have you search in Books Online on "Moving system databases"? ...
    (microsoft.public.sqlserver.setup)
  • Re: select from one db only
    ... No.He can see those system databases and sample databases because its common ... databases.You can however DENY permissions.For example, ... "Doug" wrote in message ...
    (microsoft.public.sqlserver.security)