Asp.net MVC database connection setting in Visual studio 2008
Posted
by AK47
on Stack Overflow
See other posts from Stack Overflow
or by AK47
Published on 2009-10-08T17:17:58Z
Indexed on
2010/04/02
15:43 UTC
Read the original article
Hit count: 198
asp.net-mvc
|sql-server
I am trying to learn Asp.net MVC framework. I was looking at the video tutorial at the link below http://www.asp.net/learn/mvc-videos/video-395.aspx In this video the very first step is to add a new database to the example application. I have visual studio installed on my development machine but the SqlServer Express is running on a different machine, so when I try and add a new database following the same steps as the video I get the following error
"Connections to SQL Server files(*.mdf) require SQL express 2005 to funciton properly. Please verify the installation of the component or download from the url"
I am assuming this is because Visual studio is looking for an instance of SQL express on my local machine and since it doesnt exist on the local machine,it errors out.
So how do i tell visual studio, to connect to a different machine and create the database there? I am using Visual studio 2008 with .net 3.5 Sp1
© Stack Overflow or respective owner