Error removing a view

I have developer who created a view on a database in SQL MSDE 2000 and for some reason it was created without an owner. When I try to DROP this view I get the following error message:
Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the system catalog.
Any help on how I can get this view would dropped would be greatly appreciated
Thanks,
Jerry
hi,
"Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I have developer who created a view on a database in SQL MSDE 2000 and for
>some reason it was created without an owner. When I try to DROP this view
I get
> the following error message:
> Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the
system
>catalog.
> Any help on how I can get this view would dropped would be greatly
appreciated
it's actually not possible the object not having an owner... it will inherit
the creator owner name...
if you logged in with a different login that not maps to that user, try
locating it with it's owner name in the form , owner_name.object_name
if his user name in the database is minnie, try
minnie.V_RATE_CATEGORY
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jerry,
A similar question was just raised in the .server group. Do you know what
tool the developer was using? (I have only seen this when developing using
Access 2000 ADPs. But that may not be the only cause. That is why I am
curious.)
Russell Fields
"Jerbear64" <anonymous@.discussions.microsoft.com> wrote in message
news:27d5901c46449$0f74ce80$a601280a@.phx.gbl...[vbcol=seagreen]
> Modify the table sysobjects field UID and change it from a
> 11 to 1 and then I was able to remove the view.
> Jerry
>
> MSDE 2000 and for some reason it was created without an
> owner. When I try to DROP this view I get the following
> error message:
> not exist in the system catalog.
> be greatly appreciated
|||I know it should not be possible, but the owner came up showing a "null" value. How it happen I don't but it did.
Jerry
"Andrea Montanari" wrote:

> hi,
> "Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
> news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I get
> system
> appreciated
> it's actually not possible the object not having an owner... it will inherit
> the creator owner name...
> if you logged in with a different login that not maps to that user, try
> locating it with it's owner name in the form , owner_name.object_name
> if his user name in the database is minnie, try
> minnie.V_RATE_CATEGORY
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Error Redirected to Script Component : Package Doesnt fail.

I have created a data flow task. In that, in a 'data conversion', if a column fails validation then that row is redirected to a script component, which in turn writes the error to a variable.

But though the error is generated and script component receives the error, package doesnt fail.

Is there any way to set the package result to failure inside the script component? I tried set 'FailPackageOnFailure' to true but doesnt work.

Any help is greatly appreciated.

Thanks,

Don

donMahya wrote:

I have created a data flow task. In that, in a 'data conversion', if a column fails validation then that row is redirected to a script component, which in turn writes the error to a variable.

But though the error is generated and script component receives the error, package doesnt fail.

Is there any way to set the package result to failure inside the script component? I tried set 'FailPackageOnFailure' to true but doesnt work.

Any help is greatly appreciated.

Thanks,

Don

You could raise an error within the script component using:

Me.Events.FireError(...) (something like that anyway)

-Jamie

|||

Sorry for the delay. Wasnt working on this part for some time.

I tried

Me.ComponentMetaData.FireError(0, "", strErrDesc, "", 0, True) - Where strErrDesc is error decription.

but still no luck

I tried setting the maxerrorcount to 0 but No Luck. Package still completes without any failure.

Any help or ideas are greatly appreciated.

Thanks,

Don

|||

You should return the failure value inside of your script main method. I do not remember the exact enumeration value but the intellisence will give it to you.

Thanks.

Error Redirected to Script Component : Package Doesnt fail.

I have created a data flow task. In that, in a 'data conversion', if a column fails validation then that row is redirected to a script component, which in turn writes the error to a variable.

But though the error is generated and script component receives the error, package doesnt fail.

Is there any way to set the package result to failure inside the script component? I tried set 'FailPackageOnFailure' to true but doesnt work.

Any help is greatly appreciated.

Thanks,

Don

donMahya wrote:

I have created a data flow task. In that, in a 'data conversion', if a column fails validation then that row is redirected to a script component, which in turn writes the error to a variable.

But though the error is generated and script component receives the error, package doesnt fail.

Is there any way to set the package result to failure inside the script component? I tried set 'FailPackageOnFailure' to true but doesnt work.

Any help is greatly appreciated.

Thanks,

Don

You could raise an error within the script component using:

Me.Events.FireError(...) (something like that anyway)

-Jamie

|||

Sorry for the delay. Wasnt working on this part for some time.

I tried

Me.ComponentMetaData.FireError(0, "", strErrDesc, "", 0, True) - Where strErrDesc is error decription.

but still no luck

I tried setting the maxerrorcount to 0 but No Luck. Package still completes without any failure.

Any help or ideas are greatly appreciated.

Thanks,

Don

|||

You should return the failure value inside of your script main method. I do not remember the exact enumeration value but the intellisence will give it to you.

Thanks.

error redirect to one file

Hi!

I have several lookups in my data flow task and for each of these I want to redirect error to one file (append data)

I created Flat File connection manager and first lookup goes fine with errors redirected to the file.

However, second error redirect that I am sending to the same file is failing.

Error I get is:

"[Flat File Destination 1 [14851]] Warning: The process cannot access the file because it is being used by another process.”

So my goal is to have one central file where I would redirect all records that fail.

thanks

Take all of the lookup error outputs and combine them with a union all component. Then, from the union all component go into your flat file destination.sql

error Pumping data from ODBC

Hi, there;

I created a package that pump data from ODBC to SQL2005.

When I run my package, I got error:

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.

Error: 0xC02090F5 at Data Flow Task, DataReader Source [1350]: The component "DataReader Source" (1350) was unable to process the data.

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "DataReader Source" (1350) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x402090DF at Data Flow Task, OLE DB Destination [1527]: The final commit for the data insertion has started.

Information: 0x402090E0 at Data Flow Task, OLE DB Destination [1527]: The final commit for the data insertion has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (1527)" wrote 0 rows.

Task failed: Data Flow Task

SSIS package "Package.dtsx" finished: Success.

Did I do something wrong when I created this package?

Thanks.

Did you use the ADO.NET connection manager to connect to your ODBC source? Can you use the ODBC source in other applications, outside of SSIS?|||

Yes, I am using ADO.NET. It works for other other tables. I just imported data from two other tables with same connection.

Haven't tried to use this ODBC source yet. But I will use it with C# application out of SSIS.

Thanks.

|||Try your ODBC connection against this table with an outside application. Sounds like you've set these up successfully before, so I would think you've got it setup correctly this time.

What ODBC driver are you using? (Against what database)|||Yes, I will.
It shows "D3 ODBC Driver".

Strange thing is that I can pump data for other tables with same connection.

Cheers.|||

Qiuwei wrote:

Yes, I will.
It shows "D3 ODBC Driver".

Strange thing is that I can pump data for other tables with same connection.

Cheers.

Maybe you don't have permission to select against this table.|||

Qiuwei wrote:

Yes, I will.
It shows "D3 ODBC Driver".

Strange thing is that I can pump data for other tables with same connection.

Cheers.

Trying Incresing the TimeOut property in the datareader. I was able to fix a similar issue before, in my case I had many packages running against the same ODBC source; and I was receiving *I belive* the same error in the 2 packages extracting the biggest set of data. Just a thought....

|||

Thanks.

Phil, yes, I have permission to select data from that ODBC source.

Rafael, I set to timeout to 600. It still doesn't want to work. It only has about 9,000 rows.

The problem SSIS users are facing is that the error message is almost useless and very easy to be crashed!

Does anybody know if MS has a web resource for those error code?

Cheers.

sql

Error processing a report connecting to an external SQL db

