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

Filed under:
|

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

Related posts about asp.net-mvc

Related posts about sql-server