Databases
StackOverflow2013
Postsdbo
PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
    primarykey
    data
    text
    <p>I've been struggling for some time now to be able to use the built-in functions in Visual Studio 2008 to handle <code>*.mdf</code> database files with SQL Server 2008 Express. I'm running on an x64-based system, and I've read that there is a <a href="http://blogs.visoftinc.com/archive/2009/02/06/SQL-Express-2008-x64-Integration-with-Visual-Studio-2008-SP1.aspx#id_ed912867-3573-4bf4-9818-61a405dc3d91" rel="nofollow noreferrer">known problem</a> with this setup, but the <a href="http://support.microsoft.com/default.aspx/kb/957944" rel="nofollow noreferrer">hotfix</a> has not solved my problems.</p> <p>Basically, what happens is that when I try to add a new <code>*.mdf</code> file to the <code>App_Data</code> folder of a project, I get an error message saying:</p> <pre>Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251</pre> <p>My (unsuccessful) steps to solve this:</p> <ol> <li>Uninstall all possible associated programs to Visual Studio, SQL Server or .NET Framework (which left .NET 2.0 Compact Framework and .NET 3.5 Compact Framework, and nothing else .NET related, installed).</li> <li>Reboot.</li> <li>Install .NET 3.5 SP1, SQL Server 2008 Express and SQL Server Management Studio 2008 Express via the Web Platform Installer 2.0 (Beta).</li> <li>Reboot.</li> <li>Install Visual Studio 2008 Professional from disc.</li> <li>Reboot.</li> <li>Install Visual Studio 2008 Service Pack 1.</li> <li>Reboot.</li> <li>Install hotfix.</li> <li>Reboot.</li> <li>Start VS, create new Web site and try to add database. Still get the error message...</li> </ol> <p>When I look in the <code>Help/About</code> dialog, the hotfix shows up among applied updates. I have also checked and double-checked that the SQL Server instance name is correctly set in Visual Studio (I copy-pasted the instance name from the login screen in SSMS).</p> <p>Why does the hotfix not solve my problems? Am I doing things in the wrong order, or do I have the wrong software versions somewhere?</p> <p>According to the <a href="http://support.microsoft.com/default.aspx/kb/957944" rel="nofollow noreferrer">KB article</a>, the problem is that Visual Studio doesn't correctly detect "some registry keys" - but nothing is said about <em>which</em> keys. Does anyone know how to fix this manually?</p> <hr> <p>Oh, and yes - I've seen <a href="https://stackoverflow.com/questions/741417/visual-studio-2008-express-not-recognizing-my-sql-server-2008-express">this post</a>. I know I could just "downgrade" to the x86 version of SQL Server, but I really want to make this work with the x64 version (if nothing else, just because it's <em>supposed</em> to work...), so that solution doesn't really solve my problems. Please don't close this as a duplicate.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USTomas Lycken
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COserverfault.com??
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. USMitch Wheat
    2. COI'll ask there too, and update so that the solution is available in both places.
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. USTomas Lycken
    3. COdoesn't belong on serverfault, as this is CLEARLY programming related.
      singulars
      1. PO"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?
      1. USJeff Atwood
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload