Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center > SQL Server Forums > SQL Server Tools > SSMS 2008 Exceptions

Answered SSMS 2008 Exceptions

    •  
      Friday, November 07, 2008 10:29 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      Hi guys!

      I have a fresh installation of SQL 2008 x86 on Vista Business. When I try to attach a database I get the following exception:

      TITLE: Microsoft SQL Server Management Studio
      ------------------------------

      Cannot show requested dialog.

      ------------------------------
      ADDITIONAL INFORMATION:

      Cannot show requested dialog. (SqlMgmt)

      ------------------------------

      Could not load type 'System.DateTimeOffset' from assembly 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. (Microsoft.SqlServer.DataStorage)

      ------------------------------
      BUTTONS:

      OK
      ------------------------------

      The requested assembly is in the assembly cache (I givr only values here):         mscorlib, Neutral, 2.0.0.0, b77a5c561934e089.
      Nothing is recorded in any event log.

      Any suiggestions? What goes wrong?
       

    Answers

    • Friday, November 07, 2008 5:28 PM
      Answerer
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      System.DateTimeOffset is new to .NET framework. It is supported in 3.5 SP1, 3.0 SP1 and 2.0 SP1 versions only.

       

      Even if you have either of the three versions installed on your machine, I guess some .NET version which doesn't support DateTimeOffset is parallely installed on your system, this conflict may also raise this issue.

       

      Ensuring appropriate .NET Assemblies are targetted should resolve this. If not, please update the thread with your findings.

       

       

    All Replies

    • Friday, November 07, 2008 5:28 PM
      Answerer
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      System.DateTimeOffset is new to .NET framework. It is supported in 3.5 SP1, 3.0 SP1 and 2.0 SP1 versions only.

       

      Even if you have either of the three versions installed on your machine, I guess some .NET version which doesn't support DateTimeOffset is parallely installed on your system, this conflict may also raise this issue.

       

      Ensuring appropriate .NET Assemblies are targetted should resolve this. If not, please update the thread with your findings.

       

       
    • Monday, November 10, 2008 11:31 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      Yes, that should be the reason. I installed VS2008 and everything's ok. Thanks!

       

       
    • Friday, November 28, 2008 11:01 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      i have SQL 2008 STD and vs2008 EXPRESS EDTNS installed on my win xp sp3 PC and the same error message comes up when i try attach a database. can the two work together or this is a bug when you have both applications on the same pc? i am now forced to uninstall VS2008 to get SQL 2008 to work efficiently. thank you
       
    • Friday, November 28, 2008 1:14 PM
      Answerer
       
       
      Sign In to Vote
      0
      Sign In to Vote

      If you are also getting the same error, then its the same problem. You should also look for which binaries are being targetted. You need to target .NET 3.5 SP1 binaries to avoid that error. So, make sure that you install Visual Studio Express SP1 and .NET 3.5 SP1 and then try attaching the database.