Object reference not set to an instance of an object

  • 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

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 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.

  • 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.

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 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

  • 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.

  • 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