I created a report that uses data from an external SQL Server database. I
specified Windows Authentication. My NT account has full rights on the
external SQL server. When I run a report with ''localhost'' in the URL, it
works fine. However, when I use the actual server name, it first prompts me
for NT login/password (which is fine), but then I get the following:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection do data source 'MyDataSource'.
(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
My assumption after reading MS docs was that the Reporting Server would use
the current user's credentials to connect to the external data source, but
it's not happening.
Any ideas on how to fix this would be highly appreciated.
Thanks,
LeoHi Leo,
Did you find a solution to this? I have the same problem. Are running
Reporting Services/SQL Server 2005 and can not run reports which get data
from an external SQL Server 2000.
Thanks,
Soren
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||Any answer on this? I am having this problem as well. I am still just
running 2000 though. I am able to open and connect with several other
reports. But I have one that is not connecting and getting this error when I
click on the data tab. When I create the data source and test the
connection, it says it connects successfully.
Please someone answer this questions!!!!!!!!!!!!! :)
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||+1. I am hitting the same issue as well. Does any one have a solution for this?
Thanks
Sushmitha
"SharinDenver" wrote:
> Any answer on this? I am having this problem as well. I am still just
> running 2000 though. I am able to open and connect with several other
> reports. But I have one that is not connecting and getting this error when I
> click on the data tab. When I create the data source and test the
> connection, it says it connects successfully.
> Please someone answer this questions!!!!!!!!!!!!! :)
> "LeoW" wrote:
> > I created a report that uses data from an external SQL Server database. I
> > specified Windows Authentication. My NT account has full rights on the
> > external SQL server. When I run a report with ''localhost'' in the URL, it
> > works fine. However, when I use the actual server name, it first prompts me
> > for NT login/password (which is fine), but then I get the following:
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection do data source 'MyDataSource'.
> > (rsErrorOpeningConnection)
> > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> > My assumption after reading MS docs was that the Reporting Server would use
> > the current user's credentials to connect to the external data source, but
> > it's not happening.
> >
> > Any ideas on how to fix this would be highly appreciated.
> >
> > Thanks,
> > Leo|||Was this ever resolved? I see that the last post was posted a few months ago.
I am looking for a soltuion to the following:
Server A is the Web, SQL, and RS Server (2k all around). No issues with
reports.
Server B is a 2nd SQL box (2k as well.)
I create a report in VS 2k03 and can preview it no problem using a shared
data source with stored credentials.
When i deploy the report and try to generate it via Report Mgr, I get
"Cannot create a connection to data source..."
Any hints?
Much appreciated.
"Sushmitha Kini" wrote:
> +1. I am hitting the same issue as well. Does any one have a solution for this?
> Thanks
> Sushmitha
> "SharinDenver" wrote:
> > Any answer on this? I am having this problem as well. I am still just
> > running 2000 though. I am able to open and connect with several other
> > reports. But I have one that is not connecting and getting this error when I
> > click on the data tab. When I create the data source and test the
> > connection, it says it connects successfully.
> >
> > Please someone answer this questions!!!!!!!!!!!!! :)
> >
> > "LeoW" wrote:
> >
> > > I created a report that uses data from an external SQL Server database. I
> > > specified Windows Authentication. My NT account has full rights on the
> > > external SQL server. When I run a report with ''localhost'' in the URL, it
> > > works fine. However, when I use the actual server name, it first prompts me
> > > for NT login/password (which is fine), but then I get the following:
> > > An error has occurred during report processing. (rsProcessingAborted)
> > > Cannot create a connection do data source 'MyDataSource'.
> > > (rsErrorOpeningConnection)
> > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > > Server connection.
> > >
> > > My assumption after reading MS docs was that the Reporting Server would use
> > > the current user's credentials to connect to the external data source, but
> > > it's not happening.
> > >
> > > Any ideas on how to fix this would be highly appreciated.
> > >
> > > Thanks,
> > > Leo

Error Output for SQL Server Destination

I'm in the process of running some tests to determine which method is faster...

I created a data flow task OleDB Source -> Data Conversion -> OleDb Destination. Error outputs from the OleDB destination is sent to a flat file destination. This works great.

I'm importing millons of rows and found that using SQL Server Destination (local) is much faster than the OleDB Destination. However, I have not figured out how to output errors to a flat file destination like I did when using the OleDB destination.

Is there any way to trap errors in a flat file when using a SQL Server Destination?

Thanks!

NLC

OK..I found the answer to my problem. Books online indicates that SQL Server destination does not support an error output. I guess I'll have to use OleDB destination instead.

NLC

Error number: 1105 the primary group is full

Hi i am Oscar,
I have a problem with database Subscriber. I've created this database with
2 datafile (*.mdf). the first datafile has static size and second datafile
is define with unrestrictec file growth option . the replication have been
worked all time, until the disc has fulled. How is possible that database
Published has 1928 Mb size and Subscriber database grows up a lot of?
Have i configured something in Suscriber database?
Could you help me , please?
Best Regards
Message posted via http://www.sqlmonster.com
Very odd . On the subscriber are there any other tables which are not part
of the publication?
Also, please use sp_spaceused on the publisher and subscriber and post up
the results.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||well paul,
I have executed this storage procedure in Publisher and Suscriber y this
the results
Publishers.
BDIntranet8577.38 MB51.54 MB
1921176 KB973024 KB281384 KB666768 KB
Suscriber.
BDIntranet 55386.75 MB2567.94 MB
52550464 KB52194688 KB230888 KB124888 KB
There is datafile that it?s growing too much. i do not understand Why?
Best Regards,
oscar
Message posted via http://www.sqlmonster.com
|||I was expecting that most of the extra space would be unallocated, but that
is simply not the case. You have 44GB more space used on the subscriber.
Perhaps it is being used for other things apart from this subscription? Or
else you are not replicating deletes, and the subscriber holds all the
original data, much of which has been removed from the publisher?
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

