Cannot drop database (hanging in loading and marked for replication)

Hi
I have restored a database to the same instance as it was backup, but as a
copy of the original database (I need a couple of Stored Procedures), but
while restoring the database is to hanging with (Loading).
I've tried to drop the database but it says that it cannot be dropped
because it is marked for replication, I've then tried to drop the
replication on the database but it can't, it says that the database cannot
be opened because it is in the middle of a restore.
What to do? I'm pretty stuck...
I've running SQL Server 2000 on a windows 2003 server SP1, the database is
less than 100MB in size.
-Kim
I was having the same problem restoring my database (without replication
issue) and it's stuck loading for an hour, so stoped SQL Server and removed
that datbase mdf and log files..
Then restarted my server and run mentanance task (optmizing & fix intgerity)
on master database..
Then restore my database from the backup
it finished in less than a minute.
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:43f6ec88$1@.news.carlbro.dk...
> Hi
> I have restored a database to the same instance as it was backup, but as a
> copy of the original database (I need a couple of Stored Procedures), but
> while restoring the database is to hanging with (Loading).
> I've tried to drop the database but it says that it cannot be dropped
> because it is marked for replication, I've then tried to drop the
> replication on the database but it can't, it says that the database cannot
> be opened because it is in the middle of a restore.
> What to do? I'm pretty stuck...
> I've running SQL Server 2000 on a windows 2003 server SP1, the database is
> less than 100MB in size.
> -Kim
>
|||Hi,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm
"Islamegy" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:ummPctJNGHA.532@.TK2MSFTNGP15.phx.gbl...
>I was having the same problem restoring my database (without replication
>issue) and it's stuck loading for an hour, so stoped SQL Server and removed
>that datbase mdf and log files..
> Then restarted my server and run mentanance task (optmizing & fix
> intgerity) on master database..
> Then restore my database from the backup
> it finished in less than a minute.
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:43f6ec88$1@.news.carlbro.dk...
>

Cannot drop database (hanging in loading and marked for replication)

Hi
I have restored a database to the same instance as it was backup, but as a
copy of the original database (I need a couple of Stored Procedures), but
while restoring the database is to hanging with (Loading).
I've tried to drop the database but it says that it cannot be dropped
because it is marked for replication, I've then tried to drop the
replication on the database but it can't, it says that the database cannot
be opened because it is in the middle of a restore.
What to do? I'm pretty stuck...
I've running SQL Server 2000 on a windows 2003 server SP1, the database is
less than 100MB in size.
-KimI was having the same problem restoring my database (without replication
issue) and it's stuck loading for an hour, so stoped SQL Server and removed
that datbase mdf and log files..
Then restarted my server and run mentanance task (optmizing & fix intgerity)
on master database..
Then restore my database from the backup
it finished in less than a minute.
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:43f6ec88$1@.news.carlbro.dk...
> Hi
> I have restored a database to the same instance as it was backup, but as a
> copy of the original database (I need a couple of Stored Procedures), but
> while restoring the database is to hanging with (Loading).
> I've tried to drop the database but it says that it cannot be dropped
> because it is marked for replication, I've then tried to drop the
> replication on the database but it can't, it says that the database cannot
> be opened because it is in the middle of a restore.
> What to do? I'm pretty stuck...
> I've running SQL Server 2000 on a windows 2003 server SP1, the database is
> less than 100MB in size.
> -Kim
>|||Hi,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm
"Islamegy" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:ummPctJNGHA.532@.TK2MSFTNGP15.phx.gbl...
>I was having the same problem restoring my database (without replication
>issue) and it's stuck loading for an hour, so stoped SQL Server and removed
>that datbase mdf and log files..
> Then restarted my server and run mentanance task (optmizing & fix
> intgerity) on master database..
> Then restore my database from the backup
> it finished in less than a minute.
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:43f6ec88$1@.news.carlbro.dk...
>|||"Islamegy":[vbcol=seagreen]
[vbcol=seagreen]
Hi again,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm|||(sorry if this message is posted more than once, I've had trouble submitting
my mail to my newsserver)
"Islamegy":[vbcol=seagreen]
[vbcol=seagreen]
Hi again,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm

Cannot drop database (hanging in loading and marked for replication)

