August 24, 2011 at 1:06 pm
Hello,
I recently took over the administration of our sql sever 2008 databases and I wanted to make some changes to the maintenance plans however when I try to modify the maintenance plan I receive the following error: Object reference not set to an instance of an object. (mscorlib).
I was getting this error first: could not load file or assembly 'msddsp, version=9.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or one of its dependencies. the system cannot find the file specified. (microsoft.datatransformationservices.design)
Thanks for any help
August 24, 2011 at 1:44 pm
i think this is because the client tools you are using are from SQL 2005, and not 2008;(that 9.0.0 stuff means 2005 to me)
can you try to do the same changes on the SQL 2008 instance directly, or update your client tools?
Lowell
August 24, 2011 at 1:47 pm
That is a typical .NET error that occurs if you try to reference a property or method of a class that has not been instantiated yet. This is coming from a .net assembly that is part of the database you are dealing with and it was unable to be loaded for whatever reason.
If you have restored the DB to another server make sure you have enabled CLR on that server and, if the assembly was installed as external access or unsafe that you change the database owner as necessary and make the DB trustworthy.
Edit: Having initially misread your post please ignore my response. I would concur with Lowell, make sure you are using the proper version of the client tools.
The probability of survival is inversely proportional to the angle of arrival.
August 24, 2011 at 1:51 pm
I see where the person before me installed SQL Server 2005 Analysis Services ADOMD.net and 2008 Analysis Services ADOMD.net. Could that be the cause? I see no other tools from a previous version.
August 24, 2011 at 1:54 pm
In SQL Server Managment Studio, if you do Help>>About, what version do you see?
here's mine for 2008:
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4961
Operating System 6.1.7600
Lowell
August 24, 2011 at 2:02 pm
Mine contains the following:
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.1600.22
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601
August 24, 2011 at 2:23 pm
That should be okay. There must be a missing library dll that is referenced by another assembly. the error: could not load file or assembly 'msddsp, version=9.0.0.0, is the clue.
I would try installing .NET 3.5 (or re-install 2.0 and the client tools) to try and fix it.
The probability of survival is inversely proportional to the angle of arrival.
August 25, 2011 at 12:54 pm
I was looking through some of the log files in the \Setup Bootstrap\Log\ directory and I noticed that there is an instance of SQLExpress installed on the this box. I then decided to see if there was a database engine attached to this install and there is however I don't see SQL Express in the program and features on the control panel. Could this be causing my issue and if so how can I remove SQL Express?
Thanks for your help.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy