Spotzo
asked on
Error from VS2008, requiring SQL Server 2005, refuses to acknowledge SQL 2008
Hi
I'm using Visual Studio 2008 SP1, trying to create a Web Project. When I attempt to add a new SQL database (an 'mdf' file), I get the message "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly."
I have SQL Server 2008 installed. I have set my instance in Tools->Options->Database Tools->Data Connections->SQL Server Instance Name to point to 'newdell1\sqlserver2008'.
I have been all over the web and MSDN to try to find a solution, but I can't seem to find one.
The Server Explorer in VS2008 allows me to work directly with SQL Server 2008. I just can't get the Sql Server database file template to create a SQL Server 2008 mdf.
I'm using Visual Studio 2008 SP1, trying to create a Web Project. When I attempt to add a new SQL database (an 'mdf' file), I get the message "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly."
I have SQL Server 2008 installed. I have set my instance in Tools->Options->Database Tools->Data Connections->SQL Server Instance Name to point to 'newdell1\sqlserver2008'.
I have been all over the web and MSDN to try to find a solution, but I can't seem to find one.
The Server Explorer in VS2008 allows me to work directly with SQL Server 2008. I just can't get the Sql Server database file template to create a SQL Server 2008 mdf.
ASKER
ragi0017- That is a direct cut-n-paste from MS ASP.NET forums, from some guy named Jian Kang at Microsoft. It doesn't solve the problem.
i know its a copy and paste
have you installed sql management studio to connect to your sql express databases.
have you got 2 versions of sql express - 2005 & 2008?
have you installed sql management studio to connect to your sql express databases.
have you got 2 versions of sql express - 2005 & 2008?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Attach the database files in SQL Server Management Studio, right-click the database name, choose Properties, then check Compatibility level in the Options tab.
If the Compatibility level of the newly created database files is "SQL Server 2005 (90)", I think maybe there are both SQL Server 2005 Express and SQL Server 2008 Express on your machine.
If so, please try to modify the SQL Server Instance Name in Visual Studio 2008.
Go to Tools -> Options -> Database Tools -> Database Connections, fill the SQL Server Instance Name with the name of SQL Server 2008 Express instance. Then create a new database in Visual Studio 2008 and check its version to confirm.