Hi
I have restored a database to the same instance as it was backup, but as a
copy of the original database (I need a couple of Stored Procedures), but
while restoring the database is to hanging with (Loading).
I've tried to drop the database but it says that it cannot be dropped
because it is marked for replication, I've then tried to drop the
replication on the database but it can't, it says that the database cannot
be opened because it is in the middle of a restore.
What to do? I'm pretty stuck...
I've running SQL Server 2000 on a windows 2003 server SP1, the database is
less than 100MB in size.
-KimI was having the same problem restoring my database (without replication
issue) and it's stuck loading for an hour, so stoped SQL Server and removed
that datbase mdf and log files..
Then restarted my server and run mentanance task (optmizing & fix intgerity)
on master database..
Then restore my database from the backup
it finished in less than a minute.
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:43f6ec88$1@.news.carlbro.dk...
> Hi
> I have restored a database to the same instance as it was backup, but as a
> copy of the original database (I need a couple of Stored Procedures), but
> while restoring the database is to hanging with (Loading).
> I've tried to drop the database but it says that it cannot be dropped
> because it is marked for replication, I've then tried to drop the
> replication on the database but it can't, it says that the database cannot
> be opened because it is in the middle of a restore.
> What to do? I'm pretty stuck...
> I've running SQL Server 2000 on a windows 2003 server SP1, the database is
> less than 100MB in size.
> -Kim
>|||Hi,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm
"Islamegy®" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:ummPctJNGHA.532@.TK2MSFTNGP15.phx.gbl...
>I was having the same problem restoring my database (without replication
>issue) and it's stuck loading for an hour, so stoped SQL Server and removed
>that datbase mdf and log files..
> Then restarted my server and run mentanance task (optmizing & fix
> intgerity) on master database..
> Then restore my database from the backup
> it finished in less than a minute.
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:43f6ec88$1@.news.carlbro.dk...
>> Hi
>> I have restored a database to the same instance as it was backup, but as
>> a copy of the original database (I need a couple of Stored Procedures),
>> but while restoring the database is to hanging with (Loading).
>> I've tried to drop the database but it says that it cannot be dropped
>> because it is marked for replication, I've then tried to drop the
>> replication on the database but it can't, it says that the database
>> cannot be opened because it is in the middle of a restore.
>> What to do? I'm pretty stuck...
>> I've running SQL Server 2000 on a windows 2003 server SP1, the database
>> is less than 100MB in size.
>> -Kim
>|||"Islamegy®":
>>I was having the same problem restoring my database (without replication
>>issue) and it's stuck loading for an hour, so stoped SQL Server and
>>removed that datbase mdf and log files..
>> Then restarted my server and run mentanance task (optmizing & fix
>> intgerity) on master database..
>> Then restore my database from the backup
>> it finished in less than a minute.
>> "Kim":
>> I have restored a database to the same instance as it was backup, but as
>> a copy of the original database (I need a couple of Stored Procedures),
>> but while restoring the database is to hanging with (Loading).
>> I've tried to drop the database but it says that it cannot be dropped
>> because it is marked for replication, I've then tried to drop the
>> replication on the database but it can't, it says that the database
>> cannot be opened because it is in the middle of a restore.
>> What to do? I'm pretty stuck...
>> I've running SQL Server 2000 on a windows 2003 server SP1, the database
>> is less than 100MB in size.
>> -Kim
Hi again,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm

Cannot Delete Report

