Restore Deleted Instance of SQL 2000

We had a server with SQL 2000 on it. It had two instances. Worked
great.
We decided to upgrade to SQL 2005. We ran the upgrade on the default
instance. Everything was great.
Before we upgraded the second instance, someone went into 'add remove
programs' and removed the second instance of SQL 2000. Can I get it
back?
I created a second instance in SQL 2005 and attached the single
important DB from that second instance of SQL 2000 and the data is all
there, but we are having connection issues. I'm afraid it may be
because we deleted the second instance of SQL 2000 before we got a
chance to upgrade.
Any ideas?
-BDOn Nov 2, 3:16 am, i...@.clowwater.com wrote:
> We had a server with SQL 2000 on it. It had two instances. Worked
> great.
> We decided to upgrade to SQL 2005. We ran the upgrade on the default
> instance. Everything was great.
> Before we upgraded the second instance, someone went into 'add remove
> programs' and removed the second instance of SQL 2000. Can I get it
> back?
> I created a second instance in SQL 2005 and attached the single
> important DB from that second instance of SQL 2000 and the data is all
> there, but we are having connection issues. I'm afraid it may be
> because we deleted the second instance of SQL 2000 before we got a
> chance to upgrade.
> Any ideas?
> -BD
I don't think that this has something to do with the fact that the
second instance was deleted. Can you post more details? What is the
error that you get? Do you get it each time that you try to connect
to the server? Do you also get it if you try to connect to the SQL
Server from the server it self?
Adi

Restore a Group/Role?

I have a client with an eager IT manager who used Report Manager, saw the
BUILTIN\Administrators group in the roles list and decided to remove it from
the Report Server groups, or I think that is how he did it, he says he is
not sure. Sadly that was the only RS group with Content Manager and
Publisher rights, so no more report publishing/role assignment there.
I looked at the Books Online to see how I can restore/create groups/roles in
RS, but all cases say "use Report Manager and navigate ..." but obviously
that does not apply any more, because Report Manager now does not show the
Site Settings, New Role Assignment, etc.
Must they re-install?
Thanks.There is no need to reinstall. Use account that is windows admin on the box
where Report Server is installed. This account should have sufficient rights
to browse and change security. Admin on the box has these special rights on
Report Server regardless of the Report Server policies.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> I have a client with an eager IT manager who used Report Manager, saw the
> BUILTIN\Administrators group in the roles list and decided to remove it
from
> the Report Server groups, or I think that is how he did it, he says he is
> not sure. Sadly that was the only RS group with Content Manager and
> Publisher rights, so no more report publishing/role assignment there.
> I looked at the Books Online to see how I can restore/create groups/roles
in
> RS, but all cases say "use Report Manager and navigate ..." but obviously
> that does not apply any more, because Report Manager now does not show the
> Site Settings, New Role Assignment, etc.
> Must they re-install?
> Thanks.
>|||Thanks, it sounds good. I will give it a shot tomorrow, they went home
already, and will let you know if it worked.
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:e#BflgeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> There is no need to reinstall. Use account that is windows admin on the
box
> where Report Server is installed. This account should have sufficient
rights
> to browse and change security. Admin on the box has these special rights
on
> Report Server regardless of the Report Server policies.
> --
> Dmitry Vasilevsky, SQL Server Reporting Services Developer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> ---
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> > I have a client with an eager IT manager who used Report Manager, saw
the
> > BUILTIN\Administrators group in the roles list and decided to remove it
> from
> > the Report Server groups, or I think that is how he did it, he says he
is
> > not sure. Sadly that was the only RS group with Content Manager and
> > Publisher rights, so no more report publishing/role assignment there.
> > I looked at the Books Online to see how I can restore/create
groups/roles
> in
> > RS, but all cases say "use Report Manager and navigate ..." but
obviously
> > that does not apply any more, because Report Manager now does not show
the
> > Site Settings, New Role Assignment, etc.
> > Must they re-install?
> >
> > Thanks.
> >
> >
>|||Hi Dmitry, in the end it was a re-install and everything is back to normal
now. Thanks in any case.
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:e#BflgeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> There is no need to reinstall. Use account that is windows admin on the
box
> where Report Server is installed. This account should have sufficient
rights
> to browse and change security. Admin on the box has these special rights
on
> Report Server regardless of the Report Server policies.
> --
> Dmitry Vasilevsky, SQL Server Reporting Services Developer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> ---
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> > I have a client with an eager IT manager who used Report Manager, saw
the
> > BUILTIN\Administrators group in the roles list and decided to remove it
> from
> > the Report Server groups, or I think that is how he did it, he says he
is
> > not sure. Sadly that was the only RS group with Content Manager and
> > Publisher rights, so no more report publishing/role assignment there.
> > I looked at the Books Online to see how I can restore/create
groups/roles
> in
> > RS, but all cases say "use Report Manager and navigate ..." but
obviously
> > that does not apply any more, because Report Manager now does not show
the
> > Site Settings, New Role Assignment, etc.
> > Must they re-install?
> >
> > Thanks.
> >
> >
>