Unable to connect SQL Server instance from Visual Studio 2008 SP1 on Vista x64

Posted by Shimmy on Server Fault See other posts from Server Fault or by Shimmy
Published on 2009-06-26T11:53:25Z Indexed on 2010/05/17 1:40 UTC
Read the original article Hit count: 500

Filed under:

x64

|

sql-server-2005

|

visual-studio-2008-sp1

Hi folks!

I installed on a Vista x64 machine Visual Studio 2008 SP1 (with integrated SQL from the installation package) and when I try to add an MDF file to a project or to the App_Data when working with web, I get the following message:

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.

Just to make sure: SQL 2005 express is installed and I connect to it via SSMS.

Update: I am 90% sure that this is a Microsoft bug with x64 machines.

© Server Fault or respective owner

Related posts about x64

Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How to Dual Boot Windows 7 x64 and Ubuntu 13.04 x64 as BIOS, not EFI

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I want to dual boot windows 7 x64 and ubuntu 13.04 x64, but when I installed it, it doesn't boot. Only windows was booting. I installed ubuntu with " / " 50GB and a "swap" partition 4GB. Could it be that it doesn't work because I'm on bios mode, and that my disk is MBR, not GPT. My laptop doesn't… >>> More
Win7 x64 running on VMWare Workstation 6.5.2 on Win7 x64 crashes host on resume

as seen on Super User - Search for 'Super User'
I'm running Windows 7 x64 on top of Windows 7 x64 using VMWare Workstation 6.5.2. If I suspend the VM and then try to resume the host BSODs. I am able to successfully resume a different VM (running Windows 2003 x32). BlueScreenView says the culprit driver is vmx86.sys, at address vmx86.sys+3798… >>> More
SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

as seen on SQL Blog - Search for 'SQL Blog'
Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature). In addition to applying a cumulative update (2005 SP3 CU4 or 2008 SP1 CU2), in order to take advantage… >>> More
SQL Server v.Next (Denali) : OS compatibility & upgrade support

as seen on SQL Blog - Search for 'SQL Blog'
Microsoft's Manageability PPM Dan Jones has asked for our feedback on their proposed list of supported operating systems and upgrade paths for the next version of SQL Server. (See the original post ). This has generated all kinds of spirited debates on twitter, in protected mailing lists, and in private… >>> More

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More