creating .mdf in ASP

I've been writing Windows apps for years now but to become familiar with web apps I'm working my way through some instructions to build a web site using a SQL database. The instructions assume I'm using VB Express but I'm using VB 2005 pro. I ran into a problem when the instructions said to right click on App_Data in the Solution Explorer and add a new SQL database item. I got the following error:

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

I do have SQL Server Express 2005 on my pc, it is running and I can use SQL Server Management Studio Express to connect to it.

I think the problem comes from the fact many of my windows apps use our production SQL Server 2000 database in the computer room. I expect that the production system is being seen as the default SQL Server by my pc and consequently the web app is trying to connect to it to create the database. I think I should be able to choose which server the database is created in somehow. Do you have any idea how I can force the web app to look at my pc's SQL Server Express?
.

Relevant Pages

  • inserting Turkish chars into sql server
    ... I have ASP.NET web app and SQL Server 2k database. ... The same results are produced when I run the query from the query analyzer. ...
    (microsoft.public.dotnet.framework.adonet)
  • DENY table SELECT, GRANT stored proc EXEC, but EXECUTE a string
    ... I am trying to prevent access to a SQL Server 2000 database from other ... I wrote a script that GRANTS EXECUTE to ... So members of the cps_ilp global group are able to run our web app ... Access is denied because SQL Server thinks we are SELECTing directly. ...
    (microsoft.public.sqlserver.security)
  • Best design for edit tracking?
    ... search through the database for the information they need. ... edit the core table above. ... Jane comes along and uses the research web app to hunt down some ... a SQL Server question, but the reality is that my web apps have to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upgrading MS Access 2003 database files to new SQL Server 2005 Express
    ... therefore I need step by step instructions. ... First as Mike said you will be better off asking in a SQL Server group. ... database is different, ... With small amounts of data, simple tables, and datatypes, you can usually ...
    (microsoft.public.vb.general.discussion)
  • Why does VS not support Sql Server 2000?
    ... reads data from a database and displays it in a datagrid. ... does not support SQL Server 200 databases? ... I have followed the instructions ... for installing MSDE, but the installer did not recognize my fully ...
    (microsoft.public.vsnet.ide)