error message while creating table in the database

Hi

I created database using SQL server and runs under Cassini. The creation of database is ok but I have a problem when I am creating the table in database. Whenever I execute the code to create the tables, it shows the error message like 'Server not found' or just hang there. Does anybody know why it hang while I am creating the table? Is it because of the code or it's the time out error. Pls help as I am very new to this area.

MZAre you tying to create tables in SQL Server (Query Analyzer or Enterprise Manager), or in Web Matrix, or in your web application code, or...? If you can clarify where you are experiencing problems we should be able to help.

Terri

Error message when trying to save modified maintenance plan?

I have a maintenance plan created that have been running for a few months.
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:

> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step a
nd
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dial
og
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then sav
e
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not save
d
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an optio
n.
Does any one have a solution ?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find th
e
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch
.
> John
> "Olav" wrote:
>|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I have the same problem when I try to modify a maintenance plan and then s
ave
> the changes I get an error message saying "No description found" - this ev
en
> happens when I try to rename the maintenance plan. The changes are not sa
ved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP
1)
> Recreating maintenance plans each time I want to modify them is not an opt
ion.
> Does any one have a solution ?
> "John Bell" wrote:
>|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and whe
n
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
>|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and w
hen
> I try and save it I get the error. If I create a plan using the Wizard it
s
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
>

Error message when trying to save modified maintenance plan?

I have a maintenance plan created that have been running for a few months.
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:
> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step and
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dialog
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then save
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not saved
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an option.
Does any one have a solution ?
"John Bell" wrote:
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find the
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch.
> John
> "Olav" wrote:
> > I have a maintenance plan created that have been running for a few months.
> >
> > Now I want to modify the plan and selected Modify on the plan and got into
> > an editor with the different steps. I selected "Edit" on the Backup step and
> > changed the name of the destination folder and clicked OK in that dialog.
> >
> > When I try to save the modified maintenance plan, I only get an error dialog
> > with "No description found".
> >
> > What is the problem?
> >
> > Olav
> >
> >
> >|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
> I have the same problem when I try to modify a maintenance plan and then save
> the changes I get an error message saying "No description found" - this even
> happens when I try to rename the maintenance plan. The changes are not saved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> Recreating maintenance plans each time I want to modify them is not an option.
> Does any one have a solution ?
> "John Bell" wrote:
> > Hi
> >
> > I am not sure about the error, you may want to use SQL Profiler to find the
> > statement causing the error and try to run this manually. The quickest
> > solution may be to drop the maintenance plan and re-create it from scratch.
> >
> > John
> >
> > "Olav" wrote:
> >
> > > I have a maintenance plan created that have been running for a few months.
> > >
> > > Now I want to modify the plan and selected Modify on the plan and got into
> > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > changed the name of the destination folder and clicked OK in that dialog.
> > >
> > > When I try to save the modified maintenance plan, I only get an error dialog
> > > with "No description found".
> > >
> > > What is the problem?
> > >
> > > Olav
> > >
> > >
> > >|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and when
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
> > I have the same problem when I try to modify a maintenance plan and then save
> > the changes I get an error message saying "No description found" - this even
> > happens when I try to rename the maintenance plan. The changes are not saved
> > and the maintenance plan executes ok.
> > I can create new plans using the wizard but not from scratch. I have
> > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > Recreating maintenance plans each time I want to modify them is not an option.
> >
> > Does any one have a solution ?
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > statement causing the error and try to run this manually. The quickest
> > > solution may be to drop the maintenance plan and re-create it from scratch.
> > >
> > > John
> > >
> > > "Olav" wrote:
> > >
> > > > I have a maintenance plan created that have been running for a few months.
> > > >
> > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > changed the name of the destination folder and clicked OK in that dialog.
> > > >
> > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > with "No description found".
> > > >
> > > > What is the problem?
> > > >
> > > > Olav
> > > >
> > > >
> > > >|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and when
> I try and save it I get the error. If I create a plan using the Wizard its
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
> > Hi
> >
> > Are you seeing this error? http://tinyurl.com/mj88y
> >
> > John
> >
> > "Bridgepark" wrote:
> >
> > > I have the same problem when I try to modify a maintenance plan and then save
> > > the changes I get an error message saying "No description found" - this even
> > > happens when I try to rename the maintenance plan. The changes are not saved
> > > and the maintenance plan executes ok.
> > > I can create new plans using the wizard but not from scratch. I have
> > > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > > Recreating maintenance plans each time I want to modify them is not an option.
> > >
> > > Does any one have a solution ?
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > > statement causing the error and try to run this manually. The quickest
> > > > solution may be to drop the maintenance plan and re-create it from scratch.
> > > >
> > > > John
> > > >
> > > > "Olav" wrote:
> > > >
> > > > > I have a maintenance plan created that have been running for a few months.
> > > > >
> > > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > > changed the name of the destination folder and clicked OK in that dialog.
> > > > >
> > > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > > with "No description found".
> > > > >
> > > > > What is the problem?
> > > > >
> > > > > Olav
> > > > >
> > > > >
> > > > >

