none
Can't open SQL Server 2005 database ? RRS feed

  • Pregunta

  • I have set up VS 2008 SP1 and am using SQL 2005 SP2.   Also, I installed VS 2008 first, which puts in SQL Compact. And then install SQL 2005 Development.  I was having problems with the error message below - so I uninstalled SQL Compact and SQL 2005. And then did a clean install of SQL 2005 Developer with SP2 - and still get the error.

    I get the error after using the server explorer to select the server and then the database that's running on that server to open it. VS 2008 lets me test the database connection at that point - which does work.  But then when I try to add the database it says -

    Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0,0, Culture=neutral, ...or one of its dependencies The system cannot find the file specified.

    So far as I can see the specified file is Microsoft.SqlServer.Smo.dll.  My copy of this has a current version of 9.0.242.0 and sits within the SQL Server files. That is also the version number held in my registry.  I think 10.0.0.0 is the version in SQL 2008 but I haven't installed that.

    My understanding is also that VS uses System.data.dll to open the SQL database.  I am running to .net 2.0.50727 and the System.data.dll is 2.0.50727.3031 (netfxsp 050727-3000) - and there is no other System.data.dll on the computer

    This happens whether the database was created using Create Database through VS 2008 or SSMS.  And I can open the database in SSMS or VS 2005.

    Have I got the right version of System.data.dll - or are there any other possibly incompatible libraries?  Or any other ideas?

    Thanks
    • Cambiado Figo Fei jueves, 19 de junio de 2008 6:07 off topic and refer to the one delivered here: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3501090&SiteID=17
    martes, 17 de junio de 2008 8:43

Todas las respuestas