Using SQL Server 2005 Express and vs2008
I am trying to add a database to the App_data folder. When I do, I right-click, add new item, SQL Server Database, and then get the Local Database File dialog box saying Login failed for user 'MyMachine\Joe'.
However, if i go into server explorer, and add a new data connection, it works fine, and the database gets added to the instance, verified via SQL Mgmt Studio Express.
Could anyone offer any help as to what I am doing wrong when I try and add the local file, or what settings I should look at?
Thanks in advance, Joe