I have been using Reporting Services 2000 for a couple of years with
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to confirm that I want to delete but am getting the
following error: "An internal error has occured on the Report Server.
See the error log for more details. (rsInternalError)."
I checked the logs and have the following but it does not seem to
specify the reason for throwing the error:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details.
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
condition, String componentName)
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
condition)
at
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
Item)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
Item)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
Item)
at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
at
Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at
Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
want to install it on the Report Server. This link might provide some
insight. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
>
>
> > I have been using Reporting Services 2000 for a couple of years with
> > no issues. Now have verion 2005 installed and building some reports. I
> > created a report that no longer want and when I went to delete it by
> > "showing details", selecting the correct checkbox and clicking delete,
> > I am prompted to confirm that I want to delete but am getting the
> > following error: "An internal error has occured on the Report Server.
> > See the error log for more details. (rsInternalError)."
> > I checked the logs and have the following but it does not seem to
> > specify the reason for throwing the error:
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: An internal error
> > occurred on the report server. See the error log for more details. --
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcept=ion:
> > An internal error occurred on the report server. See the error log for
> > more details.
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Asser=t(Bo=ADolean
> > condition, String componentName)
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > condition)
> > at
> > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(S=trin=ADg
> > Item)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapC=lien=ADtMessage
> > message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > Item)
> > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > at
> > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > sender, EventArgs e)
> > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > at
> > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > postData)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> want to install it on the Report Server. This link might provide some
> insight. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
We did apply SP2 but it did not help the issue.|||I've seen the same thing, and I think it is a bug. Just click Edit from the
details view, and use the Delete function on that page.
--
Tom Garth
"davestub@.gmail.com" wrote:
> On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> >
> >
> >
> >
> >
> > > I have been using Reporting Services 2000 for a couple of years with
> > > no issues. Now have verion 2005 installed and building some reports. I
> > > created a report that no longer want and when I went to delete it by
> > > "showing details", selecting the correct checkbox and clicking delete,
> > > I am prompted to confirm that I want to delete but am getting the
> > > following error: "An internal error has occured on the Report Server.
> > > See the error log for more details. (rsInternalError)."
> >
> > > I checked the logs and have the following but it does not seem to
> > > specify the reason for throwing the error:
> >
> > > System.Web.Services.Protocols.SoapException:
> > > System.Web.Services.Protocols.SoapException: An internal error
> > > occurred on the report server. See the error log for more details. --
> >
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more details.
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Bo-olean
> > > condition, String componentName)
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > > condition)
> > > at
> > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(Strin-g
> > > Item)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien-tMessage
> > > message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > > Item)
> > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > at
> > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > sender, EventArgs e)
> > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > > at
> > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > > eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > postData)
> > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > want to install it on the Report Server. This link might provide some
> > insight. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
> We did apply SP2 but it did not help the issue.
>|||On Sep 26, 9:36 am, Tom Garth <TomGa...@.discussions.microsoft.com>
wrote:
> I've seen the same thing, and I think it is a bug. Just click Edit from t=he
> details view, and use the Delete function on that page.
> --
> Tom Garth
>
> "daves...@.gmail.com" wrote:
> > On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> > > > I have been using Reporting Services 2000 for a couple of years with
> > > > no issues. Now have verion 2005 installed and building some reports=. I
> > > > created a report that no longer want and when I went to delete it by
> > > > "showing details", selecting the correct checkbox and clicking dele=te,
> > > > I am prompted to confirm that I want to delete but am getting the
> > > > following error: "An internal error has occured on the Report Serve=r=2E
> > > > See the error log for more details. (rsInternalError)."
> > > > I checked the logs and have the following but it does not seem to
> > > > specify the reason for throwing the error:
> > > > System.Web.Services.Protocols.SoapException:
> > > > System.Web.Services.Protocols.SoapException: An internal error
> > > > occurred on the report server. See the error log for more details. =--
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogEx=ception:
> > > > An internal error occurred on the report server. See the error log =for
> > > > more details.
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.A=ssert(Bo=AD-olean
> > > > condition, String componentName)
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Bo=olean
> > > > condition)
> > > > at
> > > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionN=ow()
> > > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > -- End of inner exception stack trace --
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteIt=em(Strin=AD-g
> > > > Item)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(S=oapClien=AD-tMessage
> > > > message, WebResponse response, Stream responseStream, Boolean
> > > > asyncCall)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > > methodName, Object[] parameters)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(S=tring
> > > > Item)
> > > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > > at
> > > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > > sender, EventArgs e)
> > > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs= e)
> > > > at
> > > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(Stri=ng
> > > > eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > sourceControl, String eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > postData)
> > > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > > want to install it on the Report Server. This link might provide some
> > > insight. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > We did apply SP2 but it did not help the issue.- Hide quoted text -
> - Show quoted text -
Just tried to delete from the properties page and received the same
error. Thanks for the suggestion.|||You have global "NOCOUNT" turned on on the SQL Server. Turn that off.
Reporting Services requires NOCOUNT off so that it knows that items/records
were actually deleted.
--
SQL Server Developer Support Engineer
"davestub@.gmail.com" wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>

Cannot Delete Job

I used the DTS transfer Jobs to copy a couple of jobs from one server to
another, I now aant to delete those jobs on the target server but I get an
error saying
"Error14274" Cannot add, update, or delete a job (or its steps or
schedule) that originated from an MSX server"
How can I delete these jobs I urgently need to get rid of these....
Thanks for your help,
BrianYou are using an MSX and TSX server, which means that the job you have on
your server was targetted from a master server.
The targetted client can not delete the job, it needs to be done on the
master server.
Check books online on master server jobs
To defect a target server from a master server
1.. Expand a server group, and then expand a server configured as a target
server.
2.. Expand Management.
3.. Right-click SQL Server Agent, point to Multi Server Administration,
and then click Defect from MSX.
4.. Click Yes to confirm that you want to defect this target server from a
master server.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I used the DTS transfer Jobs to copy a couple of jobs from one server to
> another, I now aant to delete those jobs on the target server but I get

