Cannot remove replication

Hi,
I have a box running SQL 7 with replication. I restored one of the
replicated database to another SQL 7 with no replication. A developer needed
to test an upgrade of an application (MS Great Plains) using that database.
The application states that the tables are part of a replication. As far as I
know, when you restore a replicated DB to another server (with no
replication), the replication infomation is lost. I have also ran
sp_removedbreplication successfully but we still have the same problem.
Any ideas?
--
--
I saw it work in a cartoon once so I am pretty sure I can do it.The tables in question are still marked for replication.
I think you may need to manually update some of the system tables to remove
the marking for replication on the object.
I don't have my poster here at the office, so i couldn't tell you which
tables specically to look at.
I would guess sysobjects.xtype....
Rick Sawtell
MCT, MCSD, MCDBA
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:260846C9-A09A-415A-8028-715D66021376@.microsoft.com...
> Hi,
> I have a box running SQL 7 with replication. I restored one of the
> replicated database to another SQL 7 with no replication. A developer
needed
> to test an upgrade of an application (MS Great Plains) using that
database.
> The application states that the tables are part of a replication. As far
as I
> know, when you restore a replicated DB to another server (with no
> replication), the replication infomation is lost. I have also ran
> sp_removedbreplication successfully but we still have the same problem.
> Any ideas?
> --
> --
> I saw it work in a cartoon once so I am pretty sure I can do it.|||I don't have a SQL 7.0 box at work anymore, but if it
also exists on SQL 7.0, please try using
sp_MSunmarkreplinfo which takes a tablename as a parameter
HTH,
Paul Ibison (SQL Server MVP)
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)|||Before updatnig system tables, I would recommend making sure you've dropped
the distributor and publisher. In EM from Tools...Replication...configure
publishing subscribers and distributors. Make sure there are no selections
(uncheck all boxes).
Colleen
"Paul Ibison" wrote:
> I don't have a SQL 7.0 box at work anymore, but if it
> also exists on SQL 7.0, please try using
> sp_MSunmarkreplinfo which takes a tablename as a parameter
> HTH,
> Paul Ibison (SQL Server MVP)
> >> (recommended sql server 2000 replication book:
> >> http://www.nwsu.com/0974973602p.html)
>
>

Cannot remove replication

Hi,
I have a box running SQL 7 with replication. I restored one of the
replicated database to another SQL 7 with no replication. A developer needed
to test an upgrade of an application (MS Great Plains) using that database.
The application states that the tables are part of a replication. As far as
I
know, when you restore a replicated DB to another server (with no
replication), the replication infomation is lost. I have also ran
sp_removedbreplication successfully but we still have the same problem.
Any ideas?
--
I saw it work in a cartoon once so I am pretty sure I can do it.The tables in question are still marked for replication.
I think you may need to manually update some of the system tables to remove
the marking for replication on the object.
I don't have my poster here at the office, so i couldn't tell you which
tables specically to look at.
I would guess sysobjects.xtype....
Rick Sawtell
MCT, MCSD, MCDBA
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:260846C9-A09A-415A-8028-715D66021376@.microsoft.com...
> Hi,
> I have a box running SQL 7 with replication. I restored one of the
> replicated database to another SQL 7 with no replication. A developer
needed
> to test an upgrade of an application (MS Great Plains) using that
database.
> The application states that the tables are part of a replication. As far
as I
> know, when you restore a replicated DB to another server (with no
> replication), the replication infomation is lost. I have also ran
> sp_removedbreplication successfully but we still have the same problem.
> Any ideas?
> --
> --
> I saw it work in a cartoon once so I am pretty sure I can do it.

Cannot remove replication

Hi,
I have a box running SQL 7 with replication. I restored one of the
replicated database to another SQL 7 with no replication. A developer needed
to test an upgrade of an application (MS Great Plains) using that database.
The application states that the tables are part of a replication. As far as I
know, when you restore a replicated DB to another server (with no
replication), the replication infomation is lost. I have also ran
sp_removedbreplication successfully but we still have the same problem.
Any ideas?
--
I saw it work in a cartoon once so I am pretty sure I can do it.
The tables in question are still marked for replication.
I think you may need to manually update some of the system tables to remove
the marking for replication on the object.
I don't have my poster here at the office, so i couldn't tell you which
tables specically to look at.
I would guess sysobjects.xtype....
Rick Sawtell
MCT, MCSD, MCDBA
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:260846C9-A09A-415A-8028-715D66021376@.microsoft.com...
> Hi,
> I have a box running SQL 7 with replication. I restored one of the
> replicated database to another SQL 7 with no replication. A developer
needed
> to test an upgrade of an application (MS Great Plains) using that
database.
> The application states that the tables are part of a replication. As far
as I
> know, when you restore a replicated DB to another server (with no
> replication), the replication infomation is lost. I have also ran
> sp_removedbreplication successfully but we still have the same problem.
> Any ideas?
> --
> --
> I saw it work in a cartoon once so I am pretty sure I can do it.

Cannot get SQL 2005 RS up and running

I am attempting a migration to RS 2005. I restored the ReportServer and tempdb databases over to the new server. The config manager says the ReportService service is running. When I try to view the reports in a browser I get a report server is not responding error.

Thanks Richard

What error do you get when you go to http://localhost/reportserver?

|||

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||What is the error you are getting when you try to change it?|||

Make sure ASP.NET is registed properly. Run aspnet_regiis -i -enable.

If the problem persists, can you enable remote errors to reveal more error message?

|||I posted to you in the other thread...ASPNET_REGIIS.exe is not recognized.|||aspnet_regiis.exe is under %SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.50727. By "not recognized" did you mean you can't find it? If so please check if ASP.NET is installed, and reinstall .Net framework if necessary.|||

It would not recognize it. I reinstalled and now I get another error. Is something else corrupt should I reinstall everything (ack!)?

Error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

Cannot open database "ReportsServer" requested by the login. The login failed. Login failed for user 'ComputerName\ASPNET'.

|||

I still don't understand what you mean by "would not recognize" the command. Is it not found? Did you get an error when you ran it? Can you paste the command you ran and the error message?

For the new error, go to configuration tool and redo the "Database connection" panel.

|||

When executing the .exe it was throwing an error that said it was not recognized. I ran it from the command line within the folder it resides in. I used the -enable this time and it worked, but I had to drill into the folder, not just use the full line command. I am not sure what was up with that. I already did the reconfig and I get the new error...

Error:

The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported) Get Online Help

|||

The report server edition needs to be compatible with the SQL server edition. See this link for a compatibility matrix http://blogs.msdn.com/bimusings/archive/2006/03/03/543088.aspx.

|||

Perhaps we can chat offline<sending email>, as I got the dl's off productsweb.

|||

I have no idea what RS is, but I know it's preventing me from installing CRM 3.0.

When I attempt to load http:\\localserver\reportserver I get the following error.

Reporting Services Error
--
The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help

--
SQL Server Reporting Services

No clue what I'm doing and any help would be appreciated it!