Error message when deploying cube to remote server

Hello,

I created an account called sa2 to obtain access to create a datasource for the AdventureworksDW sample database on a remote server, and granted this user all rights on the database.

When I was ready to deploy the cube I typed in the machine name (sserver) in connection settings, and then deployed. However, I got an error:

"The connection either timed out or was lost."

I then tried:

sserver\sserver

but got:

"Error 1 The project could not be deployed to the 'sserver\sserver' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

Permissions issue for the sa2 account?

Are you trying to deploy from BIDS? Is the error message coming up during deployment or during processing?|||

Hello,

Yes, from Bids. Not sure at what point the error occurs, I select deploy, processing occurs and then the error message is displayed.

Since this post I dropped the firewall on the server, and the database seems to be ceated but errors occur, so deployment is not successful.

This link:

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

is suggesting that I can only login with a Windows account.

|||You need a Windows Account with administrator access to the Analysis Server to deploy the database (not necessarily an Windows Administrator account). You can use a SQL Server login for the connection from Analysis Services to the relational engine.|||Make sure you used the same windows login with remote server, same username and same password. I think the problem was in authentication method.

Best regards,

Hery|||

Hello,

Thanks for the suggestions everyone. The computer from which I am trying to deploy does not login to the network, so I don't have a profile which I can apply to the database. As a workaround for now I will deploy to localhost.

Error message when creating replication with generated SQL scripts

Hi all SQL Replication experts :)

I have created my production server as a distributor and a publication on that server. On my backup server I have created a pull subscription. After that I have generated SQL scripts on my backup server so I can create the pull subscription anytime.

To test my script I used sp_removedbreplication 'dbname' to remove replication on the backup server. I then used the generated SQL script to create the pull subscription again. I got this error message

Job 'ProdServName_DBName-BackServName-DBName401A48AE-D8DC-4F29-A610-13916370CD0B' started successfully.
Server: Msg 208, Level 16, State 1, Procedure sp_addsubscription, Line 135
Invalid object name 'syspublications'.

What does this Error message mean and what can I do about it?

Grateful for all answers
Best,
/M

It looks like the database you are trying to add the subscription to is not the publication database. Can you confirm that the add subscription job has all the correct parameters on it?

error message Only members of sysadmin role are allowed to update .....

Question to those who may have had this same error- it seems that I am not able to delete some of the reports that I have created. This just started happening recently and according to our system admin nothing has changed as far as permissions are concernced. We installed SP2 the other day and I was wondering if this could have anything to do with the error message below

by the way I am a member of the sysadmin group

thanks in advance

km

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login. Only members of sysadmin role are allowed to update or delete jobs owned by a different login. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String objectName) at Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch() End of inner exception stack trace

It looks like you are getting this error because the report has a schedule associated with it and most likely you recently changed the way you connect to the Report Server database. To fix this you will need to set the owner for all of the Report Server SQL Agent jobs to be the user that RS is using to connect to it's database.