---

an

quote:

---

> error saying
> "Error14274" Cannot add, update, or delete a job (or its steps or
> schedule) that originated from an MSX server"
> How can I delete these jobs I urgently need to get rid of these....
> Thanks for your help,
> Brian
>

---

|||Dandy,
Thank you very much for your response, however, I am not using an MSX and
TXS server, at least not knowingly. When I right click Server Agent, I only
get the options to make the server a Master or a Target, is there anyway
that I can edit a system table to remove these?
The original server that the jobs came from will be going away today......
Thanks again,
Brian
"Dandy Weyn" <mct@.dandyman_nospam.net> wrote in message
news:40096d0e$0$773$ba620e4c@.news.skynet.be...

quote:

---

> You are using an MSX and TSX server, which means that the job you have on
> your server was targetted from a master server.
> The targetted client can not delete the job, it needs to be done on the
> master server.
> Check books online on master server jobs
> To defect a target server from a master server
> 1.. Expand a server group, and then expand a server configured as a

---

target

quote:

---

> server.
>
> 2.. Expand Management.
>
> 3.. Right-click SQL Server Agent, point to Multi Server Administration,
> and then click Defect from MSX.
>
> 4.. Click Yes to confirm that you want to defect this target server from

---

a

quote:

---

> master server.
> --
> Regards,
> Dandy Weyn
> MCSE, MCSA, MCDBA, MCT
> www.dandyman.net
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> an
>

---

|||Brian,
I am interested in the answer to this one too. My situation occurred becaus
e we renamed the server and sql name when jobs were still there. now the or
iginal server doesnt exist but the jobs do. I've tried removejobbyid method.
The next thing I was look
at is how to defect a master server. these servers are not really multi-hom
ed, they just think they are because the owner of the job is not part of the
new sql server. sp_help_job will tell you who owns it
Mitch|||Brian
check out Can't delete job.
Tibor put a script in there that fixed it for me
mitchsql

Cannot Delete Job

I used the DTS transfer Jobs to copy a couple of jobs from one server to
another, I now aant to delete those jobs on the target server but I get an
error saying
"Error14274" Cannot add, update, or delete a job (or its steps or
schedule) that originated from an MSX server"
How can I delete these jobs I urgently need to get rid of these....
Thanks for your help,
BrianYou are using an MSX and TSX server, which means that the job you have on
your server was targetted from a master server.
The targetted client can not delete the job, it needs to be done on the
master server.
Check books online on master server jobs
To defect a target server from a master server
1.. Expand a server group, and then expand a server configured as a target
server.
2.. Expand Management.
3.. Right-click SQL Server Agent, point to Multi Server Administration,
and then click Defect from MSX.
4.. Click Yes to confirm that you want to defect this target server from a
master server.
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> I used the DTS transfer Jobs to copy a couple of jobs from one server to
> another, I now aant to delete those jobs on the target server but I get
an
> error saying
> "Error14274" Cannot add, update, or delete a job (or its steps or
> schedule) that originated from an MSX server"
> How can I delete these jobs I urgently need to get rid of these....
> Thanks for your help,
> Brian
>|||Dandy,
Thank you very much for your response, however, I am not using an MSX and
TXS server, at least not knowingly. When I right click Server Agent, I only
get the options to make the server a Master or a Target, is there anyway
that I can edit a system table to remove these?
The original server that the jobs came from will be going away today......
Thanks again,
Brian
"Dandy Weyn" <mct@.dandyman_nospam.net> wrote in message
news:40096d0e$0$773$ba620e4c@.news.skynet.be...
> You are using an MSX and TSX server, which means that the job you have on
> your server was targetted from a master server.
> The targetted client can not delete the job, it needs to be done on the
> master server.
> Check books online on master server jobs
> To defect a target server from a master server
> 1.. Expand a server group, and then expand a server configured as a
target
> server.
>
> 2.. Expand Management.
>
> 3.. Right-click SQL Server Agent, point to Multi Server Administration,
> and then click Defect from MSX.
>
> 4.. Click Yes to confirm that you want to defect this target server from
a
> master server.
> --
> Regards,
> Dandy Weyn
> MCSE, MCSA, MCDBA, MCT
> www.dandyman.net
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > I used the DTS transfer Jobs to copy a couple of jobs from one server to
> > another, I now aant to delete those jobs on the target server but I get
> an
> > error saying
> >
> > "Error14274" Cannot add, update, or delete a job (or its steps or
> > schedule) that originated from an MSX server"
> >
> > How can I delete these jobs I urgently need to get rid of these....
> >
> > Thanks for your help,
> >
> > Brian
> >
> >
>

