Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

sql

Error in SQL Server Management Studio Express when Attach DB

Hello

When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs:

TITLE: Locate Database Files - ORION\SQLEXPRESS


C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

OK - Button

And directly after that error, when I click the OK-Button from the error above, I receive the "Locate Database Files"-Windows. But there I see only one partition G from my harddisk(but I have C, D, E, F, G).

I can not understand, why I should not have the necessary security privileges (The path exists at all events). In the Object Explorer I see all my DB's. And I can access on every DB without problems.

How can I solve this problem and attach an existing Database?

Mike50

Hi,

the service accoutn SQL Server is running on needs the appropiate priviledges to attach the database. Even if you have the rights to access the share, this doesn′t mean that SQL Server has, so make sure that the account which can be seen under the properties of the server (or in the service control panel) is priviledged.

(Make also sure that this isn′t a network drive you are using while loading something, if you want to load from the load you have to use the UNC syntac rather than the mapped drives, that much easier)

HTH, Jens Suessmeyer.

|||Hello,

Thanks for your quick answer.

It isn't a network drive, it's local. In the windows explorer, in the SQL Server folders under properties-->security, there I have acces to all folders for everybody (I changed all folders to give access to "everybody2)! But is this the right place to give the privileges? I tried a lot of things but nothing happend.

Can you please explain me, where exactly I have to look under properties of the server and change?

mike50
|||I solved the problem!

In the SQL Server properties, I had for log-in the account "NT AUTHORITY\NetworkService" and this NetworkService had no rights to access the program files folder! So I changed it to "Local Systemaccount" and now I can attach DB's.
But is this a good idea to start the SQL Server Service with this account?

mike50
|||Ok, wasn′t this what is said ?

HTH, Jens Suessmeyer.|||

Jens:

Yes, it was "close" to what you said. But I am still having this issue.

I have the SQL Server (MSSQLSERVER) account running under an account named ".\mssql".

I have the SQL Server Agent (MSSQLSERVER) account running under the same ".\mssql" account.

I have given this user account full rights on my D:\MsSql\ directory.

I have my default data and logs directory configured for D:\MsSql\Data\

I still get this error popping up when I click "add" in the Attach Database dialog window.

Any other ideas?

It is not wise to run the services under Local System account, as he asks above.

Error in SQL Server Management Studio Express when Attach DB

Hello

When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs:

TITLE: Locate Database Files - ORION\SQLEXPRESS


C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

OK - Button

And directly after that error, when I click the OK-Button from the error above, I receive the "Locate Database Files"-Windows. But there I see only one partition G from my harddisk(but I have C, D, E, F, G).

I can not understand, why I should not have the necessary security privileges (The path exists at all events). In the Object Explorer I see all my DB's. And I can access on every DB without problems.

How can I solve this problem and attach an existing Database?

Mike50

Hi,

the service accoutn SQL Server is running on needs the appropiate priviledges to attach the database. Even if you have the rights to access the share, this doesn′t mean that SQL Server has, so make sure that the account which can be seen under the properties of the server (or in the service control panel) is priviledged.

(Make also sure that this isn′t a network drive you are using while loading something, if you want to load from the load you have to use the UNC syntac rather than the mapped drives, that much easier)

HTH, Jens Suessmeyer.

|||Hello,

Thanks for your quick answer.

It isn't a network drive, it's local. In the windows explorer, in the SQL Server folders under properties-->security, there I have acces to all folders for everybody (I changed all folders to give access to "everybody2)! But is this the right place to give the privileges? I tried a lot of things but nothing happend.

Can you please explain me, where exactly I have to look under properties of the server and change?

mike50
|||I solved the problem!

In the SQL Server properties, I had for log-in the account "NT AUTHORITY\NetworkService" and this NetworkService had no rights to access the program files folder! So I changed it to "Local Systemaccount" and now I can attach DB's.
But is this a good idea to start the SQL Server Service with this account?

mike50
|||Ok, wasn′t this what is said ?

HTH, Jens Suessmeyer.|||

Jens:

Yes, it was "close" to what you said. But I am still having this issue.

I have the SQL Server (MSSQLSERVER) account running under an account named ".\mssql".

I have the SQL Server Agent (MSSQLSERVER) account running under the same ".\mssql" account.

I have given this user account full rights on my D:\MsSql\ directory.

I have my default data and logs directory configured for D:\MsSql\Data\

I still get this error popping up when I click "add" in the Attach Database dialog window.

Any other ideas?

It is not wise to run the services under Local System account, as he asks above.

Error in sql management express installation

Hi,

I had earlier installation of microsoft sql server 2005 in my machine. Recently I installed the visual studio 2005 beta which comes with sql express and after going through many hoops(as it kept complaining about the previous installation of beta components) i was able to install it correctly. I was also able to also use visaul studio 2005 server explorer to connect to the SQLEXPRESS and create table etc... Now I wanted to install sql server management express so I downloaded SQLEXPR_ADV from te microsoft's website. During the installation it complained about the older version of SQL server management sutdio installed and hence could not install the sql server management express. By looking at different forums I found following steps to deinstall earlier version but still runs into this issue. I will really appreciate somebody's help....

STPES I FOLLOWED TO REMOVE EARLIER VERSION OF SQL SERVER 2005 MANAGEMENT STUDIO

Click Start, and then click Control Panel.
Double-click Add or Remove Programs.
In the list of installed programs, click Microsoft SQL Server 2005, and then click Change.
On the Component Selection page, select Workstation components, and then click Next.
Click Next.
On the Change or Remove Instance page, click Change Installed Components.
Expand Client Components, click Management Tools, and then select Entire Feature will be Unavailable. Or just select the entire client components
Click Next.
Click Install.

2) I also tried to use the complete uninstall of visual studio ( By using the tolls

vs_unists_betas.exe) and after that also window uninstall clean up (msiccu2)

and then reinstalling visual studio 2005 beta which would install sql express...But

nothing seems to be able to uninstall the previous version of SQL SERVER 2005

Management studio from my computer and hence I am not able to uninstall the

sql server management express.

hi,

try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907736&SiteID=1 as well

regards

sql

Error in Registering Instance using Management Studio

Hi,

When I register instance --StockBroker, there is an error in the second step: installing Windows Service. The error message is:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

My setup testing was successful, and I used a domain account(admin) with the domain name.

What could be the problem? please help me out.

Double check your service account login credentials.

HTH..

Error in new SQL2K5 Performance Dashboard Reports

I tried this new SQL2K5 Performance Dashboard Reports using custom reports in Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

But running it first on any server gives me this error:

Difference of two datetime columns caused overflow at runtime.

Has anybody come across this error? How to fix it?

Thanks in advance!

- Rupesh

first check the sp2 is applied or not.

ref : http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx

Because DATEDIFF returns and int once you have connection that is more than 24 days or so old it will overflow the dattype if you modify the procedure so caluclates the differnce in minutes first converts this to milliseconds then add the number of minutes diffrence onto the start time and then calculate the remianing number of milli seconds it will work so basicalyy if you modify trhe offending line

sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

to

sum(convert(bigint, CAST ( DATEDIFF ( minute, login_time, getdate()) AS

BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute,

DATEDIFF ( minute, login_time, getdate() ), login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

then it will work

hopes this helps the rest of you who have the same problem.

Madhu

|||

Hi,

I am facing an error saying ‘Arithmetic overflow error converting expression to data type datetime.’ In data base due to my following query.

Then I tried with cast and convert function too, still I got the error.

select*

from datetable

wherecast(('May 29 20076:30:00:000PM' - endtime) as int) >=2

andcast(('May 29 20076:30:00:000PM' - endtime)as int)<=3

anddatetable_id= 102

order by datetable_iddesc

I got this beacause of some bad ‘endtime’ data in datetable for datetable_id102 : 5465-08-12 12:00:00.000.

But I need to support all type of date here and the table is also huge. So I have this col as indexed.

I thought of to use datediff func here. again I am not sure what will be the performance impact on my query, coz it will diff and convert to int and compare for each of the row.

So can any body suggest how efficiently can I handle this?

Thanks

~Dhiru

Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

Who can tell me how to resolve it?

Any response is appreciated.

Thanks^_^

Winnie

You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify?

Thanks^_^

Winnie

|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?

|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?

|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in maintenance plan after SP2

Before SP2 my maintenance plan was stable.
Now, I get the following when I try to modify the plan:
Microsoft SQL Server Management Studio is unable to load this document:
Retrieving the COM class factory for component with CLSID
{E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
8007007e
I can't edit the plan or delete the plan.
The logs say that the plan is running and succesfully backing up the
databases, but there are no files being produced in the backup directory. I
do not know where the files are going.
Note that the only modification to the SQL Server was the addition of SP2.
Prior to that everything was working.
Any suggestions will be appreciated.Ron
What is the status of MP? Is it in progress. I got the error when I tried to
run MP created on SP1 after installing SP2, but I was able to delete it an d
re-create. After that it works fine
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
> Before SP2 my maintenance plan was stable.
> Now, I get the following when I try to modify the plan:
> Microsoft SQL Server Management Studio is unable to load this document:
> Retrieving the COM class factory for component with CLSID
> {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> 8007007e
> I can't edit the plan or delete the plan.
> The logs say that the plan is running and succesfully backing up the
> databases, but there are no files being produced in the backup directory.
> I
> do not know where the files are going.
> Note that the only modification to the SQL Server was the addition of SP2.
> Prior to that everything was working.
> Any suggestions will be appreciated.|||I can't delete it, look at it, modify it, or anyhting. I get the same error
if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
mentioned in the error that appears when I try to create a new entry.
The log files indicate that it does run, but the backup is being sent to the
VIRTUAL_DEVICE. Note that the plan history has not had any entries since I
installed the SP2, but the SQL Server log says that the maintenance plan is
making the backup at the correct time.
The full error that appears when I try to create a new plan is below:
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
--
Program Location:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at
Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
===================================
Retrieving the COM class factory for component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error:
8007007e. (Microsoft.SqlServer.ManagedDTS)
--
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
"Uri Dimant" wrote:
> Ron
> What is the status of MP? Is it in progress. I got the error when I tried to
> run MP created on SP1 after installing SP2, but I was able to delete it an d
> re-create. After that it works fine
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
> > Before SP2 my maintenance plan was stable.
> >
> > Now, I get the following when I try to modify the plan:
> > Microsoft SQL Server Management Studio is unable to load this document:
> > Retrieving the COM class factory for component with CLSID
> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> > 8007007e
> >
> > I can't edit the plan or delete the plan.
> >
> > The logs say that the plan is running and succesfully backing up the
> > databases, but there are no files being produced in the backup directory.
> > I
> > do not know where the files are going.
> >
> > Note that the only modification to the SQL Server was the addition of SP2.
> > Prior to that everything was working.
> >
> > Any suggestions will be appreciated.
>
>|||Ron
It looks like you have a DTS/SSIS Package tied in MP. Am I right?
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...
>I can't delete it, look at it, modify it, or anyhting. I get the same error
> if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
> mentioned in the error that appears when I try to create a new entry.
> The log files indicate that it does run, but the backup is being sent to
> the
> VIRTUAL_DEVICE. Note that the plan history has not had any entries since I
> installed the SP2, but the SQL Server log says that the maintenance plan
> is
> making the backup at the correct time.
> The full error that appears when I try to create a new plan is below:
> ===================================> Exception has been thrown by the target of an invocation. (mscorlib)
> --
> Program Location:
> at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> ctor,
> Boolean& bNeedSecurityCheck)
> at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> fillCache)
> at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> skipVisibilityChecks, Boolean fillCache)
> at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
> ===================================> Retrieving the COM class factory for component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error:
> 8007007e. (Microsoft.SqlServer.ManagedDTS)
> --
> Program Location:
> at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
>
> "Uri Dimant" wrote:
>> Ron
>> What is the status of MP? Is it in progress. I got the error when I tried
>> to
>> run MP created on SP1 after installing SP2, but I was able to delete it
>> an d
>> re-create. After that it works fine
>> "Ron" <Ron@.discussions.microsoft.com> wrote in message
>> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
>> > Before SP2 my maintenance plan was stable.
>> >
>> > Now, I get the following when I try to modify the plan:
>> > Microsoft SQL Server Management Studio is unable to load this document:
>> > Retrieving the COM class factory for component with CLSID
>> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
>> > error:
>> > 8007007e
>> >
>> > I can't edit the plan or delete the plan.
>> >
>> > The logs say that the plan is running and succesfully backing up the
>> > databases, but there are no files being produced in the backup
>> > directory.
>> > I
>> > do not know where the files are going.
>> >
>> > Note that the only modification to the SQL Server was the addition of
>> > SP2.
>> > Prior to that everything was working.
>> >
>> > Any suggestions will be appreciated.
>>|||.Hi
There has been an issue with maintenance plans for SP2 see
https://blogs.msdn.com/sqlrem/ for more information, although on the face of
it your descriptions does not seem to be the same thing. It seems that a COM
class has been unregistered.
Is this a legacy maintenance plan or a new one?
Have you tried re-applying the Microsoft SQL Server 2000 DTS Designer
Components from the February 2007 - Feature Pack for Microsoft SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
John
"Ron" wrote:
> Before SP2 my maintenance plan was stable.
> Now, I get the following when I try to modify the plan:
> Microsoft SQL Server Management Studio is unable to load this document:
> Retrieving the COM class factory for component with CLSID
> {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> 8007007e
> I can't edit the plan or delete the plan.
> The logs say that the plan is running and succesfully backing up the
> databases, but there are no files being produced in the backup directory. I
> do not know where the files are going.
> Note that the only modification to the SQL Server was the addition of SP2.
> Prior to that everything was working.
> Any suggestions will be appreciated.|||Thanks for your help...
The maintenance plan was created under SQL Server 2005 SP1 early in December
using the maintnenance wizard. All it is supposed to do is to back the
databases up to an internal drive. It worked OK until I installed SP2. The
only thing that has changed on the machine is the application of SQL Server
SP2 and any updates applied by the Windows Update program.
The SQL Server 2005 installation was done on a fresh computer about December
5. This is a development machine with the Visual Studio, etc. installed.
At this point, I cannot do anything with maintenance plans without getting
the same error. Whether I go through the wizard or by hand, I cannot create a
new MP, I cannot delete the existing MP and I cannot alter the existing MP.
"John Bell" wrote:
> .Hi
> There has been an issue with maintenance plans for SP2 see
> https://blogs.msdn.com/sqlrem/ for more information, although on the face of
> it your descriptions does not seem to be the same thing. It seems that a COM
> class has been unregistered.
> Is this a legacy maintenance plan or a new one?
> Have you tried re-applying the Microsoft SQL Server 2000 DTS Designer
> Components from the February 2007 - Feature Pack for Microsoft SQL Server 2005
> http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
> John
> "Ron" wrote:
> > Before SP2 my maintenance plan was stable.
> >
> > Now, I get the following when I try to modify the plan:
> > Microsoft SQL Server Management Studio is unable to load this document:
> > Retrieving the COM class factory for component with CLSID
> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> > 8007007e
> >
> > I can't edit the plan or delete the plan.
> >
> > The logs say that the plan is running and succesfully backing up the
> > databases, but there are no files being produced in the backup directory. I
> > do not know where the files are going.
> >
> > Note that the only modification to the SQL Server was the addition of SP2.
> > Prior to that everything was working.
> >
> > Any suggestions will be appreciated.|||Thanks for your help...
The maintenance plan was created under SQL Server 2005 SP1 early in December
using the maintnenance wizard. All it is supposed to do is to back the
databases up to an internal drive. It worked OK until I installed SP2. The
only thing that has changed on the machine is the application of SQL Server
SP2 and any updates applied by the Windows Update program.
The SQL Server 2005 installation was done on a fresh computer about December
5. This is a development machine with the Visual Studio, etc. installed.
At this point, I cannot do anything with maintenance plans without getting
the same error. Whether I go through the wizard or by hand, I cannot create a
new MP, I cannot delete the existing MP and I cannot alter the existing MP.
"Uri Dimant" wrote:
> Ron
> It looks like you have a DTS/SSIS Package tied in MP. Am I right?
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...
> >I can't delete it, look at it, modify it, or anyhting. I get the same error
> > if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
> > mentioned in the error that appears when I try to create a new entry.
> >
> > The log files indicate that it does run, but the backup is being sent to
> > the
> > VIRTUAL_DEVICE. Note that the plan history has not had any entries since I
> > installed the SP2, but the SQL Server log says that the maintenance plan
> > is
> > making the backup at the correct time.
> >
> > The full error that appears when I try to create a new plan is below:
> > ===================================> >
> > Exception has been thrown by the target of an invocation. (mscorlib)
> >
> > --
> > Program Location:
> >
> > at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> > ctor,
> > Boolean& bNeedSecurityCheck)
> > at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> > fillCache)
> > at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> > skipVisibilityChecks, Boolean fillCache)
> > at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> > at
> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
> >
> > ===================================> >
> > Retrieving the COM class factory for component with CLSID
> > {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error:
> > 8007007e. (Microsoft.SqlServer.ManagedDTS)
> >
> > --
> > Program Location:
> >
> > at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
> >
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Ron
> >>
> >> What is the status of MP? Is it in progress. I got the error when I tried
> >> to
> >> run MP created on SP1 after installing SP2, but I was able to delete it
> >> an d
> >> re-create. After that it works fine
> >>
> >> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> >> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
> >> > Before SP2 my maintenance plan was stable.
> >> >
> >> > Now, I get the following when I try to modify the plan:
> >> > Microsoft SQL Server Management Studio is unable to load this document:
> >> > Retrieving the COM class factory for component with CLSID
> >> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
> >> > error:
> >> > 8007007e
> >> >
> >> > I can't edit the plan or delete the plan.
> >> >
> >> > The logs say that the plan is running and succesfully backing up the
> >> > databases, but there are no files being produced in the backup
> >> > directory.
> >> > I
> >> > do not know where the files are going.
> >> >
> >> > Note that the only modification to the SQL Server was the addition of
> >> > SP2.
> >> > Prior to that everything was working.
> >> >
> >> > Any suggestions will be appreciated.
> >>
> >>
> >>
>
>|||Ron,
I had something similar in trying to delete a job created by an SQL2005 MP.
You could do this in SQL2000 but not 2005. Maybe try deleting the job(s)
then try deleting the MP.
Chris
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3FC825C3-1059-4DBA-8E23-34666B8B5F5E@.microsoft.com...
> Thanks for your help...
> The maintenance plan was created under SQL Server 2005 SP1 early in
> December
> using the maintnenance wizard. All it is supposed to do is to back the
> databases up to an internal drive. It worked OK until I installed SP2. The
> only thing that has changed on the machine is the application of SQL
> Server
> SP2 and any updates applied by the Windows Update program.
> The SQL Server 2005 installation was done on a fresh computer about
> December
> 5. This is a development machine with the Visual Studio, etc. installed.
> At this point, I cannot do anything with maintenance plans without getting
> the same error. Whether I go through the wizard or by hand, I cannot
> create a
> new MP, I cannot delete the existing MP and I cannot alter the existing
> MP.
>
> "John Bell" wrote:
>> .Hi
>> There has been an issue with maintenance plans for SP2 see
>> https://blogs.msdn.com/sqlrem/ for more information, although on the face
>> of
>> it your descriptions does not seem to be the same thing. It seems that a
>> COM
>> class has been unregistered.
>> Is this a legacy maintenance plan or a new one?
>> Have you tried re-applying the Microsoft SQL Server 2000 DTS Designer
>> Components from the February 2007 - Feature Pack for Microsoft SQL Server
>> 2005
>> http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
>> John
>> "Ron" wrote:
>> > Before SP2 my maintenance plan was stable.
>> >
>> > Now, I get the following when I try to modify the plan:
>> > Microsoft SQL Server Management Studio is unable to load this document:
>> > Retrieving the COM class factory for component with CLSID
>> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
>> > error:
>> > 8007007e
>> >
>> > I can't edit the plan or delete the plan.
>> >
>> > The logs say that the plan is running and succesfully backing up the
>> > databases, but there are no files being produced in the backup
>> > directory. I
>> > do not know where the files are going.
>> >
>> > Note that the only modification to the SQL Server was the addition of
>> > SP2.
>> > Prior to that everything was working.
>> >
>> > Any suggestions will be appreciated.|||Rom
I have no idea, sorry, probably you will need to re-install SQL Server 2005
and apply SP2
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:AD4BA58C-E05E-4A30-AD87-B2A9096CBA65@.microsoft.com...
> Thanks for your help...
> The maintenance plan was created under SQL Server 2005 SP1 early in
> December
> using the maintnenance wizard. All it is supposed to do is to back the
> databases up to an internal drive. It worked OK until I installed SP2. The
> only thing that has changed on the machine is the application of SQL
> Server
> SP2 and any updates applied by the Windows Update program.
> The SQL Server 2005 installation was done on a fresh computer about
> December
> 5. This is a development machine with the Visual Studio, etc. installed.
> At this point, I cannot do anything with maintenance plans without getting
> the same error. Whether I go through the wizard or by hand, I cannot
> create a
> new MP, I cannot delete the existing MP and I cannot alter the existing
> MP.
> "Uri Dimant" wrote:
>> Ron
>> It looks like you have a DTS/SSIS Package tied in MP. Am I right?
>> "Ron" <Ron@.discussions.microsoft.com> wrote in message
>> news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...
>> >I can't delete it, look at it, modify it, or anyhting. I get the same
>> >error
>> > if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
>> > mentioned in the error that appears when I try to create a new entry.
>> >
>> > The log files indicate that it does run, but the backup is being sent
>> > to
>> > the
>> > VIRTUAL_DEVICE. Note that the plan history has not had any entries
>> > since I
>> > installed the SP2, but the SQL Server log says that the maintenance
>> > plan
>> > is
>> > making the backup at the correct time.
>> >
>> > The full error that appears when I try to create a new plan is below:
>> > ===================================>> >
>> > Exception has been thrown by the target of an invocation. (mscorlib)
>> >
>> > --
>> > Program Location:
>> >
>> > at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
>> > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
>> > ctor,
>> > Boolean& bNeedSecurityCheck)
>> > at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
>> > fillCache)
>> > at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
>> > skipVisibilityChecks, Boolean fillCache)
>> > at System.Activator.CreateInstance(Type type, Boolean nonPublic)
>> > at
>> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
>> >
>> > ===================================>> >
>> > Retrieving the COM class factory for component with CLSID
>> > {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following
>> > error:
>> > 8007007e. (Microsoft.SqlServer.ManagedDTS)
>> >
>> > --
>> > Program Location:
>> >
>> > at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
>> >
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Ron
>> >>
>> >> What is the status of MP? Is it in progress. I got the error when I
>> >> tried
>> >> to
>> >> run MP created on SP1 after installing SP2, but I was able to delete
>> >> it
>> >> an d
>> >> re-create. After that it works fine
>> >>
>> >> "Ron" <Ron@.discussions.microsoft.com> wrote in message
>> >> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
>> >> > Before SP2 my maintenance plan was stable.
>> >> >
>> >> > Now, I get the following when I try to modify the plan:
>> >> > Microsoft SQL Server Management Studio is unable to load this
>> >> > document:
>> >> > Retrieving the COM class factory for component with CLSID
>> >> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
>> >> > error:
>> >> > 8007007e
>> >> >
>> >> > I can't edit the plan or delete the plan.
>> >> >
>> >> > The logs say that the plan is running and succesfully backing up the
>> >> > databases, but there are no files being produced in the backup
>> >> > directory.
>> >> > I
>> >> > do not know where the files are going.
>> >> >
>> >> > Note that the only modification to the SQL Server was the addition
>> >> > of
>> >> > SP2.
>> >> > Prior to that everything was working.
>> >> >
>> >> > Any suggestions will be appreciated.
>> >>
>> >>
>> >>
>>|||Hi Ron
Have you check the service pack log to see if there was any error when
installing SP2? What does SELECT @.@.VERSION return?
John|||Again, thanks for the help.
The @.@.Version...
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
On the error logs.......
The summary.txt file showed error number 3010 under the SQL Server Native
Client and the MSXML 6.0 Parser. There was no error description included.
When I looked at the detail logs for these items I found the following entry
at the end of the log (the entry was similar for both logs):
MSI (s) (78:B8) [08:26:27:812]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (78:B8) [08:26:27:812]: Post-install cleanup: removing installer
file 'C:\WINDOWS\Installer\b817255.msi'
MSI (s) (78:B8) [08:26:27:890]: Post-install cleanup: removing installer
file 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\ARPIco'
MSI (s) (78:B8) [08:26:27:906]: Post-install cleanup: removing installer
folder 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\' (if
empty)
MSI (s) (78:B8) [08:26:27:921]: MainEngineThread is returning 3010
MSI (s) (78:B4) [08:26:28:015]: Destroying RemoteAPI object.
MSI (s) (78:94) [08:26:28:015]: Custom Action Manager thread ending.
=== Logging stopped: 2/22/2007 8:26:27 ===MSI (c) (B0:F0) [08:26:28:015]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B0:F0) [08:26:28:015]: MainEngineThread is returning 3010
=== Verbose logging stopped: 2/22/2007 8:26:28 ===
This is the only reference to 3010 and I did not see anything in the detail
logs that looked like an error. However, since I am not familiar with those
logs and they are big, there may be somethng that I missed.
I think that the 3010 just indicates that a reboot will be required to
finish the job.
"John Bell" wrote:
> Hi Ron
> Have you check the service pack log to see if there was any error when
> installing SP2? What does SELECT @.@.VERSION return?
> John|||Thanks for your help!
"Uri Dimant" wrote:
> Rom
> I have no idea, sorry, probably you will need to re-install SQL Server 2005
> and apply SP2
>
>
>
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:AD4BA58C-E05E-4A30-AD87-B2A9096CBA65@.microsoft.com...
> > Thanks for your help...
> >
> > The maintenance plan was created under SQL Server 2005 SP1 early in
> > December
> > using the maintnenance wizard. All it is supposed to do is to back the
> > databases up to an internal drive. It worked OK until I installed SP2. The
> > only thing that has changed on the machine is the application of SQL
> > Server
> > SP2 and any updates applied by the Windows Update program.
> >
> > The SQL Server 2005 installation was done on a fresh computer about
> > December
> > 5. This is a development machine with the Visual Studio, etc. installed.
> >
> > At this point, I cannot do anything with maintenance plans without getting
> > the same error. Whether I go through the wizard or by hand, I cannot
> > create a
> > new MP, I cannot delete the existing MP and I cannot alter the existing
> > MP.
> >
> > "Uri Dimant" wrote:
> >
> >> Ron
> >>
> >> It looks like you have a DTS/SSIS Package tied in MP. Am I right?
> >>
> >> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> >> news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...
> >> >I can't delete it, look at it, modify it, or anyhting. I get the same
> >> >error
> >> > if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
> >> > mentioned in the error that appears when I try to create a new entry.
> >> >
> >> > The log files indicate that it does run, but the backup is being sent
> >> > to
> >> > the
> >> > VIRTUAL_DEVICE. Note that the plan history has not had any entries
> >> > since I
> >> > installed the SP2, but the SQL Server log says that the maintenance
> >> > plan
> >> > is
> >> > making the backup at the correct time.
> >> >
> >> > The full error that appears when I try to create a new plan is below:
> >> > ===================================> >> >
> >> > Exception has been thrown by the target of an invocation. (mscorlib)
> >> >
> >> > --
> >> > Program Location:
> >> >
> >> > at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> >> > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> >> > ctor,
> >> > Boolean& bNeedSecurityCheck)
> >> > at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> >> > fillCache)
> >> > at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> >> > skipVisibilityChecks, Boolean fillCache)
> >> > at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> >> > at
> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
> >> >
> >> > ===================================> >> >
> >> > Retrieving the COM class factory for component with CLSID
> >> > {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following
> >> > error:
> >> > 8007007e. (Microsoft.SqlServer.ManagedDTS)
> >> >
> >> > --
> >> > Program Location:
> >> >
> >> > at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
> >> >
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Ron
> >> >>
> >> >> What is the status of MP? Is it in progress. I got the error when I
> >> >> tried
> >> >> to
> >> >> run MP created on SP1 after installing SP2, but I was able to delete
> >> >> it
> >> >> an d
> >> >> re-create. After that it works fine
> >> >>
> >> >> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> >> >> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
> >> >> > Before SP2 my maintenance plan was stable.
> >> >> >
> >> >> > Now, I get the following when I try to modify the plan:
> >> >> > Microsoft SQL Server Management Studio is unable to load this
> >> >> > document:
> >> >> > Retrieving the COM class factory for component with CLSID
> >> >> > {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
> >> >> > error:
> >> >> > 8007007e
> >> >> >
> >> >> > I can't edit the plan or delete the plan.
> >> >> >
> >> >> > The logs say that the plan is running and succesfully backing up the
> >> >> > databases, but there are no files being produced in the backup
> >> >> > directory.
> >> >> > I
> >> >> > do not know where the files are going.
> >> >> >
> >> >> > Note that the only modification to the SQL Server was the addition
> >> >> > of
> >> >> > SP2.
> >> >> > Prior to that everything was working.
> >> >> >
> >> >> > Any suggestions will be appreciated.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi
3010 is a reboot required status see
http://support.microsoft.com/default.aspx/kb/290158/
I can't really suggest anything else apart from a call to PSS if you want to
get this resolved without re-installing.
John
"Ron" wrote:
> Again, thanks for the help.
> The @.@.Version...
> Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> On the error logs.......
> The summary.txt file showed error number 3010 under the SQL Server Native
> Client and the MSXML 6.0 Parser. There was no error description included.
> When I looked at the detail logs for these items I found the following entry
> at the end of the log (the entry was similar for both logs):
> MSI (s) (78:B8) [08:26:27:812]: Cleaning up uninstalled install packages, if
> any exist
> MSI (s) (78:B8) [08:26:27:812]: Post-install cleanup: removing installer
> file 'C:\WINDOWS\Installer\b817255.msi'
> MSI (s) (78:B8) [08:26:27:890]: Post-install cleanup: removing installer
> file 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\ARPIco'
> MSI (s) (78:B8) [08:26:27:906]: Post-install cleanup: removing installer
> folder 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\' (if
> empty)
> MSI (s) (78:B8) [08:26:27:921]: MainEngineThread is returning 3010
> MSI (s) (78:B4) [08:26:28:015]: Destroying RemoteAPI object.
> MSI (s) (78:94) [08:26:28:015]: Custom Action Manager thread ending.
> === Logging stopped: 2/22/2007 8:26:27 ===> MSI (c) (B0:F0) [08:26:28:015]: Decrementing counter to disable shutdown. If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (B0:F0) [08:26:28:015]: MainEngineThread is returning 3010
> === Verbose logging stopped: 2/22/2007 8:26:28 ===> This is the only reference to 3010 and I did not see anything in the detail
> logs that looked like an error. However, since I am not familiar with those
> logs and they are big, there may be somethng that I missed.
> I think that the 3010 just indicates that a reboot will be required to
> finish the job.
>
> "John Bell" wrote:
> > Hi Ron
> >
> > Have you check the service pack log to see if there was any error when
> > installing SP2? What does SELECT @.@.VERSION return?
> >
> > John|||Thanks for your help. I can probably reinstall faster than I can call PSS so
that is what I will do.
"John Bell" wrote:
> Hi
> 3010 is a reboot required status see
> http://support.microsoft.com/default.aspx/kb/290158/
> I can't really suggest anything else apart from a call to PSS if you want to
> get this resolved without re-installing.
> John
> "Ron" wrote:
> > Again, thanks for the help.
> >
> > The @.@.Version...
> > Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
> > Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
> > NT 5.1 (Build 2600: Service Pack 2)
> >
> > On the error logs.......
> > The summary.txt file showed error number 3010 under the SQL Server Native
> > Client and the MSXML 6.0 Parser. There was no error description included.
> >
> > When I looked at the detail logs for these items I found the following entry
> > at the end of the log (the entry was similar for both logs):
> > MSI (s) (78:B8) [08:26:27:812]: Cleaning up uninstalled install packages, if
> > any exist
> > MSI (s) (78:B8) [08:26:27:812]: Post-install cleanup: removing installer
> > file 'C:\WINDOWS\Installer\b817255.msi'
> > MSI (s) (78:B8) [08:26:27:890]: Post-install cleanup: removing installer
> > file 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\ARPIco'
> > MSI (s) (78:B8) [08:26:27:906]: Post-install cleanup: removing installer
> > folder 'C:\WINDOWS\Installer\{50A0893D-47D8-48E0-A7E8-44BCD7E4422E}\' (if
> > empty)
> > MSI (s) (78:B8) [08:26:27:921]: MainEngineThread is returning 3010
> > MSI (s) (78:B4) [08:26:28:015]: Destroying RemoteAPI object.
> > MSI (s) (78:94) [08:26:28:015]: Custom Action Manager thread ending.
> > === Logging stopped: 2/22/2007 8:26:27 ===> > MSI (c) (B0:F0) [08:26:28:015]: Decrementing counter to disable shutdown. If
> > counter >= 0, shutdown will be denied. Counter after decrement: -1
> > MSI (c) (B0:F0) [08:26:28:015]: MainEngineThread is returning 3010
> > === Verbose logging stopped: 2/22/2007 8:26:28 ===> >
> > This is the only reference to 3010 and I did not see anything in the detail
> > logs that looked like an error. However, since I am not familiar with those
> > logs and they are big, there may be somethng that I missed.
> >
> > I think that the 3010 just indicates that a reboot will be required to
> > finish the job.
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Ron
> > >
> > > Have you check the service pack log to see if there was any error when
> > > installing SP2? What does SELECT @.@.VERSION return?
> > >
> > > John

