Run aspnet_regsql on an SQL Server Express database in APP_DATA

Question

When I run the aspnet_regsql command in wizard mode, there is no way to select an SQL Sever Express database file even after specifying ".\SQLEXPRESS" in the database server name. How can I work around this?

As I remember there are shouldn't be problems with express version. Check if SQL service is running and that the username/password are correct. — Kamarey
– Kamarey, Commented Apr 21, 2011 at 6:37

Nimesh Madhavan · Accepted Answer · 2011-04-21 07:53:35Z

4

Found the answer here.

This can not be done from the wizard interface. The command line parameter to do this is: aspnet_regsql -A all -C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\MyProject\APP_DATA\aspnetdb.mdf"

answered Apr 21, 2011 at 7:53

Nimesh Madhavan

6,3287 gold badges48 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MattSull Over a year ago

Saved me so much hassle. I wonder why these annoyances cannot be solved easily.

Collectives™ on Stack Overflow

Run aspnet_regsql on an SQL Server Express database in APP_DATA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related