Cannot create snapshot

I'm trying to get a successful subscription push going on my database
publisher after having to alter a couple of tables. After making my
changes, I tried to start the snapshot agent. Normally, I see the
snapshot being created, which takes a few moments. In this case, all
I saw was the old snapshot, created successfully, which was probably
the one I initially did a month ago. I tried to go ahead and push my
subscription, but the status shows as "Deactivated". My question is,
how do I re-push my subscription to my backup database
machine/database?
You can reinitialize the subscription and then it'll pick up the new
snapshot.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Cannot create an instance of OLE DB Provider "MSDAC"

Hey Guys,
I'm trying to query a couple of Excel 2007 spreadsheets for some reports
using OpenDataSource in my query to pull in the data.
Everything is find with the preview inside the IDE, but when I deploy my
report I recieve the following error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Regression'.
(rsErrorExecutingCommand)
Cannot create an instance of OLE DB provider "MSDASC" for linked
server "(null)".
I've installed 2007 Data Connectivity Components on the report server and
this allowed me to query the data while developing. I'm at a loss why this is
not working after I deploy.
The SQL I'm using to query the data is:
SELECT *
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
Macro;HDR=YES"')...Sheet1$
Any ideas/suggestions?My guess if this works in development and not in deployment that it has to
do with file security. The report is executed under a different user account
and that account doesn't have rights to the folder where the Excel data
resides. Just a guess because I have never done this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> Hey Guys,
> I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> using OpenDataSource in my query to pull in the data.
> Everything is find with the preview inside the IDE, but when I deploy my
> report I recieve the following error:
> An error has occurred during report processing. (rsProcessingAborted)
> Query execution failed for data set 'Regression'.
> (rsErrorExecutingCommand)
> Cannot create an instance of OLE DB provider "MSDASC" for linked
> server "(null)".
> I've installed 2007 Data Connectivity Components on the report server and
> this allowed me to query the data while developing. I'm at a loss why this
> is
> not working after I deploy.
> The SQL I'm using to query the data is:
> SELECT *
> FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> Macro;HDR=YES"')...Sheet1$
>
> Any ideas/suggestions?
>|||Thanks for your response, while not directly related to file security, it was
a security problem. Here's what I did to solve my problem in case anyone
comes across this thread in the future...
I was using a shared data source which connected using windows
authentication. No matter how I tweaked and fiddled around I could not get
windows authentication to work.
So I setup a SQL account with limited rights. Then provided me with a new
error message stating:
Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied.
You must access this provider through a linked server.
While I have Ad hoc access enabled via Surface Configuration, it would not
allow me to perform an ad hoc query if the user account wasn't a sysadmin to
the SQL Server. Ugh!
I played around with tweaking the DisallowAdhocAccess registry setting for
the provider, but I didn't find a way to allow non-sysadmin accounts the
ability to perform ad hoc queries.
In the end using a SQL authentication with a sysadmin account allowed
OpenDataSource to pull in the external data.
For what it's worth....
"Bruce L-C [MVP]" wrote:
> My guess if this works in development and not in deployment that it has to
> do with file security. The report is executed under a different user account
> and that account doesn't have rights to the folder where the Excel data
> resides. Just a guess because I have never done this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
> news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> > Hey Guys,
> >
> > I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> > using OpenDataSource in my query to pull in the data.
> >
> > Everything is find with the preview inside the IDE, but when I deploy my
> > report I recieve the following error:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Query execution failed for data set 'Regression'.
> > (rsErrorExecutingCommand)
> > Cannot create an instance of OLE DB provider "MSDASC" for linked
> > server "(null)".
> >
> > I've installed 2007 Data Connectivity Components on the report server and
> > this allowed me to query the data while developing. I'm at a loss why this
> > is
> > not working after I deploy.
> >
> > The SQL I'm using to query the data is:
> > SELECT *
> > FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> > 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> > Macro;HDR=YES"')...Sheet1$
> >
> >
> > Any ideas/suggestions?
> >
>
>