Visual Studio Website: Can't create an SQL Database!

Posted by Andreas on Stack Overflow See other posts from Stack Overflow or by Andreas
Published on 2010-02-16T20:55:19Z Indexed on 2010/03/24 6:03 UTC
Read the original article Hit count: 253

Filed under:

visual-studio-2008

|

sql-server-2008

|

local-database

Hi,

I'm using Visual Studio 2008 SP1 with SQL Server 2008.

I'am trying to add an SQL Server File (MDF) in my Website project. Then I get the following error:

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify...

I've been using Google without any results, and I'm in deep need for help..

I've tried the following things to fix it, without succes:

Changing instance names so they should fit
Attaching the database in the management studio
Uninstall/Install Visual Studio
Uinstall/Install SQL Server 2005 AND 2008

All in all, this is a REALLY annoying error and it just should work..

© Stack Overflow or respective owner

Related posts about visual-studio-2008

Server.transfer causing HttpException

as seen on Stack Overflow - Search for 'Stack Overflow'
I am developing a C#/SQL ASP.NET web application in VS 2008. Currently I am using the Server.Transfer method to transfer control from one ASPX.CS file to another ASPX file. The first time through, this works. But after control is transferred to this new file it encounters a condition: if (restart… >>> More
Using Visual Studio 2008 to Assemble, Link, Debug, and Execute MASM 6.11 Assembly Code

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to use Visual Studio 2008 to the greatest extent possible while effectively compiling/linking/building/etc code as if all these build processes were being done by the tools provided with MASM 6.11. The exact version of MASM does not matter, so long as it's within the 6.x range, as that… >>> More
Missing help files for Microsoft.WindowsMobile in Visual Studio 2008 help system

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just installed the Windows Mobile 6.5.3 DTK, both standard and professional. Before that I had the standard and professional Windows Mobile 6 SDKs. All Windows Mobile help pages are missing in Visual Studio 2008's help system - in particular everything in the Microsoft.WindowsMobile namespace… >>> More
Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using VS2008 to create a Compact Framework application for a Windows CE 5.0 device (Datalogic Kyman). I'm using SQL Server Compact 3.5 in my application. However, I'm debugging on a Kyman that still has Windows CE 4.2 installed (attached via USB using Mobile Device Center). My problem: VS2008… >>> More
Visual Studio 2008: Start custom build target via project/solution context menu - without add-in

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a custom build target in a visual studio 2008 c# project. Is there a simple way to add a context menu item to the project, so that the custom build target can be executed via the ide? The build target is not integrated into the default build process and has to be started by hand. This step… >>> More

Related posts about sql-server-2008

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
SQL Server 2008 to SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an MDF and LDF file of SQL Server 2005. i attached it with SQL Server 2008 and did some change in data. now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E:\DB\JOBPERS.MDF' cannot be opened because it is version 655. This server supports version… >>> More
SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to perform a database attach upgrade to SharePoint Foundation 2010. At this point I am trying to attach the content database to a Web application by using Windows Powershell: Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL>… >>> More
Uninstalling Reporting Server 2008 on Windows Server 2008

as seen on SQL Blog - Search for 'SQL Blog'
Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar… >>> More