Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.
I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default...290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/defaul...;290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

Cann't uninstall an instance

I once tried to uninstall a single default instance of sql2000, using
the installation CD. Unfortunately, it was taking forever and I killed
the process. After I rebooted the server and tried to uninstall again, I
got the error, saying uninstall file could not be found, or something
was missing...
I tried to re-install the default instance to correct it. However, I
could not get the default instance back. As a result, I could not
re-install it and I could not uninstall it.
How can I manually uninstall the instance?
Thank you.I found myself an article and will go from there...
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991&sd=tech
Jluo wrote:
> I once tried to uninstall a single default instance of sql2000, using
> the installation CD. Unfortunately, it was taking forever and I killed
> the process. After I rebooted the server and tried to uninstall again, I
> got the error, saying uninstall file could not be found, or something
> was missing...
> I tried to re-install the default instance to correct it. However, I
> could not get the default instance back. As a result, I could not
> re-install it and I could not uninstall it.
> How can I manually uninstall the instance?
> Thank you.
>

Cannot run SRS 2000 and WSS3 on same server

I have a single Win2k3 server that was running SQL2000, SQL Reporting
Services 2000, and Windows SharePoint Services 2.
I upgraded the WSS2 to WSS3. When I try to navigate to http://myserver/Reports
I get an error "Server Error in /Reports Application". With the error
message Unrecognized attribute 'Type'. The source error has this line
highlighted...
<sectionGroup name="System.Workflow.ComponentModel.WorkflowCompiler"
type="System.Workflow.ComponentModel.Compiler.WorkflowCompilerConfigurationSectionGroup,
System.Workflow.ComponentModel, Version=3.0.0.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35">
The source file identified in the error is c:\inetpub\wwwroot
\web.config
I assumed that the Reports application couldn't understand the
web.config entry because it now included Freamework v2 information.
The first thing that I tried was to change the ASP.Net settings in IIS
for Reports and ReportServer to v2.
Now when I navigate to http://myserver/Reports the reports I can see
the reports listed properly. But, when I try to execute a report I
get the following Reporting Services Error...
Failed to load expression host assembly. Details: StrongName cannot
have an empty string for the assembly name. (rsProcessingError)
>From looking at other postings it appears that this error is due to me
setting the Reports and ReportServer applications to ASP.Net v2.
So, I am stuck. If I set the applications to v2 I can see the site
but cannot run the reports. If I set te applications to v1.1 then I
cannot see the site at all.
Is there are way to allow Reporting Services 2000 to exist with WSS3?
Thanks for your help
IANI suggest you read through this article about "Troubleshooting a
Side-by-Side Installation of Reporting Services and Windows SharePoint
Services"
http://msdn2.microsoft.com/en-us/library/aa179370(SQL.80).aspx
It refers to RS 2000 and WSS 2.0, but it might give you some clues as how to
set it up. I'm not sure if you can exclude sites in WSS 3.0 though, so you
might have to move the RS virtual directories to their own web site, at
least to create a new web application, to make sure you can change which
.NET framework they use.
Hope this gives you something to work with.
Kaisa M. Lindahl Lervik
<iani4profit@.gmail.com> wrote in message
news:1173135063.253461.175400@.j27g2000cwj.googlegroups.com...
>I have a single Win2k3 server that was running SQL2000, SQL Reporting
> Services 2000, and Windows SharePoint Services 2.
> I upgraded the WSS2 to WSS3. When I try to navigate to
> http://myserver/Reports
> I get an error "Server Error in /Reports Application". With the error
> message Unrecognized attribute 'Type'. The source error has this line
> highlighted...
> <sectionGroup name="System.Workflow.ComponentModel.WorkflowCompiler"
> type="System.Workflow.ComponentModel.Compiler.WorkflowCompilerConfigurationSectionGroup,
> System.Workflow.ComponentModel, Version=3.0.0.0, Culture=neutral,
> PublicKeyToken=31bf3856ad364e35">
> The source file identified in the error is c:\inetpub\wwwroot
> \web.config
> I assumed that the Reports application couldn't understand the
> web.config entry because it now included Freamework v2 information.
> The first thing that I tried was to change the ASP.Net settings in IIS
> for Reports and ReportServer to v2.
> Now when I navigate to http://myserver/Reports the reports I can see
> the reports listed properly. But, when I try to execute a report I
> get the following Reporting Services Error...
> Failed to load expression host assembly. Details: StrongName cannot
> have an empty string for the assembly name. (rsProcessingError)
>>From looking at other postings it appears that this error is due to me
> setting the Reports and ReportServer applications to ASP.Net v2.
> So, I am stuck. If I set the applications to v2 I can see the site
> but cannot run the reports. If I set te applications to v1.1 then I
> cannot see the site at all.
> Is there are way to allow Reporting Services 2000 to exist with WSS3?
> Thanks for your help
> IAN
>|||WSS3 does not have the "exclude sites" functionality any more.
My short term (hopefully) solution is to host the report sites on a
new site that is unrelated to SharePoint. The bad part is that I will
need to update all of the links to the various reports throughout my
web sites, etc.
Thanks for your feedback.
IAN

Cannot restore to database

Drop database and recreated, however cannot restore data. Says Data dump came from Master. If I choose Master, says I must be in single user mode.Hi,
Are you trying to restore the Master database or some user database ? If it
is master u have to
1.. Start Microsoft® SQL ServerT in single-user mode. (use -m in service
manager while starting sql server)
2.. Execute the RESTORE DATABASE statement to restore the master database
backup
3.. Stop and start the SQL Server in Muliuser Mode. (Just Restart MSSQL
Server service)
Thanks
Hari
MCDBA
"bscottparis" <anonymous@.discussions.microsoft.com> wrote in message
news:9D1F49FF-E704-4DE1-BB81-722033F6169E@.microsoft.com...
> Drop database and recreated, however cannot restore data. Says Data dump
came from Master. If I choose Master, says I must be in single user mode.

cannot repair database.

I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
mode).
open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
sqlcmd.
type the following clause,
DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
go
I got 'repair statement not processed, database need to be in single user
mode' error messsage.
WHY? which one step I lost?
--FrankFrank Lee wrote:
> I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
> mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
> sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>
You don't need to start up SQL Server with the -m switch.
Go into Management Studio, right click on the CK database, click on
properties.
In the resulting dialog select the "Options" page. In the right pane,
scroll down to "State" and change "Restrict Access" to a value of "Single".
This will put the DATABASE into single user mode.
Alternatively, you could use ALTER DATABASE:
ALTER DATABASE CK
SET SINGLE_USER;
GO
and
ALTER DATABASE CK
SET MULTI_USER;
GO
to change it back.
Rob|||ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/92d4714b-95bf-46af-b05e-759a7164f937.htm
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Frank Lee" <Reply@.to.newsgroup> wrote in message
news:uzHfXT1DGHA.3988@.TK2MSFTNGP12.phx.gbl...
>I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
>mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to
> enter sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>|||>
> You don't need to start up SQL Server with the -m switch.
> Go into Management Studio, right click on the CK database, click on
> properties.
> In the resulting dialog select the "Options" page. In the right pane,
> scroll down to "State" and change "Restrict Access" to a value of
> "Single".
> This will put the DATABASE into single user mode.
> Alternatively, you could use ALTER DATABASE:
> ALTER DATABASE CK
> SET SINGLE_USER;
> GO
> and
> ALTER DATABASE CK
> SET MULTI_USER;
> GO
> to change it back.
>
> Rob
Thanks. It works for me.