Error in maintenance plan after SP2

Before SP2 my maintenance plan was stable.
Now, I get the following when I try to modify the plan:
Microsoft SQL Server Management Studio is unable to load this document:
Retrieving the COM class factory for component with CLSID
{E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
8007007e
I can't edit the plan or delete the plan.
The logs say that the plan is running and succesfully backing up the
databases, but there are no files being produced in the backup directory. I
do not know where the files are going.
Note that the only modification to the SQL Server was the addition of SP2.
Prior to that everything was working.
Any suggestions will be appreciated.
Ron
What is the status of MP? Is it in progress. I got the error when I tried to
run MP created on SP1 after installing SP2, but I was able to delete it an d
re-create. After that it works fine
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
> Before SP2 my maintenance plan was stable.
> Now, I get the following when I try to modify the plan:
> Microsoft SQL Server Management Studio is unable to load this document:
> Retrieving the COM class factory for component with CLSID
> {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> 8007007e
> I can't edit the plan or delete the plan.
> The logs say that the plan is running and succesfully backing up the
> databases, but there are no files being produced in the backup directory.
> I
> do not know where the files are going.
> Note that the only modification to the SQL Server was the addition of SP2.
> Prior to that everything was working.
> Any suggestions will be appreciated.
|||I can't delete it, look at it, modify it, or anyhting. I get the same error
if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
mentioned in the error that appears when I try to create a new entry.
The log files indicate that it does run, but the backup is being sent to the
VIRTUAL_DEVICE. Note that the plan history has not had any entries since I
installed the SP2, but the SQL Server log says that the maintenance plan is
making the backup at the correct time.
The full error that appears when I try to create a new plan is below:
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
Program Location:
at System.RuntimeTypeHandle.CreateInstance(RuntimeTyp e type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor,
Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .MaintDesignerMenuHandler.Invoke()
===================================
Retrieving the COM class factory for component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error:
8007007e. (Microsoft.SqlServer.ManagedDTS)
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
"Uri Dimant" wrote:

> Ron
> What is the status of MP? Is it in progress. I got the error when I tried to
> run MP created on SP1 after installing SP2, but I was able to delete it an d
> re-create. After that it works fine
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:6AAF8BAC-21E4-4C90-86BE-248AE268A0A0@.microsoft.com...
>
>
|||Ron
It looks like you have a DTS/SSIS Package tied in MP. Am I right?
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...[vbcol=seagreen]
>I can't delete it, look at it, modify it, or anyhting. I get the same error
> if I try to create a new plan. The Microsoft.SqlServer.ManagedDTS is
> mentioned in the error that appears when I try to create a new entry.
> The log files indicate that it does run, but the backup is being sent to
> the
> VIRTUAL_DEVICE. Note that the plan history has not had any entries since I
> installed the SP2, but the SQL Server log says that the maintenance plan
> is
> making the backup at the correct time.
> The full error that appears when I try to create a new plan is below:
> ===================================
> Exception has been thrown by the target of an invocation. (mscorlib)
> --
> Program Location:
> at System.RuntimeTypeHandle.CreateInstance(RuntimeTyp e type, Boolean
> publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> ctor,
> Boolean& bNeedSecurityCheck)
> at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> fillCache)
> at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> skipVisibilityChecks, Boolean fillCache)
> at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance .MaintDesignerMenuHandler.Invoke()
> ===================================
> Retrieving the COM class factory for component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error:
> 8007007e. (Microsoft.SqlServer.ManagedDTS)
> --
> Program Location:
> at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
>
> "Uri Dimant" wrote:
|||..Hi
There has been an issue with maintenance plans for SP2 see
https://blogs.msdn.com/sqlrem/ for more information, although on the face of
it your descriptions does not seem to be the same thing. It seems that a COM
class has been unregistered.
Is this a legacy maintenance plan or a new one?
Have you tried re-applying the Microsoft SQL Server 2000 DTS Designer
Components from the February 2007 - Feature Pack for Microsoft SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
John
"Ron" wrote:

> Before SP2 my maintenance plan was stable.
> Now, I get the following when I try to modify the plan:
> Microsoft SQL Server Management Studio is unable to load this document:
> Retrieving the COM class factory for component with CLSID
> {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error:
> 8007007e
> I can't edit the plan or delete the plan.
> The logs say that the plan is running and succesfully backing up the
> databases, but there are no files being produced in the backup directory. I
> do not know where the files are going.
> Note that the only modification to the SQL Server was the addition of SP2.
> Prior to that everything was working.
> Any suggestions will be appreciated.
|||Thanks for your help...
The maintenance plan was created under SQL Server 2005 SP1 early in December
using the maintnenance wizard. All it is supposed to do is to back the
databases up to an internal drive. It worked OK until I installed SP2. The
only thing that has changed on the machine is the application of SQL Server
SP2 and any updates applied by the Windows Update program.
The SQL Server 2005 installation was done on a fresh computer about December
5. This is a development machine with the Visual Studio, etc. installed.
At this point, I cannot do anything with maintenance plans without getting
the same error. Whether I go through the wizard or by hand, I cannot create a
new MP, I cannot delete the existing MP and I cannot alter the existing MP.
"John Bell" wrote:
[vbcol=seagreen]
> .Hi
> There has been an issue with maintenance plans for SP2 see
> https://blogs.msdn.com/sqlrem/ for more information, although on the face of
> it your descriptions does not seem to be the same thing. It seems that a COM
> class has been unregistered.
> Is this a legacy maintenance plan or a new one?
> Have you tried re-applying the Microsoft SQL Server 2000 DTS Designer
> Components from the February 2007 - Feature Pack for Microsoft SQL Server 2005
> http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
> John
> "Ron" wrote:
|||Thanks for your help...
The maintenance plan was created under SQL Server 2005 SP1 early in December
using the maintnenance wizard. All it is supposed to do is to back the
databases up to an internal drive. It worked OK until I installed SP2. The
only thing that has changed on the machine is the application of SQL Server
SP2 and any updates applied by the Windows Update program.
The SQL Server 2005 installation was done on a fresh computer about December
5. This is a development machine with the Visual Studio, etc. installed.
At this point, I cannot do anything with maintenance plans without getting
the same error. Whether I go through the wizard or by hand, I cannot create a
new MP, I cannot delete the existing MP and I cannot alter the existing MP.
"Uri Dimant" wrote:

> Ron
> It looks like you have a DTS/SSIS Package tied in MP. Am I right?
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:EBD00BB2-A0A2-412C-AA31-33AA51B3EF1B@.microsoft.com...
>
>
|||Ron,
I had something similar in trying to delete a job created by an SQL2005 MP.
You could do this in SQL2000 but not 2005. Maybe try deleting the job(s)
then try deleting the MP.
Chris
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3FC825C3-1059-4DBA-8E23-34666B8B5F5E@.microsoft.com...[vbcol=seagreen]
> Thanks for your help...
> The maintenance plan was created under SQL Server 2005 SP1 early in
> December
> using the maintnenance wizard. All it is supposed to do is to back the
> databases up to an internal drive. It worked OK until I installed SP2. The
> only thing that has changed on the machine is the application of SQL
> Server
> SP2 and any updates applied by the Windows Update program.
> The SQL Server 2005 installation was done on a fresh computer about
> December
> 5. This is a development machine with the Visual Studio, etc. installed.
> At this point, I cannot do anything with maintenance plans without getting
> the same error. Whether I go through the wizard or by hand, I cannot
> create a
> new MP, I cannot delete the existing MP and I cannot alter the existing
> MP.
>
> "John Bell" wrote:
|||Rom
I have no idea, sorry, probably you will need to re-install SQL Server 2005
and apply SP2
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:AD4BA58C-E05E-4A30-AD87-B2A9096CBA65@.microsoft.com...[vbcol=seagreen]
> Thanks for your help...
> The maintenance plan was created under SQL Server 2005 SP1 early in
> December
> using the maintnenance wizard. All it is supposed to do is to back the
> databases up to an internal drive. It worked OK until I installed SP2. The
> only thing that has changed on the machine is the application of SQL
> Server
> SP2 and any updates applied by the Windows Update program.
> The SQL Server 2005 installation was done on a fresh computer about
> December
> 5. This is a development machine with the Visual Studio, etc. installed.
> At this point, I cannot do anything with maintenance plans without getting
> the same error. Whether I go through the wizard or by hand, I cannot
> create a
> new MP, I cannot delete the existing MP and I cannot alter the existing
> MP.
> "Uri Dimant" wrote:
|||Hi Ron
Have you check the service pack log to see if there was any error when
installing SP2? What does SELECT @.@.VERSION return?
John